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
Dmitri Pissarenko wrote:
{
statement = aConnection.prepareStatement(
MyTable.INSERT_STATEMENT);
What is MyTable.INSERT_STATEMENT?
Thanks
Kathey
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,
field0
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.
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 duplicat
Hello!
I have a table in my database with a UNIQUE
--
http://www.xing.com/profile/Dmitri_Pissarenko
http://dapissarenko.blogspot.com/
Ø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,
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
