db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John English <john.fore...@gmail.com>
Subject Re: adding a record to a table
Date Mon, 17 Feb 2014 10:03:51 GMT
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

Mime
View raw message