aspose file tools
The moose likes Servlets and the fly likes JDBC Drivers - No Suitable Driver - NIGHTMARE !! Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » Servlets
Reply Bookmark "JDBC Drivers - No Suitable Driver - NIGHTMARE !!" Watch "JDBC Drivers - No Suitable Driver - NIGHTMARE !!" New topic
Author

JDBC Drivers - No Suitable Driver - NIGHTMARE !!

Steven Briggs
Greenhorn

Joined: Jul 20, 2001
Posts: 6
I'm having a nightmare trying to use JDBC 2.0 drivers for SQL Server. I'm
using JRun, and understand that the drivers must go into the class path,
which is <JRun home dir>/lib/ext, or <approot>/WEB-INF/lib, or
<approot>/WEB-INF/classes etc however, even when I put the driver jar files
into one of these directories, I still get the error "No Suitable Driver".
I've tried a number of different drivers (all 30 day trial ones), the only
ones I can get to work are ones that I can undo the jar file and put the
class directory into the same directory as my application - even this only
works if those jar files are self reliant and ond't require other classes.
The other I can get to work using JDBC test utilites, I know the problem
lies in the JRun classpath, but I don't know what.
Any ideas, I'm getting desperate. The JDBC-ODBC driver just isn't up to what I want
to do.
Thanks
Dorj Galaa
Ranch Hand

Joined: May 29, 2001
Posts: 113
copy rt.jar to JRUN classpath


Senior software engineer
Steven Briggs
Greenhorn

Joined: Jul 20, 2001
Posts: 6
I'll try that, but what and where is rt.jar?
Thanks
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: JDBC Drivers - No Suitable Driver - NIGHTMARE !!
 
Similar Threads
Database driver not found
Externally hosted Tomcat: How to use DB-Driver if not in %CATALINA-HOME%/lib ???
Build.xml in Ant.
Problem with DB2 in Web Project
Datasource Problem