Re: No suitable driver

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(at)processintelligence(dot)com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl