For jConnect to function properly, you must install stored procedures and tables on the Adaptive Server Enterprise or Adaptive Server Anywhere database to which your application will be connecting. jConnect provides the following scripts to install the required stored procedures and tables:
sql_server12.5.sql, which installs stored procedures on Adaptive Server Enterprise versions 12.5.x. or later.
sql_server15.0.sql, which installs stored procedures for Adaptive Server Enterprise 15.x or later.
sql_asa.sql, which installs stored procedures on SQL Anywhere and Adaptive Server Anywhere databases.
If you use ASE 12.5.3 or later, or ASA 9.0.2 or later,
the scripts come pre-installed on the server. You will need to install
these scripts only if you have a later version of the driver than
the one that shipped with ASE. In addition, for backward compatibility, sql_server.sql and sql_server12.sql are included
on ASE 11.9.2 and 12.0 respectively, although these versions are
no longer supported.
Running stored-procedure installation scripts
Verify that your JAVA_HOME, JDBC_HOME, and CLASSPATH environment variables are set.
Use the IsqlApp sample application according to the instructions in the following sections, based on the target database and your platform.