Hello, the analyze of the JDBC-tracefiles (sent outside of the mailing list) shows that there is a serious bug in the JDBC-driver version 7.3.00.21. The error occurs if you are using PreparedStatement's in conjunction with the batch mode and don't set all of the parameters of the PreparedStatement. Then the driver uses an internal inital String value "initParam" for all not explicit set paramters. Normally this leads to an exception in one of the conversion methods. But in the worst case if the corresponding table column is a character column the inital value will be stored in the database. I will fix this bug and make a patch for the JDBC-driver available very soon.
Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Raimund Jacob [mailto:[EMAIL PROTECTED]] > Sent: Samstag, 16. M�rz 2002 01:41 > To: SAPDB General list > Subject: JDBC: SELECT in batch mode > > > hi *, > > i am trying to select multiple rows given the primary keys > (or parts of > that). i was told (on that list, several months ago) that i could use > SELECT in batch mode (prepareStatement(), setXXX(), addBatch() and > exute[Query]()). Unfortunately the ResultSet does not contain > the union > of the individual result sets but only the last one. is this a bug? is > it supposed to be that way? > > on a perhaps related note: i think there is a bug in the jdbc driver: > > com.sap.dbtech.jdbc.translators.BinaryDataTranslator.putSpecif > ic(BinaryDataTranslator.java:45) > > contains a cast from some Object into a byte[]. When i try to do > batch-SELECTs this results in a ClassCastException because > the object is > actually a java.lang.String. > > so: either this particular translator is not used correctly in some > cases or batch-selects are not allowed. if this is the case some good > exception should be thrown. > > thanks for any advice, > Raimund > > -- > Raimund Jacob > \|/ ____ \|/ > Pinuts Media+Science GmbH "@'/ ,. \`@" > Potsdamer Str. 96 /_| \__/ |_\ > D-10785 Berlin \__U_/ > http://www.pinuts.de/ voice: +49 30 590090313 fax: +49 30 590090390 > _______________________________________________ > 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
