JBoss Connection Pooling is so slow

quangle May 12, 2006 6:09 PM

Hi all,
My webapp is using Jboss connection pooling to get connections to mysql database. Somehow, the connection made from the calling DataSource.getConnection is so long (about 5 seconds).
Is anyone having the same problem? Is there any JBoss configuration to make it better.

Thanks,
Quang

1. Re: JBoss Connection Pooling is so slow

jaikiran May 13, 2006 10:37 AM (in response to quangle)

Are you passing the Datasource.getConnection() method, the username and password as parameters or are you just calling the getConnection() method without any parameters?
Actions
2. Re: JBoss Connection Pooling is so slow

quangle May 13, 2006 11:08 PM (in response to quangle)

"jaikiran" wrote:
Are you passing the Datasource.getConnection() method, the username and password as parameters or are you just calling the getConnection() method without any parameters?

I am just calling getConnection() method without any parameters. The username, password are set in -ds.xml file in JBoss configuration file.
The connection is established but it is very slow (5 seconds)

Thanks,
Quang
Actions
3. Re: JBoss Connection Pooling is so slow

bhupendra.yaduvenshi May 18, 2006 3:31 AM (in response to quangle)

See ur ds.xml in that there are two parameter max & min size of pool connection.Set these parameter to 1 & 5 & test.It will work if not than let me know.

Bhupendra
Actions

Go to original post