3 Replies Latest reply on Jul 17, 2003 5:38 AM by kar2000

    Connection or PooledConnection with Oracle thin driver

    Terry Ray Newbie

      I've seen a few postings about using connection pooling and I'm still a little unclear. I followed what I've seen on this forum to set up connection pooling in JBoss 3.0.0alpha and Oracle 8i thin driver. I added the "classes12.jar" to the lib/ext. I added the service file to the deploy dir, JBoss responded that this worked. I modified my deployment descriptors as several postings have suggested. I modified my source where I was creating the connection to use the DataSource also as I've seen in some postings on this forum (before I was just using the DriverManager to get the connection). Redeployed the bean and everything still worked but I don't see any noticiable performance differences from before. How can I be certain I'm taking advantage of connection pooling?

      Some of the JDBC documentation suggests that I need to use ConnectionPoolDataSource and PooledConnection. These classes are supported by the thin driver jar but when I tried it in the code, JBoss blew up:

      java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.JDBCDataSource

      where I'm creating the connection from the PooledConnection like poolConnection.getConnection()

      My question is: What do I need to do to take advantage of connection pooling in JBoss with the Oracle 8i thin driver?

      Thanks.