Hi Team,
Recently I am facing a strange issue while using my clover application that is deployed on Weblogic server. I am connecting to database by defining a JNDI data-source in weblogic and using that in my graphs. The graphs are running for sometime without any issues but suddenly I see that the graphs are erroring out with message as :
Caused by: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool testdb to allocate to applications, please increase the size of the pool and retry…
I already have 25 connections defined for my JNDI data-source, I can see that no other graph is running. But still when I execute any graph I am getting this error.
Please help me how to debug this issue? I am not able to find any error messages in weblogic server logs. Please help me in solving this issue.
Thanks
Hi,
It may be that some of your connections in pool are broken - e.g. by timeout, lost connection, … So it makes a sense to setup validations on connection. Not working connections are then released and does not stuck in pool.
How does your JNDI connection definition look like? I am not sure about DB engine you use, but for example for MySQL it make sense to switch on following properties:
* validationQuery=“/* ping */ SELECT 1”
* testOnBorrow=“true”
* validationInterval=“30000”
* timeBetweenEvictionRunsMillis=“30000”
* minEvictableIdleTimeMillis=“60000”
and in JDBC url use parameter “autoReconnectForPools=true”
I hope this helps.
Thanks a lot for replying. I am using Oracle 11g as my database, so can you please tell me if I need to do the same settings if I use Oracle DB instead of MySQL?
Also can you please guide me on where I need to set the properties while defining my JNDI in Weblogic server? I have gone through the list of properties under connection pool tab of my JNDI data-source but I don’t see these parameters defined in Weblogic.
Is there a way to find out what happened to these connections like whether they timed-out, lost connection as you have explained?
Also can you please tell me if the details are available in clover documentation or anywhere else?
Thanks in advance.
Hi,
settings for Oracle should be the same and the described location is the correct one. If you want to see all the configuration options, open Advanced section. You can cross check names of the properties, for example validationInterval in Tomcat is obviously Test Frequency in Weblogic and so on. Here is a list of properties with their description for Tomcat: https://tomcat.apache.org/tomcat-5.5-do … howto.html (chapter named JDBC Data Sources, subchapter 4. Configure Tomcat’s Resource Factory) and there is quite a nice description directly next to the setting in Weblogic console, even with the option “More Info”.
Regarding your other question, myDataSource → Monitoring → Statistics seems like something you might find useful. The documentation is here: http://docs.oracle.com/cd/E23943_01/web … onitor.htm
Regards,