RE: Bug in sap JDBC drivers and Jboss+SAP

Tue, 08 Oct 2002 03:48:55 -0700

Dear Ajit,
 
ad 1)
 
Please use the recent 7.3.0 driver available at http://www.sapdb.org. I assume you have an older release, which contained
such a problem. Anyway according to the spec _both_ methods will return false if the ResultSet is empty.
 
ad 2)
 
The 7.3.0 release does not provide an implementation of any of the javax.sql.* Interfaces. However, we recently
finished an _alpha_ version of the 7.4.3  driver with support of these interfaces. This driver is available at:
 
 
I tried the thing with JBoss 3.0, and it seems to work. Attached is also a sample service xml file for JBoss 3.0.
 
If you don't want the javax.sql stuff (most people don't want it), I encourage you to use the 7.3.0 driver. A sample
configuration is supplied by jboss itself, so please look at their site.
 
Regards
 
Alexander Schr�der
SAP Labs Berlin
-----Original Message-----
From: ajit_cus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 12:29 PM
To: [EMAIL PROTECTED]
Subject: Bug in sap JDBC drivers and Jboss+SAP

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.)

 

Any assistance will be mucho appreciated.

-Ajit

 

 

 

Attachment: sapdb-xa-service.xml
Description: Binary data

Reply via email to