tomcat/JDBC

[Bob Solkovy <bo...@usis.com>]

Hello,

	I am attempting to access a postgresql database thru a JSP
application and keep getting a
            'No Suitable Driver' error. The same statements work when I use
them in a straight
	java application. I suspect that the problem is that I need to
include the jdbc6.5-1.2.jar
	file in the classpath. I have included it in the WEB-INF/lib
directory, but I continue to get the
	same error. 
	Am I putting the jar in the correct directory??

  Thanks!

Re: tomcat/JDBC

[Pascal-Eric Servais <pa...@videotron.ca>]

tomcat/JDBCHave you tried to restart Tomcat server after adding the jar file ?


---
Pascal-Eric Servais ( http://pages.infinit.net/denethor )
www.clickon.com
---
PGP Fingerprint : 8D0C FB66 CAF0 B9B3 E925  8D2E 7BDB 1D47 DC0B 4AEA
"La carte n'est pas le territoire", Alfred H. Korzybski


  ----- Original Message ----- 
  From: Bob Solkovy 
  To: 'tomcat-user@jakarta.apache.org' 
  Sent: Tuesday, September 26, 2000 1:58 PM
  Subject: tomcat/JDBC




  Hello, 

          I am attempting to access a postgresql database thru a JSP application and keep getting a 
              'No Suitable Driver' error. The same statements work when I use them in a straight 
          java application. I suspect that the problem is that I need to include the jdbc6.5-1.2.jar 
          file in the classpath. I have included it in the WEB-INF/lib directory, but I continue to get the 
          same error. 
          Am I putting the jar in the correct directory?? 

    Thanks! 

Re: tomcat/JDBC

[greg <em...@gregorybittar.com>]

I haven't done enough controlled experiments to be sure, but appears
that it is not important for the Postgres driver to be in your lib
directory.  In fact, I don't think my Postgres JDBC jar is anywhere in
my webapp.  Rather, it is in the CLASSPATH of the person who starts
Tomcat.  One thing I do have in my lib file, and you might consider
doing the same, is a copy of pool.props, a database connection flatfile
with lists of database URLs, connection passwords, usernames, and the
JDBC drivers used to reference them.  pool.props is one of the files
that comes with PoolMan, a database connection pool manager that comes
from CodeStudio.com  The only problem I've seen with Poolman thus far is
that it doesn't handle open connections well.  In particular, releasing
resources from an open transaction in the middle of a Java exception has
not yet been possible for me.  Other than that .. it works splendidly

Bob Solkovy wrote:

>
>
> Hello,
>
>         I am attempting to access a postgresql database thru a JSP
> application and keep getting a
>             'No Suitable Driver' error. The same statements work when
> I use them in a straight
>         java application. I suspect that the problem is that I need to
> include the jdbc6.5-1.2.jar
>         file in the classpath. I have included it in the WEB-INF/lib
> directory, but I continue to get the
>         same error.
>         Am I putting the jar in the correct directory??
>
>   Thanks!
>