Connection or PooledConnection with Oracle thin driver

[terry_ray]

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.

[davidjencks]

If you are getting connections from the DataSource configured in your ConnectionFactoryLoader and bound into jndi, you are using connection pooling. It won't make your queries go faster, all it will do is shorten or eliminate the time waiting to create a connection.

How are you measuring performance? I doubt you will see much difference except under medium to high loads.

[guy_rouillier]

You can verify you are using pooled connections by turning on logging. You will see a particular connection being created, then you will see that same connection being handed out repeatedly.

[kar2000]

Well, I have a doubt in this regard - is there any means of finding in the jboss 3.0.7 server side and not in the Oracle 8 database server side,

how many connections are there in the pool,

how many connections are in use and

how many connections are being returned at a given point of time?