• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

Connection pooling with DBCP

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)
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.-
Everybody's invited. Even this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
    Bookmark Topic Watch Topic
  • New Topic