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.newGetException(DBTechTranslator.java:1096)
        at 
com.sap.dbtech.jdbc.translators.DBTechTranslator.getLong(DBTechTranslator.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

Reply via email to