Two Question about Pool and Datasource Websphere.

2006-11-08 Thread Marwane
Hi , Q1 : whene the pooled connection are closed definitivly (look at OJB.properties and mapping.xml below) Q2 : How to use datasource websphere with OJB ? OJB.properties : PersistenceBrokerFactoryClass= org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl PersistenceBrokerClass=or

Re: Borrow broker from pool failed. in production server

2006-11-08 Thread Marwane
hi; The problem is resolved using : so it s strange the message gived by ojb tel us about the broker pool problem but the solution was the growing the connection pool ! thx for all. On 10/27/06, Armin Waibel <[EMAIL PROTECTED]> wrote: Marwane wrote: > thx. > > if i don't defin the conn

RE: Borrow broker from pool failed. in production server

2006-11-08 Thread Ferrer, Eric
Marwane, Growing the pool is not a good thing always. Say you have 300 Oracle licenses, depending on the license, that may include connection pooled objects under the same user account. So there is a section in your code that may not have a finally block so the connection does not get closed.

Need OJB config with Websphere DataSource JNDI

2006-11-08 Thread Marwane
Hi, if someone has configured OJB with websphere datasource jndi ??? thx a lot

Re: Borrow broker from pool failed. in production server

2006-11-08 Thread Marwane
thx for your helpful and constructif reply . i will profile the connections, but it will be gretful if you can give me more detail about using DBCP and evictionThreads with example configuration (ojb.prperties, repository.xml) and how to profile the connections with wich tools ? thx On 11/8/06

RE: Borrow broker from pool failed. in production server

2006-11-08 Thread Ferrer, Eric
Well with SQL Server 2005 I use the profiler that comes with the studio, don't know about your database/database tools. You want to have your maxActive settings the same in repository_database.xml and ojb.properties. Then you want to enable eviction threads in your ojb.properties file. Just read

Re: Borrow broker from pool failed. in production server

2006-11-08 Thread Mike Perham
If you are leaking brokers, that doesn't solve the problem - it just works around it. We had the same problem with our Spring/JTA/OJB application and I discovered the problem was due to using Spring DAOs directly instead of going through the Spring transaction layer. On 11/8/06, Marwane <[EMAIL

Performance & PB

2006-11-08 Thread Ernst Temp
Hello, I am developing an application that contains of two programs One that needs persistency. Here I use PersistenceBroker very successfully The second one does not need persistency at all, and performance is quite important. The program also relies heavily on cached data, but there

Re: Need OJB config with Websphere DataSource JNDI

2006-11-08 Thread sachin
Create datasource on websphere as CMP & create JNDI for that. Create its local reference for project(in our case, we set reference in web.xml) & map it in repositiry file as follows. - Original Message - From: "Marwane" <[EMAIL PROTECTED]> To: "OJB Users List" Sent: Wednesday, N

Re: Performance & PB

2006-11-08 Thread Tino Schöllhorn
Hi, I think you can exactly do that. Just use a thread variable (see ThreadLocal) and store a PB in that. We are doing exactly that and it works great. You just have to close the PBs when the work of your thread is done, of course. Tino Ernst Temp wrote: Hello, I am developing an applic