You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by "Paul J. Lucas" <pa...@mac.com> on 2005/05/14 02:36:45 UTC

IDENTITY_VAL_LOCAL() vs getGeneratedKeys()

 	I noticed that PreparedStatement has a getGeneratedKeys()
 	method.  I assume it's an alternate means of getting generated
 	key values that IDENTITY_VAL_LOCAL() would get.  So I tried it.
 	However, getGeneratedKeys() returns null.  I tried called
 	prepareStatement() with a second argument of an int[], but it
 	says "not implemented."

 	So is getGeneratedKeys() supposed to work?  Or must I use
 	IDENTITY_VAL_LOCAL() ?

 	- Paul

Re: IDENTITY_VAL_LOCAL() vs getGeneratedKeys()

Posted by Mamta Satoor <ms...@gmail.com>.

Hi Paul,
 org.apache.derbyTesting.functionTests.tests.jdbcap.autoGeneratedJdbc30.javaclass
has a test (search for Test 6 in that class) and you will see that
there is a positive test for PreparedStatement.getGeneratedKeys. Note that 
there is Statement.RETURN_GENERATED_KEYS passed to the 
Connection.prepareStatement. If you already do this and still get null from 
getGeneratedKeys for a single-row insert into a table with autogenerated 
key, then I will be curious into looking at the reproducible test case.
 Mamta

 On 5/13/05, Paul J. Lucas <pa...@mac.com> wrote: 
> 
> I noticed that PreparedStatement has a getGeneratedKeys()
> method. I assume it's an alternate means of getting generated
> key values that IDENTITY_VAL_LOCAL() would get. So I tried it.
> However, getGeneratedKeys() returns null. I tried called
> prepareStatement() with a second argument of an int[], but it
> says "not implemented."
> 
> So is getGeneratedKeys() supposed to work? Or must I use
> IDENTITY_VAL_LOCAL() ?
> 
> - Paul
>

Re: IDENTITY_VAL_LOCAL() vs getGeneratedKeys()

Posted by Satheesh Bandaram <sa...@Sourcery.Org>.

This is http://issues.apache.org/jira/browse/DERBY-201. Derby currently
has limitations getting auto generated columns.

Satheesh

Paul J. Lucas wrote:

>     I noticed that PreparedStatement has a getGeneratedKeys()
>     method.  I assume it's an alternate means of getting generated
>     key values that IDENTITY_VAL_LOCAL() would get.  So I tried it.
>     However, getGeneratedKeys() returns null.  I tried called
>     prepareStatement() with a second argument of an int[], but it
>     says "not implemented."
>
>     So is getGeneratedKeys() supposed to work?  Or must I use
>     IDENTITY_VAL_LOCAL() ?
>
>     - Paul
>
>
>