RE: JRun 3.1/JDBC Driver Error "No Suitable Driver"

[PELOQUIN,JEFFREY (Non-HP-Boise,ex1)]

Kreighan,

We have seen something like this connecting to oracle using jrun 2.3.3 build
155 on hp-ux.  Never was very reproducible.  When it would happen we would
use Class.forName e.g.
String dbDriverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(dbDriverName);

Jeff Peloquin

-----Original Message-----
From: McAuliffe, Kreighan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 5:37 PM
To: JRun-Talk
Subject: JRun 3.1/JDBC Driver Error "No Suitable Driver"


Hi all,

We've been trying to upgrade to JRun 3.1 (on an NT/IIS server) and have run
into a dead end with a "No Suitable Driver" error when an application tries
to connect to a Sybase 11.5 database.  This occurs with either the JConnect
v.4.0 OR v4.2 JDBC driver from Sybase. 

Here's the background: 

.We have no problem running under the old version of JRun 2.3.3 build 158
(also on a NT/IIS server) using the JConnect v.4 JDBC driver from Sybase and
the same application codebase.

.We have checked the classpaths a gazillion times; also the URL and driver
names.  Although the application does not use data source names, we have
successfully set up and tested JRun datasources specifying the JConnect
driver, as per the JRun documentation.  We also successfully ran the java
test program supplied with JConnect (not in JRun - runs at the command
line.)

..We have installed the latest driver patches from JRun's web site.  

..We contacted Allaire under their purchased "Bronze" support program.
The Allaire person simply e-mailed a copy of the documentation page that
says to check the driver and URL names, which we've already done.  

A specific question I have is whether JRun requires that the driver class
files be in a jar file...?  

Any suggestions?

Thanks,

Kreighan McAuliffe
Applications & Data Services
Washington State Department of Ecology
[EMAIL PROTECTED]




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists