Application hanging

Hi all,

I have a very small test application inserting one row into the database using the JDBC Thin Client. Most of the time it works fine but sometimes it hangs. When it hangs I have following situation on the database side:

The session is active
The session is waiting for "SQL*Net more data from client" There are no other session.
There are no blocking locks.
The client and server ran on same machine or different machines => no change

Some strange behaviours:
1) when the statement works, it always works for that statement. Then I change one value. It blocks once and the second time is ok. I change again that value, it blocks once, the second time is ok, etc... 2) The statement contains some line feeds. When I remove one of them, I can always insert without hanging. When I put it back, it hangs again. Could that be a parsing or optimizer problem ?

Configuration:
Database: Oracle 8.1.7.3.2 (JDBC Thin Driver 9.0.1.1 on client side) Platform: Windows NT, sp5
The table has 980 columns, about 1200 lines, 2 indexes, no ref constraints, no PK. The insert statement contains about 120 columns, for all of them values are specified.
I know about bug 1956339 (JDBC hanging when inserting a lot of null values), which has been corrected with 8.1.7.3.0.

I already opened a TAR, but it is very diffiicult to make it reproductible. I thought I had finally a configuration, but Oracle could not reproduce it.

Has anyone seen this situation, any ideas where to look ?

Thanks
-- Alwin Received on Wed Apr 17 2002 - 06:45:26 CDT