Oracle 7.3.3. - Java problem

Hi all,

I've made Java application which connects to Oracle server through JDBC thin driver, launches stored function, gets the result and outputs result to the console. It works. But not always. Sometimes launched java application hangs up when trying to connect to Oracle. And no one knows when the next hangup will occur. This is the line which it cannot pass through:

     Connection conn = DriverManager.getConnection (...)

At the same time, when java application doesn't connect, stored function in SQLPlus works fine, and pinging the server gives ok! The most wondering thing is that it lasts for about ten minutes. We kill the java process, launch java application and it hangs up again. And suddenly, after some period of time, everything works fine again - java app connects to Oracle.
This is the environment:
server: Oracle 7.3.3. on WinNT4+sp5, SQLNet 2.3.3., Connection Manager is not used
client: WinNT4+sp5 (tried FreeBSD 3.2 unix also), Sun JDK 1.1.8, Oracle JDBC thin drivers version 7.3.4. (tried 8.1.5. also)

Anyone have experienced this kind of problem ? Maybe Oracle Server is too old ? I tried with Oracle8.1.5 server and it never hanged up. Please, don't hesitate to write a hint.

Robertas
robis_at_elsis.com Received on Wed Sep 29 1999 - 12:29:00 CDT