Hi Marco, that may be, but the type of the field TIMESTAMP is INTEGER, so the conversion should work. So it still seems to be a bug.
Regards, /\/\ichael >>> "Paskamp, Marco" <[EMAIL PROTECTED]> 21.03.02 15:13:27 >>> Hello, i would say it's a not supported conversion and not a bug. In the JDBC-standard is specified that only getObject, getString, getDate, getTime and getTimestamp must be suported for timestamp columns. All other getXXX-methods are optional for timestamp columns. However, I will try to implement this conversion in one of the next version of the JDBC-driver. BTW, I think your tabld definition is CREATE TABLE EPK_TBL( ..., TIMESTAMP TIMESTAMP NOT NULL), and not CREATE TABLE EPK_TBL( ..., TIMESTAMP INTEGER NOT NULL) ??? Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Michael Lupp [mailto:[EMAIL PROTECTED]] > Sent: Donnerstag, 21. M�rz 2002 14:46 > To: [EMAIL PROTECTED] > Subject: JDBC: Problem with reading TIMESTAMP field > > > Hi, > > I have the following table: > > CREATE TABLE EPK_TBL(ID INTEGER NOT NULL, STATE INTEGER NOT > NULL, TIMESTAMP INTEGER NOT NULL) ; > > and I have the following statement: > > SELECT STATE,TIMESTAMP FROM TEST_TBL WHERE ID=1; > > I think this should work, but when I try to read the > TIMESTAMP value out of the result set, I get this error: > > com.sap.dbtech.jdbc.translators.ConversionExceptionSapDB > Cannot convert SQL TIMESTAMP to Java long > > com.sap.dbtech.jdbc.translators.ConversionExceptionSapDB: > Cannot convert SQL TIMESTAMP to Java long > at > com.sap.dbtech.jdbc.translators.DBTechTranslator.newGetExcepti > on(DBTechTranslator.java:1096) > at > com.sap.dbtech.jdbc.translators.DBTechTranslator.getLong(DBTec > hTranslator.java:566) > at > com.sap.dbtech.jdbc.ResultSetSapDB.getLong(ResultSetSapDB.java:1043) > > > I think this is an error in the JDBC driver, or do I something wrong? > > > Best, > > /\/\ichael > > ----- > Michael Lupp > Diplom-Informatiker (Senior Software Engineer) > Process Performance Management > IDS Scheer AG > Altenkesseler Stra�e 17, Geb. C2, D - 66115 Saarbr�cken > Tel. +49(0)681/210-3806, e-mail: [EMAIL PROTECTED] > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
