|
I apologize, in advance, for this newbie question as I’m just getting up to speed with SAPDb.
I’m having a problem when performing an update via JDBC. When I perform an update I appear to leak both row & table locks, although I leak update number of row locks, I leak fewer table locks. I made certain I committed the update and closed the statement after use.
I’m using SAPDB on Windows XP, running version 7.4.3.
Here’s the JDBC Driver info
Name: com/sap/dbtech/jdbc/ Specification-Title: Java Platform API Specification Specification-Version: 1.3.0 Specification-Vendor: Sun Microsystems, Inc. Implementation-Title: SAP DB JDBC Driver Implementation-Version: 7.4.4 Build 001-000-156-960 Implementation-Vendor: SAP AG
I connect to the db with this URL
jdbc:sapdb://myhost/myinstance?autocommit=off&isolation=TRANSACTION_SERIALIZABLE&reconnect=off&timeout=600
Any clues or ideas of what direction I should go in diagnosing this problem would be greatly appreciated.
Michael Gray Software Architect AptSoft, Corp. 20 Mall Rd, Suite 210 Burlington, MA 01803 Phone: 781-270-4900 Fax: 781-270-4904
Download our Featured White Paper at ebizQ.net. |
