Still problems with identity.

[Laurent ROCHE <la...@yahoo.com>]

Hi,

I am still having problems with identity.

I want to insert in a Derby database rows of a table with an idetity column but using the values from data.xml not generated values.
I have set useexplicitidentityvalues ="true" ... but that does not change a thing !

Tom, I am posting you the files for a test case, in case you want to have a look at it.
(anyone else interested, I can mail you the stuff too).

Has anybody manage to get this working ?
I hope we can get it to work.
Thanks in advance for any help.
 

Cheers,
L@u
The Computing Froggy




	

	
		
___________________________________________________________________________ 
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses 
http://fr.answers.yahoo.com

Re: Still problems with identity.

["Jean T. Anderson" <jt...@bristowhill.com>]

Laurent ROCHE wrote:
> Hi,
> 
> I am still having problems with identity.

I've only been partially following these discussions, so I apologize if
I'm missing information that has already been posted.

> I want to insert in a Derby database rows of a table with an idetity column but using the values from data.xml not generated values.
> I have set useexplicitidentityvalues ="true" ... but that does not change a thing !

Is this a Derby identity column? If so, what's the column definition for
the identity column in the Derby table? "generated by default" lets you
specify an explicit value but "generated always" does not:

  http://db.apache.org/derby/docs/10.2/ref/rrefsqlj37836.html

Here's one way to verify the Derby schema (substitute "dbname" for your
actual database name):

  java org.apache.derby.tools.dblook -d jdbc:derby:dbname -o dbname.sql

dblook docs are here:

  http://db.apache.org/derby/docs/10.2/tools/ctoolsdblook.html

10.2 also has a new "describe" command:

  http://db.apache.org/derby/docs/10.2/tools/rtoolsijcomrefdescribe.html

regards,

 -jean


> Tom, I am posting you the files for a test case, in case you want to have a look at it.
> (anyone else interested, I can mail you the stuff too).
> 
> Has anybody manage to get this working ?
> I hope we can get it to work.
> Thanks in advance for any help.