Hello everybody,
Ive got a problem with connecting to SAP DB via JDBC from a jsp. Im using WAS 6.40 SP 9 Snake Preview on Max DB.
Here is the story:
Im tying to use a web based query tool called ART (http://sourceforge.net/projects/art/). So Ive downloaded the war file (war.art) and deployed it successfully to the SAP j2ee engine. Ive 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
Ive imported the jdbc driver with visual administrator (JDBC connections -> new driver). But there was still this error. Ive found out, that in the core_lib library, there is already this sapdbc.jar file.
Ive done following, to get this tool working:
1. Ive unzipped the art.war
2. Ive added the sapdbc.jar to the web-inf/lib folder.
3. Ive zipped it
4. and deployed,
and it works fine.
But I dont 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