Connection Pooling

[darkph1ber]

How do you get a pooled connection (so you can use it) once its been configured?

Now, normally i know that you use DriverManager.getConnection() to get a connection to s specified resrouce. However, when using JBossManagedConnection pool (setting up the service MBean) how do you then receive a connection?

i've found plenty of documentation (well, an adequate amount) describing how to configure the xml files, but nothing relating to the java code required to use this setup.

anyone know? please let me know! thanks.

[spiritualmechanic]

Basically you do a JNDI lookup, the ConnectionManager will be in the JNDI tree. From that manager, you call getConnection().

Steve

[kar2000]

Well, I have a doubt in this regard - is there any means of finding in the jboss server side and not in the 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?

[eagel]

Could you pls give an example?