Zabach, Elke wrote:
Dirk Zoettl wrote:
I removed my 7.3.0.20 version and installed 7.3.0.29 .
Trying the lock option IGNORE will give an exception. Is it usable on 7.4 only ?
getDatabaseProductVersion : "Kernel 7.3.0 Build 029-000-087-809"
getTransactionIsolation : TRANSACTION_READ_COMMITTED
com.sap.dbtech.jdbc.exceptions.DatabaseException: SAP DBTech SQL: [-3008] (at 31) Invalid keyword or missing delimiter
Sincerely,
Dirk Z�ttl
Mhm, if we are talking about internal mode and the syntax
... WITH LOCK (IGNORE)
which results in the error given above, then please provide
a vtrace to see how the statement exactly looks like which
is send to the SQL-parser.
please see :
http://sapdb.2scale.net/moin.cgi/VTrace
Elke
SAP Labs Berlin
Hi Elke,
I missed the braces - they are required. I should have had a closer look at the docs.
The test application is working now after appending " WITH LOCK (IGNORE)" .
Thank you very much and viele Gr��e nach Berlin,
Dirk Z�ttl
--
_____________________________________________________
| |
| tangro software components gmbh |
| |
| dirk zoettl phone: +49 6221 13336-0 |
| czernyring 22/10 fax: +49 6221 13336-21 |
| d-69115 heidelberg email: [EMAIL PROTECTED] |
| germany internet: www.tangro.de |
|_____________________________________________________|
.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
