Re: Oracle 7.3.3. - Java problem

Robertas,
  I would go with your instincts that the db is too old. If I recall correctly, the spec for the Oracle drivers said support for 7.3.4. You'll have to go back to the oracle web site and look this info up to verify.

regards,
Cindy

Robertas wrote:

> 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 - 14:34:38 CDT