- WebObjects 5.1
- WebObjects 5.2
Disclaimer for WebObjects 5.1: Sybase is not officially supported in WebObjects 5.1. This document only provides information on how to set up the connection panel in EOModeler so that you can connect to Sybase and reverse engineer an existing database with the EOModeler tool. Since Apple does not provide a Sybase plug-in, the JDBC adaptor functions like a generic JDBC adaptor.
To customize the JDBC adaptor, you can write a custom plug-in. See the Technical Note on how to write a JDBC plug-in at the URL:
http://developer.apple.com/technotes/tn/tn2027.html
Sybase server and JDBC driver used in this document:
- Sybase ASE version 12
- jconnect52.zip
Where to Obtain Sybase JDBC Drivers
The Sybase JDBC drivers are available from Sybase's Web site (http://www.sybase.com/). The files can be downloaded for free after you create a "MySybase" account.
Where to install the Sybase JDBC Driver
Assuming that you have downloaded the jconnect52.zip package, unzip the package and place the jconn2.jar file in the appropriate location.
Mac OS X
Place the Sybase jconn2.jar file into /Library/Java/Extensions or a directory listed in your CLASSPATH.
Windows 2000
1. Install the Sybase JDBC driver where the Java VM can find it.
The simplest procedure is to add the JDBC driver (jconn2.jar) to the Java VM's "extensions" directory. In Windows 2000, this directory is usually something similar to:
C:\\jdk1.3\\jre\\lib\\ext\\
The exact path depends on where JDK 1.3 is installed.
If preferred, the JDBC driver can be added to your CLASSPATH, either explicitly listing the jar file, or exploding the jar into a directory that is on the CLASSPATH.
2. For development or testing using Windows 2000, install the Sybase driver in $NEXT_ROOT/Library/Java and modify the JavaConfig.plist file accordingly.
If your WebObjects installation is not in C:/Apple, substitute the appropriate path in the instructions below.
Note: The UNIX notation of "/" for the directory separator is used in the instructions.
1. Log in with an administrator account.
2. Copy jconn2.jar to C:/Apple/Library/Java/
3. Edit the file C:/Apple/Library/Java/JavaConfig.plist
Add $NEXT_ROOT/Library/Java/jconn2.jar to the entry for the "DefaultClasspath". Items in the list should be separated by a semicolon ";".
Use the term "$NEXT_ROOT" literally, following the pattern of the other entries.
Specifying the URL and Driver in EOModler's connection panel
The URL should be of the format:
jdbc:sybase:Tds:<hostname>:<port#>
For example, to connect to a Sybase Server on myhost listening on port 4100, the URL will be:
jdbc:sybase:Tds:myhost:4100
You specify databases using the following URL syntax:
jdbc:sybase:Tds:<hostname>:<port#>/<database>
A character set can be specified using the following URL syntax:
jdbc:sybase:Tds:myServer:4100/testDB?charset=ascii_7
Enter the following into the Driver textfield in the EOModeler connection panel:
_Driver: com.sybase.jdbc2.jdbc.SybDriver
Note: The driver entry is needed for WebObjects 5.1 (all platforms) and WebObjects 5.2 (Windows 2000 only)
A typical JDBC Connection Panel in EOModeler looks like figure 1
Figure 1: Typical JDBC Connection Panel in EOModeler