Re: Application hanging

Hi Alwin,
  haven't seen that one. One suggestion though, use the thin driver that came with the 8.1.7 database (look in $ORACLE_HOME/jdbc/lib for the classes12.zip file) and see if you get the same results.

hth,
Cindy

Alwin Dieperink wrote:

> 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 - 11:13:52 CDT