Installing stored procedures

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.

1. 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
       

1. 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