connection problem : Very strange Thing !! (I'm gonna be Crazy !!! )

[Antoine BLANC]

Plop plop !! ^_^

I need a ConnectionPool using commons-dbcp.jar. I start with Jakarta Exemple, every thing is fine.
Then I try to do it by my self. and Here come the strage thing ....
If I run my classes whith java it work, but if I put my classes in a Jar file and I run it through Jakarta-Tomcat 4.1.27 it doesn't work !!!
I have this Exception :
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: No suitable driver
when i try to get a connection on my DataSource Object
Can You help me please !!!

Thanks in advance

|||
^_^ Mil00se

[ May 14, 2004: Message edited by: Antoine BLANC ]
[ May 14, 2004: Message edited by: Antoine BLANC ]

[Stefan Wagner]

looks like a classpath issue - correctly set without tomcat, missing the jdbc-driver when running from tomcat.

I don't use tomcat, so I cannot tell you where to look for the classpath.

[Bear Bibeault]

$CATALINA_HOME/common/lib

Be sure to put the jar file with the driver there.