Connecting to a SQL Anywhere® 10.0 JDBC connection cache in EAServer 6.0.x throws a runtime exception. This is caused by a difference between Adaptive Server® Anywhere (ASA) 9.x and SQL Anywhere 10.0.
To prepare a SQL Anywhere database for use with jConnect™ for JDBC™, you need to install additional tables and stored procedures by executing a SQL script. The sql_asa.sql file installed with EAServer 6.0.x in the extras\jconnect-6.05\sp directory is intended for use with ASA 9.x and references a property, File Version, that is not supported in SQL Anywhere 10.x. To solve this issue, execute the jcatalog.sql file in the scripts directory in the SQL Anywhere installation directory on the destination SQL Anywhere 10.0 database instead of executing sql_asa.sql. For more information about deprecated features in SQL Anywhere 10.0, see the SQL Anywhere 10 - Changes and Upgrading book. [CR 471640, CR 483184]
