Home / server / Questions

Questions[connection-pool](server)

Martin Hope
Vinayak
Asked: 2021-12-29 04:11:29 +0800 CST
  • 1

I have set up a connection pool in tomcat's server.xml and context.xml.

I am using the below code to establish a connection.

DataSource ds = (DataSource) context.lookup("jdbc/TestDB"); ds.getConnection();

Now I want to get the properties like MaxActive, MaxIdle etc. But I don't see any method that can be called using DataSource object. How can I get those parameter values ?

tomcat jdbc connection-pool
Martin Hope
brevleq
Asked: 2012-06-16 05:10:21 +0800 CST
  • 5

I have a connection pool in Glassfish 3.1 to connect to SqlServer 2008 Express, this pool works fine, but when Glassfish is restarted, the connection pool can't ping and stops working. To work again, I change the url hostname from "localhost" to "127.0.0.1" or the contrary... Apparently this problem just happen when Glassfish is running in Windows Server 2008, when I run Glassfish in a Linux server no problem like this happen...

EDITED

[#|2012-06-20T14:21:34.992-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.service|_ThreadID=24;_ThreadName=Thread-2;|RAR8054: Exception while creating an unpooled [test] connection for pool [ erp_hm_pool ], null|#]
[#|2012-06-20T14:21:35.006-0300|SEVERE|oracle-glassfish3.1.2|org.glassfish.admingui|_ThreadID=25;_ThreadName=Thread-2;|RestResponse.getResponse() dá FAILURE. endpoint = 'http://localhost:48/management/domain/resources/ping-connection-pool.json'; attrs = '{id=erp_hm_pool}'|#]
[#|2012-06-20T14:22:42.187-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool erp_hm_pool. Exception : null|#]
[#|2012-06-20T14:22:42.193-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool erp_hm_pool. Exception : null|#]
[#|2012-06-20T14:22:42.194-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool erp_hm_pool. Exception : null|#]
[#|2012-06-20T14:22:42.195-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool erp_hm_pool. Exception : null|#]
[#|2012-06-20T14:22:42.196-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool erp_hm_pool. Exception : null|#]
[#|2012-06-20T14:22:42.197-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool erp_hm_pool. Exception : null|#]
[#|2012-06-20T14:22:42.198-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool erp_hm_pool. Exception : null|#]
[#|2012-06-20T14:23:09.253-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool xml_nfe_pool. Exception : null|#]
[#|2012-06-20T14:23:09.255-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool xml_nfe_pool. Exception : null|#]
[#|2012-06-20T14:23:09.255-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool xml_nfe_pool. Exception : null|#]
[#|2012-06-20T14:23:09.256-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool xml_nfe_pool. Exception : null|#]
[#|2012-06-20T14:23:09.257-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool xml_nfe_pool. Exception : null|#]
[#|2012-06-20T14:23:09.258-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool xml_nfe_pool. Exception : null|#]
[#|2012-06-20T14:23:09.259-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool xml_nfe_pool. Exception : null|#]
[#|2012-06-20T14:23:09.260-0300|WARNING|oracle-glassfish3.1.2|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.pool.resizer|_ThreadID=26;_ThreadName=Thread-2;|RAR5058: Error while Resizing pool xml_nfe_pool. Exception : null|#]

Could someone explain me why is it happening and how can I solve it??

windows-server-2008 sql-server glassfish connection-pool
Martin Hope
Yeti
Asked: 2012-04-20 12:41:27 +0800 CST
  • 1

I have an Apache Tomcat 7 server. I have a quite complex Java Servlet application running on it which needs some MySQL queries per POST. Thus I need a MySQL Database connection to do the query. Currently I use the following Java code to create the DataSource:

//db is for example: jdbc:mysql://127.0.0.1:3306/databasename
DataSource ds = new DataSource(initPoolProperties(db, user, pass));

private PoolProperties initPoolProperties(String db, String user, String pass)
{
    PoolProperties defaultPoolProperties = new PoolProperties();
    defaultPoolProperties.setUrl(db);
    defaultPoolProperties.setUsername(user);
    defaultPoolProperties.setPassword(pass);
    defaultPoolProperties.setDriverClassName("com.mysql.jdbc.Driver");
    // And a long list of properties here ...

    return defaultPoolProperties;
}

In my whole hierarchical Java Servlet application I only create one DataSource per Database connection per POST (by HTML Form to browse through the website). After this I use a few times ds.getConnection() to get the connection needed for executing some MySQL queries.

Everybody seems to use a JNDI DataSource. Which means they define a tag in the context.xml of their application, and use a JNDI lookup to get the DataSource, and use the connections the way I do it as well.

The question is wether I am actually doing the same thing here. Are the connections I use, pooled and shared between multiple visitors/clients? Because my online website application is going to be used a lot, and some pages contain quite heavy SQL queries. And I do not want to risk a person to be waiting for longer than 0.01 seconds loading the page.

I read about the way I do it (as shown above in the small simplified code example) on this website: http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html Scroll down a bit and you will find the Good ol' Java section, I think it is the same as using the , but I'm not sure. How can I be sure of my application using connection pooling and sharing those between clients anyways?

PS I prefer using the PoolProperties instead of putting something in the context.xml since I use multiple databases which are defined in a configuration database. The database which is selected, depends on the user. Thus I can more easily maintain the databases in a MySQL administration program this way, than putting as well lots of code in the context.xml.

tomcat mysql jdbc connection-pool