db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren" <m.v.lunte...@gmail.com>
Subject Re: [jira] Commented: (DERBY-2654) Document newly-supported (in embedded mode) JDBC methods for autogenerated keys.
Date Tue, 29 May 2007 16:48:08 GMT
On 5/29/07, A B (JIRA) <jira@apache.org> wrote:
>    [ https://issues.apache.org/jira/browse/DERBY-2654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12499835
> A B commented on DERBY-2654:
> ----------------------------
> Thank you for committing this, Myrna.
> When I saw the commit message in my Inbox the parenthetical "(in embedded mode)" jumped
out at me--and only then did I realize that the documation as committed doesn't mention that
the relevant APIs only (currently) work in embedded mode.  That was my mistake--I completely
forgot to include that info in my original draft.
> Kim, would it be possible to post a follow-up patch to address this?  We would have to
add something to indicate that the following six methods are not suppoted in client/server
>  connection30.html:
>    prepareStatement(String sql, int [] columnIndexes)
>    prepareStatement(String sql, String [] columnNames)
>  statement30.html:
>    execute(String sql, int [] columnIndexes)
>    execute(String sql, String [] columnNames)
>    executeUpdate(String sql, int [] columnIndexes)
>    executeUpdate(String sql, String [] columnNames)
> Maybe the best place to put this is on the crefjavstateautogen.html page, where we now
> <begin>
> Users can indicate that auto-generated columns should be made available for retrieval
by passing one of the following values as a second argument to the Connection.prepareStatement,
Statement.execute, or Statement.executeUpdate methods:
>    * A constant indicating that auto-generated keys should be made available. The specific
constant to use is Statement.RETURN_GENERATED_KEYS.
>    * An array of the names of the columns in the inserted row that should be made available.
If any column name in the array does not designate an auto-increment column, Derby will throw
an error.
>    * An array of the positions of the columns in the inserted row that should be made
available. If any column position in the array does not correlate to an auto-increment column,
Derby will throw an error.
> <end>
> Would it be possible to add a note at the end of the second and third bullets?  Maybe
something like:  "Note: this is currently only supported when running in embedded mode."
> That's just a quick suggestion, though.  If there's a better way to relay this info,
feel free to go with it.
> Sorry for missing this earlier...

Maybe in addition, this could be added to the server guide where some
differences between client and server are documented? Or can we refer
in those docs to a bug? If so, we could refer to DERBY-310...


View raw message