Re: Used ConnectionManager instance could not obtain a connection, retrying...
Hari Om wrote: Thanks Martin...any other input on this? You're most welcome. Not sure what you mean with other input... Just click the link below and read my previous reply in the mail archive, for more detailed info on how to enable a validation query for OJB pooled connections: See http://www.mail-archive.com/ojb-user@db.apache.org/msg13299.html Regards, Martin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Used ConnectionManager instance could not obtain a connection, retrying...
Thanks Martin...any other input on this? THANKs! --- Martin Kalén Mon, 11 Apr 2005 02:27:25 -0700 Oracle RDBMS will disconnect any inactive clients after a certain (server-side configurable) amount of time. See http://www.mail-archive.com/ojb-user@db.apache.org/msg13299.html Regards, Martin From: "Hari Om" <[EMAIL PROTECTED]> Reply-To: "OJB Users List" To: ojb-user@db.apache.org CC: [EMAIL PROTECTED] Subject: Used ConnectionManager instance could not obtain a connection, retrying... Date: Sat, 09 Apr 2005 20:30:42 + hello I am using JDK1.4, OJB, and Oracle 9.2.0.2 on SuSE Linux 9.0 We ha dthis Web Application Running for few months... and there was NO ACTIVITY on this web site in past 4-6 weeks... and now when I log on to that I get following ERRORS...wonder why... I am able to LOG in to SQLPLUS and query the database on Oracle Server but when I log in to Web Application with Java front end... i get ERROR... I checked my DB... it is UP RUNNING and the PORT 1521 is OPEN between App Server and Oracle (as I said the web app was working great) I tried restarting my Web, App and DB Server... but still get this error...wonder why: - Caused by: org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager instance could not obtain a connection at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unknown Source) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeSQL(Unknown Source) at com.phx.db.ojb.broker.accesslayer.JdbcAccessImpl.executeSQL(JdbcAccessImpl.java:53) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source) Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could not borrow connection from pool - org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: [EMAIL PROTECTED] jcd-alias=p3-database default-connection=true dbms=Oracle9i jdbc-level=2.0 driver=oracle.jdbc.OracleDriver protocol=jdbc sub-protocol=oracle db-alias=thin:@111.131.16.23:1521:test user=hariom password=* eager-release=false ConnectionPoolDescriptor={whenExhaustedAction=0, validationQuery=select 1 from dual, maxIdle=-1, maxActive=50, maxWait=5000, removeAbandoned=true, numTestsP erEvictionRun=10, testWhileIdle=true, minEvictableIdleTimeMillis=360, testOnReturn=true, logAbandoned=true, removeAbandonedTimeout=300, timeBetweenEvictio nRunsMillis=30, testOnBorrow=true} batchMode=false useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE ignoreAutoCommitExceptions=false [EMAIL PROTECTED] sequenceManagerClass=class com.phx.db.ojb.broker.util.sequence.SequenceManagerImpl Properties={autoNaming=true} ] ] at org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionFromPool(Unknown Source) at com.phx.db.ojb.broker.accesslayer.ConnectionFactoryImpl.getConnectionFromPool(ConnectionFactoryImpl.java:31) at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(Unknown Source) at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Unknown Source) ... 61 more Caused by: java.util.NoSuchElementException at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:744) ... 65 more [ERROR] (QueryBySQL.java:191) - org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager instance could not obtain a connection, retrying... _ FREE pop-up blocking with the new MSN Toolbar get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _ Dont just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Used ConnectionManager instance could not obtain a connection, retrying...
Hari Om wrote: hello I am using JDK1.4, OJB, and Oracle 9.2.0.2 on SuSE Linux 9.0 We ha dthis Web Application Running for few months... and there was NO ACTIVITY on this web site in past 4-6 weeks... and now when I log on to that I get following ERRORS...wonder why... Oracle RDBMS will disconnect any inactive clients after a certain (server-side configurable) amount of time. See http://www.mail-archive.com/ojb-user@db.apache.org/msg13299.html Regards, Martin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Used ConnectionManager instance could not obtain a connection, retrying...
hello I am using JDK1.4, OJB, and Oracle 9.2.0.2 on SuSE Linux 9.0 We ha dthis Web Application Running for few months... and there was NO ACTIVITY on this web site in past 4-6 weeks... and now when I log on to that I get following ERRORS...wonder why... I am able to LOG in to SQLPLUS and query the database on Oracle Server but when I log in to Web Application with Java front end... i get ERROR... I checked my DB... it is UP RUNNING and the PORT 1521 is OPEN between App Server and Oracle (as I said the web app was working great) I tried restarting my Web, App and DB Server... but still get this error...wonder why: - Caused by: org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager instance could not obtain a connection at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unknown Source) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeSQL(Unknown Source) at com.phx.db.ojb.broker.accesslayer.JdbcAccessImpl.executeSQL(JdbcAccessImpl.java:53) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source) Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could not borrow connection from pool - org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: [EMAIL PROTECTED] jcd-alias=p3-database default-connection=true dbms=Oracle9i jdbc-level=2.0 driver=oracle.jdbc.OracleDriver protocol=jdbc sub-protocol=oracle db-alias=thin:@111.131.16.23:1521:test user=hariom password=* eager-release=false ConnectionPoolDescriptor={whenExhaustedAction=0, validationQuery=select 1 from dual, maxIdle=-1, maxActive=50, maxWait=5000, removeAbandoned=true, numTestsP erEvictionRun=10, testWhileIdle=true, minEvictableIdleTimeMillis=360, testOnReturn=true, logAbandoned=true, removeAbandonedTimeout=300, timeBetweenEvictio nRunsMillis=30, testOnBorrow=true} batchMode=false useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE ignoreAutoCommitExceptions=false [EMAIL PROTECTED] sequenceManagerClass=class com.phx.db.ojb.broker.util.sequence.SequenceManagerImpl Properties={autoNaming=true} ] ] at org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionFromPool(Unknown Source) at com.phx.db.ojb.broker.accesslayer.ConnectionFactoryImpl.getConnectionFromPool(ConnectionFactoryImpl.java:31) at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(Unknown Source) at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Unknown Source) ... 61 more Caused by: java.util.NoSuchElementException at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:744) ... 65 more [ERROR] (QueryBySQL.java:191) - org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager instance could not obtain a connection, retrying... _ FREE pop-up blocking with the new MSN Toolbar get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]