Re: Problem with UNIQUE constraint

2008-08-14 Thread Dmitri Pissarenko
Hello! { statement = aConnection.prepareStatement( MyTable.INSERT_STATEMENT); What is MyTable.INSERT_STATEMENT? public static final String INSERT_STATEMENT = INSERT INTO MyTable (field01, + field02, field03, field04, field05, field06, + field07, field08, field09,

Re: Problem with UNIQUE constraint

2008-08-14 Thread Dmitri Pissarenko
Hello! On Thu, Aug 14, 2008 at 12:38 AM, Craig L Russell [EMAIL PROTECTED] wrote: The two Timestamp columns have resolution of nanoseconds, which you might not see depending on how you format the columns. I don't think that there is a problem with timestamp because I explicitly call

Re: Problem with UNIQUE constraint

2008-08-14 Thread Dmitri Pissarenko
Hello! I found the problem - in one of the timestamps, nanos were not set to zero. Thanks for the hint! Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko