Skip to Content
0
Former Member
Apr 09, 2005 at 02:04 PM

Connection via jdbc to Max DB from jsp

42 Views

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