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.putSpecific(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

Reply via email to