Connection via jdbc to Max DB from jsp

[Former Member]

Hello everybody,

I’ve got a problem with connecting to SAP DB via JDBC from a jsp. I’m using WAS 6.40 SP 9 Snake Preview on Max DB.

Here is the story:

I’m tying to use a web based query tool called ART (http://sourceforge.net/projects/art/). So I’ve downloaded the war file (war.art) and deployed it successfully to the SAP j2ee engine. I’ve tested it, and it seemed to work fine (I can call all jsp-s). But when I try to connect to the SAP DB, I get the following Error: ClassNotFound. I use the following URL and driver: jdbc:sapdb://ip_address/db_name,

com.sap.dbtech.jdbc.DriverSapDB

I’ve imported the jdbc driver with visual administrator (JDBC connections -> new driver). But there was still this error. I’ve found out, that in the core_lib library, there is already this sapdbc.jar file.

I’ve done following, to get this tool working:

1. I’ve unzipped the art.war

2. I’ve added the sapdbc.jar to the web-inf/lib folder.

3. I’ve zipped it

4. and deployed,

and it works fine.

But I don’t like this solution. So my question is:

how can I use the jdbc driver, without changing the web archive (art.war) file.

Any help appreciated

Pawel

[former_member633453]

i hope this help you

1. with visual administrator upload the archives jdbc... this jdbc not is the same that use your instance SAP

2. verify the jdbc creating a datasource and this section exist a section the test..

use the Natve SQL

in VA:

/cluster/services/jdbc_connector