From: | "Vitali Petrov" <vitalipetrov(at)hotmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | TimeStamp problem... |
Date: | 2003-01-21 10:33:01 |
Message-ID: | F63AB4zss2UmFlzNF0q000059af@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Then I insert new values with timestamp into table I get an error:
Can anyone tell why?
Code:
PreparedStatement newPStat ...
newPStat.setTimestamp(1, Timestamp.valueOf("2003-01-21 12:25:14"));
newPStat.executeUpdate();
Error:
java.sql.SQLException: ERROR: pg_atoi: error in "2003-01-21
12:25:14.000000+02": can't parse "-01-21 12:25:14.000000+02"
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197)
at
rendifirma.RendiaktidTableModel.insertNewRow(RendiaktidTableModel.java:131)
Thanks.
_________________________________________________________________
MSN 8: advanced junk mail protection and 2 months FREE*.
http://join.msn.com/?page=features/junkmail
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Taylor | 2003-01-21 13:48:32 | Open Office |
Previous Message | Joel Hock | 2003-01-20 16:45:24 | Re: insertRow and updateable resultset |