JDBC driver setup in UNIX

[Jim]

Hello,

I am writing a Java program to access Oracle
database using JDBC. My program works in
Windows but when I run it in Unix, it shows
the "SQLException: No suitable driver" error
message at run time.

I think the driver or environment variables
like Classpath might not be correctly set up
in Unix, and I don't what to do.

My Unix system is Solaris with BASH shell.

Could any body, please let me know how can I
fix the problem.

Thanks.

[Eki Y. Baskoro]

G'Day,

Try the following steps:

1. Unpack the Oracle Connector/J to, say, /usr/local directory
2. Edit /etc/profile file as follows:

export CLASSPATH=/usr/local/<dirname>

3. Run the following:

source /etc/profile

And, re-run your application.