Set these properties on the General tab:
JDBC Driver Class The JDBC driver class name; for example, for a JCM_Sybase database type, enter:
com.sybase.jaguar.jcm.sybase.SybaseDriver
The configuration property name is driverClass.
JDBC Data Source Class The class or library name used to support single-phase commit transactions. The configuration property name is dataSourceClass. For Sybase_ASA or Sybase_ASE database types, enter:
com.sybase.jdbc3.jdbc.SybDataSource
For an Oracle database type, enter:
oracle.jdbc.pool.OracleDataSource
JDBC/XA Data Source Class The class name or library name used to support two-phase commit transactions, and the name of the XA resource library. The configuration property name is xaDataSourceClass For Sybase_ASA or Sybase_ASE database types, enter:
com.sybase.jdbc3.jdbc.SybXADataSource
For an Oracle database type, enter:
oracle.jdbc.xa.client.OracleXADataSource
Ping Connection SQL Statement SQL statement to use when testing the database connection with ping; the default is “select 1”. The configuration property name is pingSQL.
Driver Debugging On/Off Select to enable debugging for the driver; unselect to disable. The configuration property name is driverDebug.
Driver Debugging Settings Debug settings for the driver debugger. The configuration property name is driverDebugSettings, and the default is “STATIC:ALL.”
Truncate Nanoseconds A divisor/multiplier that is used to round the nanoseconds value in a java.sql.Timestamp to a granularity that the DBMS supports. The configuration property name is truncateNanos, and the default is 10000000.
Maximum Length for BLOB Update The maximum number of bytes allowed when updating a BLOB datatype using PreparedStatement.setBytes. The configuration property name is psMaximumBlobLength, and the default is 16384.
Maximum Length for CLOB Update The maximum number of characters allowed when updating a CLOB datatype using PreparedStatement.setString. The configuration property name is psMaximumClobLength, and the default is 16384.
