Re: Seg file not updating?

2008-08-13 Thread Øystein Grøvlen
Curry, David CIV NAVAIR 41K300D wrote: Vista, NetBeans 6.0, using embedded Derby driver. I have 2 apps that share a database. admin.jar is the admin app, demo.jar is a simple client that cannot change data in the database. Both apps are in the same folder, along with the database folder.

Re: Derby on 1.3 VM

2008-08-13 Thread John Embretsen
Jim Duffy wrote: We have a Palm OS Java Conduit that unfortunately is limited to running only on a 1.3 VM. We need this component to access our main Derby database to read some records. We are using the latest version of Derby and wanted to know if the source code could be compiled to work

RE: Seg file not updating?

2008-08-13 Thread Curry, David CIV NAVAIR 41K300D
Øystein, Thanks, figured that out last week, posted an update you might not have seen. That was it, sure enough. Dave From: Øystein Grøvlen [mailto:[EMAIL PROTECTED] Sent: Tue 8/12/2008 11:57 PM To: Derby Discussion Subject: Re: Seg file not updating? Curry,

Problem with UNIQUE constraint

2008-08-13 Thread Dmitri Pissarenko
Hello! I have a table in my database with a UNIQUE -- http://www.xing.com/profile/Dmitri_Pissarenko http://dapissarenko.blogspot.com/

Problem with UNIQUE constraint

2008-08-13 Thread Dmitri Pissarenko
Hello! I have a database table with a UNIQUE constraint. However, when I try to insert duplicate records, this happens without an exception (I'm using prepared statements). How can fix this problem, i. e. how can I achive that an exception is thrown, when my program attempts to insert a

Re: Problem with UNIQUE constraint

2008-08-13 Thread Craig L Russell
Hi Dmitri, It would help if you would show your DDL to define the table and a short program segment that would demonstrate the problem. I've not heard of such a problem. Craig On Aug 13, 2008, at 1:07 PM, Dmitri Pissarenko wrote: Hello! I have a database table with a UNIQUE constraint.

Re: Problem with UNIQUE constraint

2008-08-13 Thread Dmitri Pissarenko
Hello! Thanks for your answer! It would help if you would show your DDL to define the table Create table MyTable ( MyTableId BIGINT GENERATED ALWAYS AS IDENTITY, field01 Varchar(40) NOT NULL, field02 Timestamp NOT NULL, field03 Timestamp NOT NULL,

Re: Problem with UNIQUE constraint

2008-08-13 Thread Kathey Marsden
Dmitri Pissarenko wrote: { statement = aConnection.prepareStatement( MyTable.INSERT_STATEMENT); What is MyTable.INSERT_STATEMENT? Thanks Kathey

Re: Problem with UNIQUE constraint

2008-08-13 Thread Craig L Russell
The two Timestamp columns have resolution of nanoseconds, which you might not see depending on how you format the columns. Can you show two rows that have duplicate values? Thanks, Craig On Aug 13, 2008, at 2:30 PM, Dmitri Pissarenko wrote: Hello! Thanks for your answer! It would help