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  ???
 
Or may be i miss something  ???? 
 
Thks in advance .
 
Thierry 
 
 

Reply via email to