Re: validation query for connection failed

[Thomas Franke]

Armin Waibel wrote:
Thanks for your answer, Armin.
which version of OJB do you use?
We still use db-ojb-1.0.rc6.jar.
It is possible to make a change to db-ojb-1.0.1.jar without any trouble?
Normally ConnectionFactoryPooledImpl tries 100 times to lookup a valid 
connection from the DB, so you should get the warning several times 
before the pool break.
Could you post the whole stack trace?
Now our application runs in tomcat as webservice. I can't see any output 
in the tomcat logs.
Here is what I see in our log:

------------------------begin
org.apache.ojb.broker.PBFactoryException: Borrow broker from pool 
failed, using PBKey org.apache.ojb.broker.PBKey: jcdAlias=lala, 
user=lulu, password=*****
	at 
org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersistenceBroker(PersistenceBrokerFactoryDefaultImpl.java:117)
	at 
org.apache.ojb.broker.core.PersistenceBrokerFactoryBaseImpl.defaultPersistenceBroker(PersistenceBrokerFactoryBaseImpl.java:158)
	at 
org.apache.ojb.broker.PersistenceBrokerFactory.defaultPersistenceBroker(PersistenceBrokerFactory.java:65)
	at 
de.mhr.wis.DBAdapter.ojbAdapter.communicationManager.JobGeneratorDBAdapter.getCommTypes(JobGeneratorDBAdapter.java:264)
	at 
de.mhr.wis.communicationlayer.jobgenerator.JobMaker.createJobs(JobMaker.java:850)
	at 
de.mhr.wis.communicationlayer.jobgenerator.JobMaker.createJobs(JobMaker.java:103)
	at 
de.mhr.wis.communicationlayer.jobgenerator.JobGenerator.run(JobGenerator.java:630)
Caused by: java.util.NoSuchElementException
	at 
org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:803)
	at 
org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersistenceBroker(PersistenceBrokerFactoryDefaultImpl.java:99)
	... 6 more

----------------------end
best regards
Thomas

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]