JDBC driver help - ConversionExceptionSapDB

[Vipul Manglik]

Hi All,

I am currently integrating a rules engine QuickRules to work with SapDB. I am using version 7.3 of SapDB on Windows 2000 and JDK 1.3
The QuickRules requires couple of tables with 'BLOB's for which I am using LONG BYTE data type of SapDB. When getting data out of the database, we get the following exception (pls see below).

[java] com.sap.dbtech.jdbc.translators.ConversionExceptionSapDB: Cannot rea
d ASCII data from this LONG column.
[java] at com.sap.dbtech.jdbc.translators.StreamTranslator.getAsciiStre
am(StreamTranslator.java:60)
[java] at com.sap.dbtech.jdbc.translators.StreamTranslator.getCharacter
Stream(StreamTranslator.java:101)
[java] at com.sap.dbtech.jdbc.translators.StreamTranslator.getString(St
reamTranslator.java:242)
[java] at com.sap.dbtech.jdbc.ResultSetSapDB.getString(ResultSetSapDB.j
ava:1237)
[java] at com.yasutech.versioncontrol.DatabaseEntityVersionPersistenceH
andler.setAndTestConnection(DatabaseEntityVersionPersistenceHandler.java:104)

I tried to change the data type from LONG BYTE to just LONG, but that causes some other problems.Any ideas what can be done about this?

Thanks
Vipul Manglik
Moveit Pty Ltd

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general