Hello! > Hi, > > 1> According to jdbc specs the ResultSet.isBeforeFirst method must return false if >the result set contains no rows. > SAP JDBC implementation actually returns true!!! IsAfterLast however returns true. > > 2>Does anybody know how to create a SAP DB connection pool in JBOSS? The usual xml >config(problem is with the transaction manager part) works incorrectly seemingly >because The current release of the JDBC driver does not support javax.sql.*. (effect: >Jboss Alternates between autocommit on and of causing weird table locking issues.) What exactly do you mean with "the usual XML config" and the "problem is with the transaction manager part"??
We have JBoss 2.4.4/SapDB 7.3.0.23 running an see apparent problems with the transaction manager, like: "[13:13:36,113,TxCapsule] Transaction XidImpl [FormatId=257, GlobalId=web01//8964, BranchQual=] timed out. status=STATUS_ACTIVE" The only thing which helps is restarting JBoss. Could this be a JDBC Driver problem? After restarting JBoss everything works fine again. On a bad day we have to restart JBoss three times or more often, sometimes the whole thing runs stable for a whole week or longer. The JDBC Driver version is package com.sap.dbtech.jdbc, "SAP DB JDBC Driver", "SAP AG", "7.3.0 Build 023-000-085-131" Thank you for your help, patrick _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
