Hi, I also had problems with the broker and now I'm realised, that only if I define the connection Pool in both files where it is possible (OJB.properties AND reposistory.xml), it works like we want.
I tried many settings and tested it with JMeter and produced havy laod on the web application. The connection pool didn't grow over 21 connections to the db. Only with setting of maxActive=100 and maxIdle=20 in repository.xml and OJB.properties it growed over 21 connection on havy load. I don't know why but now it works fine now. I searched in the source of OJB and found the default settings in org.apache.ojb.broker.util.pooling.PoolConfiguration. Try to make the settings in both files. Roland Ribi > -----Original Message----- > From: Thomas Franke [mailto:[EMAIL PROTECTED] > Sent: Monday, November 15, 2004 5:26 PM > To: OJB Users List > Subject: Re: validation query for connection failed > > > Ribi Roland wrote: > > Thanks for your help, Roland. > > > http://www.websina.com/bugzero/kb/oracle-connection.html > This is not our problem, because we almost always get a > connection. The > problem only occurs sometimes. But to often. > > > An other problem could be that some Broker stay open after > use. I had this > > behavior in my tomcat-application. After I checked the code where a > > PersistenceBroker is used and implemented the call of the > close method > > correctly at the end of any request (also if it throws an > exception!), it > > works fine. > We found one method, where the broker wasn't closed. Now all > the brokers > are definitely being closed in a finally block but our > problem is still > there. > > regards > > Thomas > > -- > Mit freundlichen Gr��en > > Thomas Franke > > Gesch�ftsf�hrer softEnergy GmbH > ---------------------------- > The energy for a better world > ---------------------------- > softEnergy GmbH > Platz der Freundschaft 1 > 18059 Rostock > ---------------------------- > fon: +49 381 40 587 535 > fax: +49 381 40 587 555 > mobil: +49 1715222015 > > http://www.softenergy.de > mail: [EMAIL PROTECTED] > ---------------------------- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
