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?
derby.properties - I have no idea where / what that is?
I am using netbeans IDE to view and modify the odd record from time to time
I
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
Thanks for taking the time to respond Mamta. I have been through those and I
did find the chat very difficult to follow ;)
I am surprised that it did not dump out the lock table when this occurred as I
have the following in my derby.properties:
#Java DB Properties File
On 2/17/14 2:03 AM, John English wrote:
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
We need to be able to push changes from a master database to several
read-only slaves. In many situations, they have no network at all and move
files around on memory sticks. They operate in remote locations where
networks are impossible. They need to provided updates once a day to
stakeholders
We have attempted this with a several different variations. We have not been
able to make it work. Has anyone successfully synced data with a client by
manually shipping logs?
Peter Haynes
Pariveda Solutions
24 East Greenway Plaza | Suite 1717 | Houston, Texas 77046
(M) 713.408.8072 | (F)
Hi guys (John and Rick)
Thank you for your considerations (even though they are a bit above my level
of comprehension)
I have added a constraint a follows:-
CONSTRAINT tablekey_pk PRIMARY KEY(Trading Date, Trading_Time)
however, lets step back a bitafter reading your suggested