I am using a Solaris7 OS, and it came with java1_2
installed. I have downloaded jconnect52.zip and unzipped
it on my system. I have set up environment variables,
but cannot get any application to find the driver.
I found a test in some user documentation using IsqlApp,
and the results are below.
Environment variables are:
JDBC_HOME=/applications/cdf/db/jConnect-5_2
JAVA_HOME=/usr/java1.2
CLASSPATH=./:/usr/java1.2/lib:/applications/cdf/db/jConnect-5_2/classes
I ran the following:
java IsqlApp -U sa -P xxx -S jdbc:sybase:Tds:156.80.183.45:3000
-I $JDBC_HOME/sp/sql_server.sql -c go
Recieved the following exception:
Unexpected exception : java.lang.ClassNotFoundException:
com.sybase.jdbc2.jdbc.SybDriver
java.lang.ClassNotFoundException: com.sybase.jdbc2.jdbc.SybDriver
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.<init>(Throwable.java:94)
at java.lang.Exception.<init>(Exception.java:42)
at
java.lang.ClassNotFoundException.<init>(ClassNotFoundException.java:9)
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:191)
at java.lang.ClassLoader.loadClass(Compiled Code)
at sun.misc.Launcher$AppClassLoader.loadClass(Compiled Code)
at java.lang.ClassLoader.loadClass(Compiled Code)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:125)
at IsqlApp.doIsql(Compiled Code)
at IsqlApp.main(IsqlApp.java:47)
Thanks in advance,
Mike Lambrechts
> java.lang.ClassNotFoundException.<init>(ClassNotFoundException.java:9)
> at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.net.URLClassLoader.findClass(URLClassLoader.java:191)
> at java.lang.ClassLoader.loadClass(Compiled Code)
> at sun.misc.Launcher$AppClassLoader.loadClass(Compiled Code)
> at java.lang.ClassLoader.loadClass(Compiled Code)
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Class.java:125)
> at IsqlApp.doIsql(Compiled Code)
> at IsqlApp.main(IsqlApp.java:47)
>
> Thanks in advance,
> Mike Lambrechts
add jConnect-5_2/classes/jconn2.jar to your CLASSPATH
--
===============================================================================
Lance J. Andersen Email: lan...@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803
The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================