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
reading
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) 713.5
What about using the database backup with roll-forward recovery?
http://db.apache.org/derby/docs/10.10/adminguide/index.html
I am not sure if this would work if one were to transfer a copy of the database
to a slave and enable log archival mode and then periodically transport the
archived logs
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 who
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 KEY
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
#derby.language.logState
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://
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