Accessing Sybase Via JDBC

(Under construction!)

There is an online JDBC tutorial here.

You can get jConnect from Sybase for a free evaluation. I installed a copy at /afs/eos.ncsu.edu/info/csc/csc432_info/LEC/sybase/install, which you should be able to use by setting the environment variables as described below.

Here are some steps to execute JDBC programs for accessing Sybase. The first set of instructions is all you need to get to a database, but you might play with the next few options as well.

To use jConnect, you will have to do the following initial steps.


% add jconnect
% setenv LOGIN you
% setenv PASSWORD your-sybase-password

Get the program SKRSample.java. Then do the following to execute it.
```
javac SKRSample.java
java SKRSample -u $LOGIN -p $PASSWORD
```
The above works for me; you will need to modify the Java source or create a table called Staff with an int field called salary.
Run the sample Java application that behaves somewhat like the isql program. You should, of course, study the source code for this application, which is available in $JDBC_HOME/sample/IsqlApp.java
```
 

java IsqlApp -U $LOGIN -P $PASSWORD -S jdbc:sybase:Tds:remus.csc.ncsu.edu:4000
```

Run a sample application that brings up a window that looks sort of OK, but I didn't quite test it yet.


% java sample.SybSample ReadCursor -U $LOGIN -P $PASSWORD -S jdbc:sybase:Tds:remus.csc.ncsu.edu:4000 &

Run a sample application that brings up a window and should behave like isql. This didn't work for me, however.
```
% java sample.SybSample IsqlApp -U $LOGIN -P $PASSWORD -S jdbc:sybase:Tds:remus.csc.ncsu.edu:4000 &
```