Connection Pool Exception

[minlwithv]

hi All

i am running a J2ee application on Sun One App Server with Orace 8.
I get this Connection Pool exception which stops the application to run.
could anyone help me on this.

java.sql.SQLException: Not able to get a connection, after waiting for the 120secs in the Queue
at com.netscape.server.jdbc.ConnectionPool.getConnection(Unknown Source)
at com.netscape.server.jdbc.PoolUtil.getConnFromPool(Unknown Source)
at com.netscape.server.jdbc.PoolUtil.getConnection(Unknown Source)
at com.netscape.server.jdbc.DataSourceImpl.getConnection(Unknown Source)
at com.netscape.pm.model.ConnectionFactory.getConnection(ConnectionFactory.java:268)
at com.netscape.pm.model.ConnectionFactory.getConnection(ConnectionFactory.java:229)
at com.netscape.pm.model.PMCluster.getConnection(PMCluster.java:615)
at java.lang.reflect.Method.invoke(Native Method)
at com.netscape.pm.model.ejb_skel_com_netscape_pm_model_PMCluster.getConnection(ejb_skel_com_netscape_pm_model_PMCluster.java:985)
at com.netscape.pm.model.ejb_kcp_skel_IPMCluster.getConnection__java_sql_Connection__void(ejb_kcp_skel_IPMCluster.java:676)
at com.kivasoft.ebfp.FPRequest.invokenative(Native Method)
at com.kivasoft.ebfp.FPRequest.invoke(Unknown Source)
at com.netscape.pm.model.ejb_kcp_stub_IPMCluster.getConnection(ejb_kcp_stub_IPMCluster.java:991)
at com.netscape.pm.model.ejb_stub_IPMCluster.getConnection(ejb_stub_IPMCluster.java:115)
at com.netscape.pm.model.ConnectionFactory.getXAppConnection(ConnectionFactory.java:135)
at com.netscape.pm.model.Finder.findExpiredWorkItems(Finder.java:816)
at com.netscape.pm.htmlFE.OnPerformScheduledEventInternal.expireWorkItems(OnPerformScheduledEventInternal.java:101)
at com.netscape.pm.htmlFE.OnPerformScheduledEventInternal.handleEventInternal(OnPerformScheduledEventInternal.java:71)
at com.netscape.pm.htmlFE.BaseUIEventHandler.handleEvent(BaseUIEventHandler.java:538)
at com.netscape.pm.BasePMServlet.execute(BasePMServlet.java:183)
at com.netscape.pm.BasePMServlet.doRequest(BasePMServlet.java:155)
at com.netscape.pm.Engine.service(Engine.java:59)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.netscape.server.servlet.servletrunner.ServletInfo.service(Unknown Source)
at com.netscape.server.servlet.servletrunner.ServletRunner.execute(Unknown Source)
at com.kivasoft.applogic.AppLogic.execute(Unknown Source)
at com.kivasoft.applogic.AppLogic.execute(Unknown Source)
at com.kivasoft.thread.ThreadBasic.run(Native Method)
at java.lang.Thread.run(Thread.java:479)




with rgds
mani

[Krzemo]

1) Try TNSPing from app server to Oracle server using parameters from connection string.

2) Increase connection Timeout value.

3) Catch that exception (so the program can retry or something else in case of exception)

Best regards,
Krzemo.

[Andy Tacker]

seems as if Connection Pooling is not supported on the client machine where you are trying to run the application.

try to set connection polling parameter as false...

[minlwithv]

thanks guys .
Krzemo

i have increased the connection time out time.

and i have caught the exceptions too.but it doesn't work.

could anyone tell how to force the App Server to close the unwanted connections.

i am using the "Oraman-database monitor" in which it shows "no rows selected "

for about 20 connections and the maximum connections has been set as 40.


thanks