Hi! please tryout the newest jdbc driver available at: ftp://ftp.sap.com/pub/sapdb/bin/java/sapdbc.jar. If the problem still occurs I need some more informations. Do you have a repeatable test case I could use? Also a vtrace (http://sapdb.2scale.net/moin.cgi/VTrace) or at least a jdbc trace (http://sapdb.2scale.net/moin.cgi/JdbcTrace) would be very helpful.
Thanks! Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Samstag, 21. Juni 2003 11:10 > To: Paskamp, Marco; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: Re: Strange: Error -7065 SAP DBTech SQL: [-7065] SUBTRANS > COMMIT/ROLLBACK > > > Hello All, > > The documented problem still occured twice when inserting > around 500'000 > rows into a newly created instance of sapdb (Kernel 7.4.3 Build > 024-121-045-802). > > The JDBC-driver was sapdb-jdbc-bin-7.4.04.00d.jar, so the > patch which is > mentioned below does not solve that problem. > > The behaviour was exactly the same, as reported on 31 Aug 2002: > > ... > We use a Java-Tool to insert data automatically into several > tables with > the execution of preparedStatements of the form > > 'INSERT INTO <table_name> VALUES (?, ?, ?, ?<,...>)' > > The tool works single-threaded, so no problem should be caused by > concurrency. > > => When inserting around 500'000 Rows into the database it happened > during two insert-operation that the JDBC-Driver has thrown the > following exception: > > ERROR: SAP DBTech SQL: [-7065] SUBTRANS COMMIT/ROLLBACK not allowed > without SUBTRANS BEGIN > ... > > > Thanks for any comment. (The vtrace is not available). > > G. Matter > > _____________________ > > Invoca Systems > Hauptstr 92 > 4422 Arisdorf > http://www.invoca.ch > _____________________ > > > "Paskamp, Marco" schrieb: > > > > 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
