On 17/02/2014 11:29, Bob M wrote:
Hi John
I am having difficulty following your latest message.........sorry :(
I don't understand where to give constraints names?
Is it when I set up the table?
Yes, replace PRIMARY KEY(x) with CONSTRAINT c PRIMARY KEY(x) in the table
definition. See http://db.apache.org/derby/docs/10.1/ref/rrefsqlj42154.html
derby.properties - I have no idea where / what that is?
Create a file in the startup directory (where derby.log should also be)
containing this line:
derby.language.logStatementText=true
See http://db.apache.org/derby/docs/10.1/tuning/ctunsetprop13074.html
HTH,
--
John English
