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
