Server Class asejdbc (deprecated)

This server class is deprecated. Update your application to use server class aseodbc.

A server with server class asejdbc can be Adaptive Server Enterprise or SQL Anywhere Version 10 and later.

To create a server of type asejdbc, you must set the following cis option to enable the asejdbc class:

execute { set temporary option cis_option=131072 }

execute { create server MYSERVER class 'asejdbc' using 'myiqweb:4100' }

While Adaptive Server Enterprise data sources generally require no special configuration, ASE 15.5 requires the jConnect-6_0 metadata stored procedures and tables. See Accessing Remote Data > Server Classes for Remote Data Access > JDBC-based Server Classes > Server Class asejdbc > Installing jConnect 6.0 Metadata.

See SQL Anywhere Server - SQL Usage > Remote data and bulk operations > Server classes for remote data access > JDBC-based server classes > Server class asejdbc.

Note: This reference points to SQL Anywhere documentation.

Data Type Conversions
When you issue a CREATE TABLE statement to create a proxy table, Sybase IQ automatically converts the data types to the corresponding Adaptive Server Enterprise data types.
Installing jConnect 6.0 Metadata
Proxy tables for Adaptive Server Enterprise 15.5 data require jConnect 6.0 metadata.

Parent topic: JDBC-based Server Classes (deprecated)