When you access remote servers defined with JDBC-based classes, consider the following:
Your local database must be enabled for Java. Do not specify JAVA OFF when you create the database if you plan to use a JDBC-based server class.
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
As long as jConnect 5.5 is installed with Sybase IQ, no additional drivers need to be installed.
For optimum performance, Sybase recommends an ODBC-based class (asaodbc or aseodbc). See “Server class aseodbc” for platform restrictions on the aseodbc class.
Any remote server that you access using the asejdbc or asajdbc server class must be set up to handle a jConnect 5.5 based client. Setup occurs automatically for all supported Sybase servers.