jConnect for JDBC - Post Installation Tasks

[Former Member]

Hello Everyone,

I'm quite not familiar with the JDBC driver that is why I posted this. Our client have requested to install JDBC driver to PI server (running on AIX platform).

I used the guide for installation but in chapter 3 - Post installation task, I am not able to continue because i have no knowledge in Sybase.

This are the task that are included

1. Setting JDBC_HOME - done

2. Setting CLASSPATH - done

3. Installing stored procedures - for this item, i don't know how to proceed.

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.0.x

through 15.5.x.

• sql_server15.7.sql – installs stored procedures on Adaptive Server 15.7 or

later.

• sql_server15.7.2.sql – installs stored procedures on Adaptive Server 15.7

ESD #2 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.

• sql_asa12.sql – installs stored procedures on SQL Anywhere 12.x.

And also this one

❖ Installing stored procedures on an Adaptive Server database

For Adaptive Server version 15.x:

• 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:

• UNIX platforms:

java IsqlApp -U sa -P password -S jdbc:sybase:Tds:[hostname]:[port]

-I $JDBC_HOME/sp/sql_server12.5.sql -c go

Please let me know how to proceed. Thanks

[Former Member]

Hi.

Where can I download .sql files for SQL Anywhere 16 to install stored procedures?

Thanks.