Oracle JDBC driver with CSWS_JAVA T2.1

[Andre Menard]

Has anyone used the Oracle JDBC (Oracle9i 9.2.0.3 for JDK 1.4) drivers with the
CSWS_JAVA T2.1 Beta Kit?

I placed the the file ojdbc14.jar file in the directory [APACHE.JAKARTA.TOMCAT.common.lib],
and restarted Tomcat. The processed failed and I get the following messages...

>Stopping initiated
>java.util.zip.ZipException: error in opening zip file
> at java.util.zip.ZipFile.open(Native Method)
> at java.util.zip.ZipFile.(ZipFile.java)
> at java.util.jar.JarFile.(JarFile.java)
> at java.util.jar.JarFile.(JarFile.java)
> at org.apache.catalina.loader.StandardClassLoader.addRepositoryInternal(
>StandardClassLoader.java)
> at org.apache.catalina.loader.StandardClassLoader.(StandardClassLo
>ader.java)
> at org.apache.catalina.startup.ClassLoaderFactory.createClassLoader(Clas
>sLoaderFactory.java)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java)
>Bootstrap: Class loader creation threw exception
>java.lang.IllegalArgumentException: addRepositoryInternal: java.util.zip.ZipExce
>ption: error in opening zip file
> at org.apache.catalina.loader.StandardClassLoader.addRepositoryInternal(
>StandardClassLoader.java)
> at org.apache.catalina.loader.StandardClassLoader.(StandardClassLo
>ader.java)
> at org.apache.catalina.startup.ClassLoaderFactory.createClassLoader(Clas
>sLoaderFactory.java)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java)

I was able to unpack the jar file from the DCL prompt using the following steps

$ define/nolog DECC$ARGV_PARSE_STYLE ENABLE
$ define/nolog DECC$EFS_CASE_PRESERVE ENABLE
$ define/nolog DECC$EFS_CASE_SPECIAL ENABLE
$ define/nolog DECC$EFS_CHARSET ENABLE
$
$ jar xf ojdbc14.jar

I am using OpenVMS 7.3-1 and Java 1.4.1
Thanks

[Willem Grooters · Accepted solution]

Is this file in STREAM_LF format? (ANY java should be).

[Martin P.J. Zinser]

To elaborate on Willems suggestion, the archive should look like this
File organization: Sequential
Record format: Stream_LF, maximum 512 bytes, longest 512 bytes
Record attributes: Carriage return carriage control

If it does not look like this the following command might fix it:

$set file/attr=(RFM:STMLF,RAT:CR)

[Andre Menard]

Thanks to both Willem and Martin.
I did have the wrong file structure. I don't know if the jar file is working, but at Tomcat is up and there are no errors.

Andre