Using a Sybase 10 Database with the Sybase 11.01 Server

Note: Sybase database servers may be used for demonstration, training. and development; they are not tested for production deployment.

Follow these steps to work with a Sybase 10 database if you are using the Sybase 11.01 server.

1. Determine which JVM your tomcat installation is using.
   To do so, copy:
   

   C:/Program Files/SQL Anywhere 11/(BIN64 or BIN32)/dbjdbc11.dll
   

   to
   

   C:/Program Files (or x86 if using 32 bit JVM)/Java/(Java version in use)/bin/dbjdbc11.dll.

2. Copy C:\Program Files\SQL Anywhere 11\Java\sajdbc.jar into .../archibus/WEB-INF/lib/.
3. Remove jodbc.jar and jconn3.jar from that folder.
4. Modify line 676 in afm-config.xmlas follows:\

   <jdbc driver="sybase.jdbc.sqlanywhere.IDriver" url="jdbc:sybase:Tds:localhost:2638" connectFormat="1" transactionIsolationLevel="1"/ <sql>
   

5. Modify afm-projects so that your JDBC strings look like the following, replacing server_name with the name of your Sybase 11 instance:

   <jdbc url="jdbc:sqlanywhere:uid=afm;pwd=afm;eng=server_name" />