Intermitter error ...

2006-05-11 Thread Vamsi Atluri
Hello all, I am getting this error when I am doing a broker.getCollectionByQuery() very intermittently. The same piece of code works some times and fails some times with this error: [5/11/06 10:02:15:498 EDT] 24df24df SystemErr R java.lang.NullPointerException [5/11/06 10:02:15:498 EDT]

Re: Intermitter error ...

2006-05-11 Thread Armin Waibel
Hi Vamsi, could post more details of the used OJB version and how you are using OJB? Could it be a concurrency issue, is it guaranteed that each thread use it's own PB instance? regards, Armin Vamsi Atluri wrote: Hello all, I am getting this error when I am doing a

Re: Only one PB from second database

2006-05-11 Thread Bruno CROS
Hi Armin, autoCommit set to 1 does not avoid freeze. The fact is that database is only used to be read, so rollbacks ( by disconnecting) will never be long. autocommit is however set to 1 now. Thanks for the advice. I dont' known why it freezes when maxIdle set to -1 and why it does not when

Re: Intermitter error ...

2006-05-11 Thread Vamsi Atluri
Hi Armin, I am using OJB1.0.1 on WSAD 5.1 using JDK1.3.1. I have a simple table of the form: TABLE: BOOK_VERSION_DEF BOOK_IDINTEGER (PK) BOOK_VERSION_IDINTEGER (PK) CREATION_DATEDATE And my query code is like this: Criteria bookVersionCriteria = new

Re: generate global uid's

2006-05-11 Thread Dennis Bekkering
Hello all, I am almost there with regards to asynq data merging based upon GUID. What i am looking for now is a way to have a creationdate field in indirectiontables. I am not sure how to do this since it is all handled by OJB. The case is like this, a local server has records that are not

Re: Intermitter error ...

2006-05-11 Thread Armin Waibel
Vamsi Atluri wrote: Hi Armin, I am using OJB1.0.1 on WSAD 5.1 using JDK1.3.1. I have a simple table of the form: TABLE: BOOK_VERSION_DEF BOOK_IDINTEGER (PK) BOOK_VERSION_IDINTEGER (PK) CREATION_DATEDATE And my query code is like this: Criteria

Re: Only one PB from second database

2006-05-11 Thread Armin Waibel
Bruno CROS wrote: Hi Armin, autoCommit set to 1 does not avoid freeze. The fact is that database is only used to be read, so rollbacks ( by disconnecting) will never be long. autocommit is however set to 1 now. Thanks for the advice. I dont' known why it freezes when maxIdle set to -1 and

Re: Intermitter error ...

2006-05-11 Thread Vamsi Atluri
Hi Armin, My broker factory is: PersistenceBrokerFactoryClass=org.apache.ojb.broker.core.PersistenceBrokerFactorySyncImpl Connection factory class is: ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl Persistence broker pool settings are:

Re: Only one PB from second database

2006-05-11 Thread Bruno CROS
when MaxIdle is set to 0, it works well, and the 5 maxActive are sufficient. No freeze at all. The whenExhaustedAction block is well what i want, no error. And it works with maxIdle set to 0. I don't see why no connection remaining in the pool leads to a serialization. Dead lock is a good

Re: Only one PB from second database

2006-05-11 Thread Armin Waibel
Bruno CROS wrote: when MaxIdle is set to 0, it works well, and the 5 maxActive are sufficient. No freeze at all. it's a moot point whether only one connection or five connections are used when maxIdle is 0. I think that maxIdle=0 will immediately close returned connections. The

Re: Only one PB from second database

2006-05-11 Thread Bruno CROS
No idea. All is ok on paper! http://jakarta.apache.org/commons/pool/apidocs/org/apache/commons/pool/impl/GenericObjectPool.html On 5/11/06, Bruno CROS [EMAIL PROTECTED] wrote: when MaxIdle is set to 0, it works well, and the 5 maxActive are sufficient. No freeze at all. The

Re: Only one PB from second database

2006-05-11 Thread Bruno CROS
Yep, i 'm affraid that _pool.size() is always than -1 !! (the maxIdle), so shouldDestroy is true, and no pool is added. May be it's me . Someone can confirm this ? private void addObjectToPool(Object obj, boolean decrementNumActive) throws Exception { boolean success = true;

Re: Only one PB from second database

2006-05-11 Thread Bruno CROS
Oops, it's me. Sorry On 5/11/06, Bruno CROS [EMAIL PROTECTED] wrote: Yep, i 'm affraid that _pool.size() is always than -1 !! (the maxIdle), so shouldDestroy is true, and no pool is added. May be it's me . Someone can confirm this ? private void addObjectToPool(Object obj, boolean

Re: generate global uid's

2006-05-11 Thread Armin Waibel
Hi Dennis, Dennis Bekkering wrote: Hello all, I am almost there with regards to asynq data merging based upon GUID. What i am looking for now is a way to have a creationdate field in indirectiontables. I am not sure how to do this since it is all handled by OJB. If you need an additional

Re: Only one PB from second database

2006-05-11 Thread Armin Waibel
Bruno CROS wrote: Yep, i 'm affraid that _pool.size() is always than -1 !! (the maxIdle), so shouldDestroy is true, and no pool is added. May be it's me . Someone can confirm this ? Yep! The pool is always empty. I would recommend first to try the connection-pool default settings shipped