| Problems to use LOB with JDBC in multi-threaded context [message #61231] |
Tue, 06 April 2004 08:41 |
Philippe REPUSSEAU
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
Hi,
We have been using LOBs with success via Java / JDBC applications until we had to use several threads to meet the performance requirements. Under concurrent conditions the driver raise SQL exceptions such as I/O Exception: "Unexpected packet", "Bad packet type" or "Size Data Unit (SDU) mismatch". After those problems the driver is dead.
The JDBC Documentation argues that Oracle driver are thread safe. We identified a problem when we concurrently execute a query that reads or write LOB content with any other SQL query.
Here is our technical context:
Client:
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
Java J2SDK 1.4.1_03
JDBC Driver (ojdbc14.jar) Oracle JDBC Driver version - 9.0.2.0.0
Applications use the thin driver
</BLOCKQUOTE>
Server:
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
</BLOCKQUOTE>
The problem does not exist with OCI drivers.
Does anybody has encountered similar problems ?
Is it a bug in the thin driver ?
Regards
Philippe REPUSSEAU
Mutuelles Régionales d'Assurances
Architecture SI et Développement Java
Le Croc - BP 63130
45431 CHECY Cédex
( 02 38 78 14 44
philippe.repusseau@mra.fr
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
