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 ojb-user@db.apache.org
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]