RE: Bug in sap JDBC drivers and Jboss+SAP

Tue, 08 Oct 2002 04:39:06 -0700

Oops.
 
Apparantly the driver at the web site was not current and was not updated some time.
Now, the driver is updated, and hopefully all should work as expected.
 
It can be found under
 
 
java -jar sapdbc.jar -V should emit
 
package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG, 7.3.0    Build 028-000-087-392
 
(just for you to verify that you didn't get a cached file).
 
Regards
 
Alexander Schr�der
SAP Labs Berlin
-----Original Message-----
From: ajit_cus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 1:16 PM
To: Schroeder, Alexander
Subject: RE: Bug in sap JDBC drivers and Jboss+SAP

I downloaded the driver and source yesterday. So I assume I have the latest.

 

-----Original Message-----
From: Schroeder, Alexander [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 4:41 PM
To: ajit_cus; '[EMAIL PROTECTED]'
Subject: RE: Bug in sap JDBC drivers and Jboss+SAP

 

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

 

 

 

Reply via email to