Hello, if you want to store character data in your long columns you should use the column type LONG ASCII (or LONG UNICODE). But if you really want to store binary data the column type LONG BYTE is correct. But then you should use getBytes() (or getBinaryStream()) for retrieving the long data from the resultset instead of using getString().
Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Vipul Manglik [mailto:[EMAIL PROTECTED]] > Sent: Mittwoch, 4. Dezember 2002 02:57 > To: [EMAIL PROTECTED] > Subject: JDBC driver help - ConversionExceptionSapDB > > > 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(DatabaseEntityVersionPersistenceHa > ndler.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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
