ASA SQL User's Guide
Server Classes for Remote Data Access
JDBC-based server classes
When you access remote servers defined with JDBC-based classes, consider that:
Your local database must be enabled for Java.
For more information, see Java-enabling a database.
The Java virtual machine needs more than the default amount of memory to load and run jConnect. Set these memory options to at least the following values:
SET OPTION PUBLIC.JAVA_NAMESPACE_SIZE = 3000000 SET OPTION PUBLIC.JAVA_HEAP_SIZE = 1000000
Since jConnect 4.0 is automatically installed with Adaptive Server Anywhere, no additional drivers need to be installed.
For optimum performance, Sybase recommends an ODBC-based class (asaodbc or aseodbc).
Any remote server that you access using the asejdbc or asajdbc server class must be set up to handle a jConnect 4.x based client. The jConnect setup scripts are SQL_anywhere.SQL for Adaptive Server Anywhere or SQL_server.SQL for Adaptive Server Enterprise. Run these against any remote server you will be using.