For jConnect to function properly, you must install stored procedures and tables on the Adaptive Server or SQL Anywhere database to which your application will be connecting. jConnect provides these scripts to install the required stored procedures and tables:
sql_server.sql – installs stored procedures on Adaptive Server earlier than version 12.0.
sql_server12.sql – installs stored procedures on Adaptive Server 12.0.x.
sql_server12.5.sql – installs stored procedures on Adaptive Server 12.5.x.
sql_server15.0.sql – installs stored procedures on Adaptive Server 15.x or later.
sql_asa.sql – installs stored procedures on SQL Anywhere 9.x.
sql_asa10.sql – installs stored procedures on SQL Anywhere 10.x.
sql_asa11.sql – installs stored procedures on SQL Anywhere 11.x.
Running stored procedure installation scripts
Verify that your JAVA_HOME, JDBC_HOME, and CLASSPATH environment variables are set.
Use the IsqlApp sample application. For more information on IsqlApp, see “Installing stored procedures on an Adaptive Server database”.
Installing stored procedures on an Adaptive Server database
Go to the %JDBC_HOME%\classes (Microsoft Windows) or $JDBC_HOME/classes (UNIX platforms) directory and enter:
For Adaptive Server version 15.x:
Microsoft Windows:
java IsqlApp -U sa -P password -S jdbc:sybase:Tds:[hostname]:[port] -I %JDBC_HOME%\sp\sql_server15.0.sql -c go
UNIX platforms:
java IsqlApp -U sa -P password -S jdbc:sybase:Tds:[hostname]:[port] -I $JDBC_HOME/sp/sql_server15.0.sql -c go
For Adaptive Server version 12.5.x:
Microsoft Windows:
java IsqlApp -U sa -P password -S jdbc:sybase:Tds:[hostname]:[port] -I %JDBC_HOME%\sp\sql_server12.5.sql -c go
UNIX platforms:
java IsqlApp -U sa -P password -S jdbc:sybase:Tds:[hostname]:[port] -I $JDBC_HOME/sp/sql_server12.5.sql -c go
Installing stored procedures on a SQL Anywhere database
Go to the %JDBC_HOME%\classes (Microsoft Windows) or $JDBC_HOME/classes (UNIX platforms) directory and enter:
Microsoft Windows
java IsqlApp -U dba -P password -S jdbc:sybase:Tds:[hostname]:[port] -I %JDBC_HOME%\sp\sql_asa.sql -c go
UNIX platforms
java IsqlApp -U dba -P password -S jdbc:sybase:Tds:[hostname]:[port] -I $JDBC_HOME/sp/sql_asa.sql -c go