Skip to content Skip to sidebar Skip to footer
Home / Connection Pooling / Java / Jdbc / Sql Server / Tomcat

Jdbc Connection Pool With Sql Server 2008 Fails

Post a Comment
I am trying to turn my jdbc code to use Connection Pool functionality on Tomcat. My system is a jsp/servlet application that connects to an SQL Server 2008. So, lets get to the cod

Solution 1:

Ok, found the problem and the answer is pretty simple. Looking at the specification for PoolProperties , it says that :

setDriverClassName(): The fully qualified Java class name of the JDBC driver to be used. The driver has to be accessible from the same classloader as tomcat-jdbc.jar

So even the driver was accessible by my application, it was not accessible by Tomcat. So putting the driver in $CATALINA_HOME/libs directory and restarting Tomcat solved this issue.

Post a Comment for "Jdbc Connection Pool With Sql Server 2008 Fails"