JDBC- Oracle thread problem

I 'm using JDBC-Oracle thin driver on Widows NT with Personal Oracle v7.0. I tried to create more than 1 statement for the same connection and run them concurrently. That means , I have 10 threads running concurrently. All use the same connection and each creates its own statement. However, I find out that it randomly gives me error such as "INvalid SQL statement" , or "SQL not properly ended". I turned on debugging in Jdbc driver by using DriverManager.setLogStream(...). In my log file, it shows Oracle receives my correct SQL statement, but somehow, it then fills in some garbage characters. As a result, it fails with such error.

My question is: Does anyone know that Oracle thin driver supports multi-threads (ie. does it allow multiple statements on the same connection running concurrently?) ?

Many thanks in advance.

Bob. Received on Wed May 27 1998 - 08:01:40 CDT