Hello Marco, hello all,
We never had the ability to check if we could reproduce the problem
reported below again. But we now have a similar testcase that produces
the same error code ([-7065] SUBTRANS COMMIT/ROLLBACK).
I think this is a bug, too, as we have the same feature as reported
before, which is: the row is inserted (including the value for the
column of type long) altough the above exception is thrown.
This bug must be a different (but similar) bug, which is not caused by
garbage collection but by a concurrent use of a SELECT and an INSERT
statement (by two corresponding PreparedStatement Objects). The problem
seems to be deterministic and I think it should be possible to write a
testcase that can show the bug.
We now use the following JDBC-Driver: 7.6.0 Build 012-000-004-339
I guess that the exception is thrown in this case (or similar):
1. Start INSERT row (by PreparedStatement)
2. Read another row of this table by SELECT (by another PreparedStatement)
3. End INSERT row
I guess that at step 2./3. the above Exception -7065 is thrown altough
the insert was already done.
Of course there are two Threads in this example: one that calls step
1./3. and the other Thread calls step 2.
I think that the described concurrent use should be correct (as I
understand the JDBC specification).
Thank you for any comment.
Gabriel Matter
Invoca Systems
Paskamp, Marco wrote:
> 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
>>>>>>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.