Originally posted by Tomas Sara:
and I made my own implementation of DataSource.
Why would you do such a thing if DBCP has one? I don't know how to integrate it with Spring, but using DBCP should be this simple:
DBCP Package Summary
Originally posted by Tomas Sara:
Then I copied jar file with my class to "$CATALINA_HOME/commons/lib" directory so Tomcat should be now able to use it.
Since you are creating a connection pool in your application for your application's own use, Tomcat doesn't need to know about it. And if you don't want to restart Tomcat, it
shouldn't know about your pool.
Furthermore, if you are getting an "java.sql.SQLException: No suitable driver" exception, the problem is that the JVM can't find your database driver. That is probably the root of your problems. Where do you have the HSQLDB jar file?