The difference between JDBC on the client and in the database server is in how a connection is established with the database environment.
When you use client-side or server-side JDBC, you call the Drivermanager.getConnection() method to establish a connection to the server.
For client-side JDBC, you use the Sybase jConnect JDBC driver, and call the Drivermanager.getConnection() method with the identification of the server. This establishes a connection to the designated server.
For server-side JDBC, you use the Adaptive Server native JDBC driver, and call the Drivermanager.getConnection() method with one of the following values:
jdbc:default:connection
jdbc:sybase:ase
jdbc:default
empty string
This establishes a connection to the current server. Only the first call to the getConnection() method creates a new connection to the current server. Subsequent calls return a wrapper of that connection with all connection properties unchanged.
You can write JDBC classes to run at both the client and the server by using a conditional statement to set the URL.
