Hello, a JDBC-driver patch is available at: bin: ftp://ftp.sap.com/pub/sapdb/bin/java/sapdb-jdbc-bin-7.4.04.00a.jar source: ftp://ftp.sap.com/pub/sapdb/7.4/sapdb-jdbc-src-7.4.04.00a.jar
This patch fixes some small Bug in executeBatch() and positioning in resultsets. It also fixes the bug that an error -7065 occurs in conjunction with long column handling and autocommit sessions. Internally commands, generated by the dirver during garbage collection (close cursor, drop parseid), were also send as autocommit commands. This has been closed the subtransaction which the kernel generates around long column operations and has leaded to the error "-7065 SUBTRANS COMMIT/ROLLBACK not allowed without SUBTRANS BEGIN". Maybe this was also the reason for your problem. Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Andre Grosse [mailto:[EMAIL PROTECTED]] > Sent: Mittwoch, 13. November 2002 18:31 > To: [EMAIL PROTECTED] > Subject: Re: Strange: Error -7065 SAP DBTech SQL: [-7065] SUBTRANS > COMMIT/ROLLBACK > > > i have that problem too with JDBC. > many successfull row updates and sometimes i get this message. > > -- > Andre Grosse > > > [EMAIL PROTECTED] wrote: > > > Hello > > > > I think it's important to report messages like that to the > mailinglist > > because it is an important information for the developers > as well as for > > others that have the same problem to know that there > (really) seems to > > be a problem. > > > > We did not find a solution/explanation, no. The mistake > occured two or > > three times but is - I guess - not a deterministic failure > and thus very > > difficult to reproduce. > > > > Toni Epple wrote: > > > > >Hallo Gabriel, > > > > > >ich habe Deine Mail "Strange: Error -7065 SAP DBTech SQL: [-7065] > > >SUBTRANS COMMIT/ROLLBACK " im August-Forum von sapdb > gefunden. Da ich im > > >Forum keine Antwort auf Deine Frage entdeckt habe, wende > ich mich direkt > > >an Dich: Ich habe exakt dasselbe Problem. Beim insert > eines long byte > > >bekomme ich nach ca 10000 erfolgreichen inserts die Exception. Der > > >entsprechende Eintrag wird jedoch ausgef�hrt. Hast Du eine > Erkl�rung > > >und/oder Abhilfe gefunden? > > > > > >dankbar f�r jede Hilfe ;) > > > > > >Toni Epple > > > > _______________________________________________ > 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
