Hello , i have a problem when loading some data from blob. I use the standard support of lob in plateform Oracle 9i.
The problem is when i try to load object with a blob in different Thread. I request a broker from thread 1 for loading objects with lob. I request an other broker from thread 2 for loading other objects. Using a Connection pool the same connection is used by the 2 Threads ( It
does not happen all the time ). It's probably an oracle bug/limitation but when a try to iterate on a result
set in thread 2 in the same time a blob is read in thread 1 there is a dead
lock.
Thread 1 => OracleConnection.needLine Thread2 =>
OraclePreparedStatement.init() ( =>TTC7.getVersionNumber() ).
Is there a simple way in obj to force a broker to use a new connection for
loading data ???
The PB-API is not thread safe and must be externally synchronized.
If you use one PersistenceBroker per thread you should not see these deadlocks. Please report back if you have any new findings.
Regards, Martin
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
