Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

invalid timestamp error when using teradata as database

843859Dec 26 2007 — edited Dec 26 2007

Hi ,

I could not insert into teradata timestamp column . we tried many dateformats like YYYY-MM-DD HH:MI:SS.S(6) for teradata but nothing works .Is there any other date formats available for teradata .

I am using teradata 6.1 and JDK 5.0

Please help .

Error Message :

com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata DBMS] : Invalid timestamp.
at com.ncr.teradata.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:87)
at com.ncr.teradata.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:265)
at com.ncr.teradata.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:156)
at com.ncr.teradata.jdbc_4.statemachine.StatementController.runBody(StatementController.java:99)
at com.ncr.teradata.jdbc_4.statemachine.PreparedStatementController.run(PreparedStatementController.java:42)
at com.ncr.teradata.jdbc_4.Statement.executeStatement(Statement.java:252)
at com.ncr.teradata.jdbc_4.PreparedStatement.executeUpdate(PreparedStatement.java:97)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalPreparedStatement.executeUpdate(TeraLocalPreparedStatement.java:122)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate

Thanks ,
Chandra

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 23 2008

Added on Dec 26 2007

#java-database-connectivity-jdbc

2 comments

831 views