Configuring JWS to run oracle JDBC thin.. solution.

Hi,
It seems that oracle is good at letting us know how to configure the Oracle Drivers for java 1.2, but it is another thing to configure them for use under JWS.
I'm using solaris2.6 and java1.2.x

Here's how....

Download the driver files from oracle www.technet.oracle.com, the 8.1.5 thin driver works with 8i.

Once downloaded, change to the oracle8.1.5 directory, in it are two sets of class files.A set includes the class files and the nls_support files.

for the thin driver using java1.2 pick the classes111.zip file and the nls_charset11.zip file.

unzip them thus exposing all of the classes/directories and components. then I jar them. uncompressed.

Using java 1.2 tools the command to jar is:

    (for the classes111 directory)
    jar cvf0 classes111.jar -C classes111/ .

      This will start in the classes111 directory and recurse the tree.
     the 0 (zero) option keeps the file uncompressed.
     the -C changes the directory to classes111/
     I don't know what the . (dot) does, I think it means start here.
     (but it works so,  I'm not going there.)

Then do the same with the nls_* file.
These files are now prepared for use the JavaWebServer.

Then, simply drop these in the jws_root_directory/lib file. then, restart JWS. JWS will pick up the jar files in it's classpath. Now the drivers are installed.

How to use them in java:
the class used in the registerDriver or Class.forName is: "oracle.jdbc.driver.OracleDriver"

the connect string of:

"oracle:jdbc:thin:@your_host_name_or_ip:port:oracle_instance:name",
"user_name",
"password"

works really well as a connection string.

That's it.It took me a couple of days to figure all of this out. Oracle could have made it a little easier. I hope you don't have to go through all this like I did.

Hopes this helps,
Steven Finkelman Received on Fri Nov 19 1999 - 18:04:36 CST