• Post Reply Bookmark Topic Watch Topic
  • New Topic

Connection pooling with DBCP

Amarjyoti Das
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anybody playing with dbcp from apache? I compined ManualPoolingDriverExample.java. Before compiling, I put commons-dbcp.jar, commons-pool.jar and commons-collections.jar under \lib\ext directory of JDK (1.4). I also renamed class12.zip ( oracle jdbc driver) to oracle-jdbc.jar. The code comiples fine. But when I try to run it using the following command it fails to create a database connection. Please help.
Thank you,
C:\java\classes>java ManualPoolingDriverExample "jdbc racle:thin:smms/password@myserver:1521:smms" "
Setting up driver.
Creating connection.
Exception in thread "main" org.apache.commons.dbcp.DbcpException: java.sql.SQLException: No suitable driver
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFa
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:146)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:199)
at ManualPoolingDriverExample.main(ManualPoolingDriverExample.java:153)
Sudharsan Govindarajan
Ranch Hand
Posts: 319
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have implemented Connection Pooling thru DBCP. But I have placed the JDBC driver jar in my web application's \WEB-INF\lib folder and the common-*.jars in the $CATLINA_ROOT\common\lib directory.-
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!