Oracle 8i JDBC dirver OCI error

Oracle 8i JDBC dirver OCI error

Post by Giovanni Azu » Wed, 24 Oct 2001 21:32:51



Hi all,

I tried to connect to Oracle 8.0.5 from its (optimized?) JDBC driver OCI8
but is throwing an exception that can't reach the make_c native function
after the Logon call in the calling stack flow. On the other hand I can
connect with its JDBC "thin" driver successfully.

The configuration is: JDK 1.3.x, Oracle 8.0.5, W2K SP1. As explained
in the Oracle JDBC documentation I included the file "classes111.zip" in the
system CLASSPATH and the Oracle native dll in the system PATH, I also
looked at the native dll dependencies and insert their paths to the system
PATH
as well. Included also the <Oracle>\JDBC\lib in the PATH and CLASSPATH
and serveral thousands of other additions as well ;-)

I suspect that since I am executing the java application with JDK 1.3.x and
one of the
native Oracle dll dependencies (that is \jre\bin\javai.dll, which isn't
included in the JDK
1.3.x but only in the older JDK 1.1) is giving some kind of incompatibility.

Have anyone solved this same situation before? Would also like to know if
it's
relevant the performance gains of the OCI8 driver over the 100% pure Java
"thin" driver, I think it should be because somewhere I read it was
recommended
the thin drivers only for client Applet-based Java applications DB access,
and since
the OCI driver uses the native C interface that directly connect to the
Server then
should be straightforward.

Thanks in advance,
Giovanni