Re: Oracle 8i JDBC driver OCI8 connect error

If you're using the 1.3 JDK, why are you using classes111.zip... try classes12.zip instead.

Supposedly the OCI drivers are up to 400% faster than the thin drivers... but I've never seen any hard numbers on that. Personally, I've never had any problem with the thin drivers, even when using them on enterprise strength applications. I like using the thin drivers better because I don't have to worry about my library path being off, or when my tnsnames.ora file says, or even if the Oracle client is installed on my server (or even available on my platform).

Plus, you don't have to give Oracle any licensing fees... Larry Ellison takes way too much money from us the way it is.

-Nathan

"Giovanni Azua" <giovanni.azua_at_dsgroup.it> wrote in message news:9r3nv0$r6c3u$1_at_ID-114658.news.dfncis.de...
> 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
>
>
>
>
Received on Tue Oct 23 2001 - 21:23:04 CDT