Subject | Error while inserting timestamp value. |
---|---|
Author | raghoos_2000 |
Post date | 2003-08-28T10:55:22Z |
Hi,
While I am trying to insert data by calling stored procedure,which
has timestamp column,it raises the following exception
at org.firebirdsql.gds.GDSException: conversion error from
string "2003-08-28 19:46:19.0000"
at org.firebirdsql.jgds.GDS_Impl.readStatusVector
(GDS_Impl.java:1698)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse
(GDS_Impl.java:1651)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_execute2
(GDS_Impl.java:856)
at org.firebirdsql.jca.FBManagedConnection.executeStatement
(FBManagedConnection.java:787)
at org.firebirdsql.jdbc.FBConnection.executeStatement
(FBConnection.java:1097)
at org.firebirdsql.jdbc.FBPreparedStatement.internalExecute
(FBPreparedStatement.java:420)
The character set for database is SJIS_0208.
Its working fine when the default character set is set as none.
Any idea's why the exception is occuring?
Thanks in advance.
Regards,
Ragavendra.
While I am trying to insert data by calling stored procedure,which
has timestamp column,it raises the following exception
at org.firebirdsql.gds.GDSException: conversion error from
string "2003-08-28 19:46:19.0000"
at org.firebirdsql.jgds.GDS_Impl.readStatusVector
(GDS_Impl.java:1698)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse
(GDS_Impl.java:1651)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_execute2
(GDS_Impl.java:856)
at org.firebirdsql.jca.FBManagedConnection.executeStatement
(FBManagedConnection.java:787)
at org.firebirdsql.jdbc.FBConnection.executeStatement
(FBConnection.java:1097)
at org.firebirdsql.jdbc.FBPreparedStatement.internalExecute
(FBPreparedStatement.java:420)
The character set for database is SJIS_0208.
Its working fine when the default character set is set as none.
Any idea's why the exception is occuring?
Thanks in advance.
Regards,
Ragavendra.