Обсуждение: No suitable driver
I have Tomcat 3.2.1 and Postgres 7.0.3 running well in Solaris and I have installed the JDBC driver, jdbc7.0-1.2.jar, in both the <TOMCAT_HOME>/lib and a second directory off of the tomcat tree. With the jar file in the classpath the driver works fine from an application but produces the error "No suitable driver" when called from within a servlet. Having combed through the jdbc mailing list I have tried placing the jar file in the <TOMCAT_HOME>/lib (a restart of tomcat references the existence of the jar file in its output) and I have set the driver's path for wrapper.classpath in tomcat.properties for the parameter wrapper.classpath and set the driver name for wrapper.bin.parameters. Is there anyone who might have some advise about whatelse needs to be done for this? -Peter Mezzina pmezzina@processintelligence.com
Try passing the driver in the command line, like this: java -Djdbc.drivers=org.postgresql.Driver ...
-----Original Message-----
From: Peter Mezzina [mailto:pmezzina@processintelligence.com]
Sent: Friday, June 15, 2001 2:58 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] No suitable driver
I have Tomcat 3.2.1 and Postgres 7.0.3 running well in Solaris and I
have installed the JDBC driver, jdbc7.0-1.2.jar, in both the
<TOMCAT_HOME>/lib and a second directory off of the tomcat tree. With
the jar file in the classpath the driver works fine from an application
but produces the error "No suitable driver" when called from within a
servlet. Having combed through the jdbc mailing list I have tried
placing the jar file in the <TOMCAT_HOME>/lib (a restart of tomcat
references the existence of the jar file in its output) and I have set
the driver's path for wrapper.classpath in tomcat.properties for the
parameter wrapper.classpath and set the driver name for
wrapper.bin.parameters.
Is there anyone who might have some advise about whatelse needs to be
done for this?
-Peter Mezzina
pmezzina@processintelligence.com
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
This error occurs in JDBC when you don't register the driver in the JVM before trying to use it. You need this line before you can get a connection from the database: Class.forName( "org.postgresql.Driver" ); // Or substitute whatever driver you are using... Matty Peter Mezzina wrote: > I have Tomcat 3.2.1 and Postgres 7.0.3 running well in Solaris and I > have installed the JDBC driver, jdbc7.0-1.2.jar, in both the > <TOMCAT_HOME>/lib and a second directory off of the tomcat tree. With > the jar file in the classpath the driver works fine from an application > but produces the error "No suitable driver" when called from within a > servlet. Having combed through the jdbc mailing list I have tried > placing the jar file in the <TOMCAT_HOME>/lib (a restart of tomcat > references the existence of the jar file in its output) and I have set > the driver's path for wrapper.classpath in tomcat.properties for the > parameter wrapper.classpath and set the driver name for > wrapper.bin.parameters. > > Is there anyone who might have some advise about whatelse needs to be > done for this? > > -Peter Mezzina > pmezzina@processintelligence.com > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl