🚀 go-pugleaf

Looking at your message, I presume you have Oracle installed already. Note
that Oracle comes with it's own JVM.

I haven't modified the classes111.zip file, I can't think of a reason for
doing so.

If you just want to write Java that accesses Oracle via JDBC, then simply
add the classes111.zip file to your Java classpath, and you should be able
to install the latest JDK and have it work with the Oracle JDBC drivers in
classes111.zip.

Finally, note that Oracle 8i isn't certified to work with SUSE7, which
doesn't mean you can't get it working, but it might be a factor in your lack
of success. Does Oracle 8i work OK alone? Can you use SQLPLUS etc?

Cheers,
Craig

"Sergei Gouskov" <sgouskov@ue.com.au> wrote in message
news:M8La6.2819$cF2.57353@ozemail.com.au...
> Hello all,
>
> Running Oracle 8.1.6 on SUSE7 ( from the book "Oracle 8i for LINUX Starter
> Kit" but it looks
> identical to that dstributed by Oracle).
> I would like to test java but the book says "should have jdk 1.1.6
installed
> and configured".
>
> My questions would be:
>
> - Has someone had successfuly modified oracle jdbc classes for lunux -
> classes111.zip or classes12.zip (last should exist for other platforms) so
> that they can be used
> with one of JDKs that are preinstalled in SUSE7 ( 1.1.8, 1.2, 1.3 )?
>
> - (in case that it is the only option :) Has anybody installed JDK 1.1.6
> from adviced in the
> book www.blackdown.org? Are preinstalled jdks stay preserved in this case?
> What else is actually
> modified on linux with jdk1.1.6 installation?
>
> Any information on installing and running java with oracle8.1.6 on linux
> would be appreciated.
>
> Thank you ahead.
>
> Sergei
>
>
>
> if you still read :)
>
> I've tried to compile sample code for jdbc access to oracle8i using
existing
> 1.2 compiler it went without
> a message but at runtime got this error:
>
> Connecting ... Exception in thread "main" java.sql.SQLException:
ORA-12154:
> TNS:could not resolve service name
>
>         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
>         at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java)
>         at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java)
>         at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
>         at
> oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
>         at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
>         at java.sql.DriverManager.getConnection(DriverManager.java:453)
>         at java.sql.DriverManager.getConnection(DriverManager.java:133)
>         at JdbcConnect.main(JdbcConnect.java:21)
>
>
> also tried to compile with existing 1.1.8 compiler:
>
> oracle@linux:/usr/lib/jdk1.1.8/bin >./javac -d
> /tmp/8istarterkit/Java -classpath
>
".:/usr/lib/jdk1.1.8/lib/classes.zip:/usr/oracle/jdbc/classes111.zip:/tmp/8i
> starterkit/Java"
> /tmp/8istarterkit/Java/JdbcConnect.java
>
> /tmp/8istarterkit/Java/JdbcConnect.java:7: Class
> oracle.jdbc.driver.OracleDriver not found in type declaration.
>     DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
>                                                        ^
> 1 error
>
>
>
>
>