Server Agent Administration

Bridge Agent for JDBC Data Sources (jdbc*_mv, jdbc*_sv)

Table: 1. Default Rule Book settings

Rule Book Section & parameters	Default Rule Book Settings	Notes
[Environment Jdbc12] [Environment Jdbc13]		Parameters are common to JDBC 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8
JET_SQLSTATISTICSOFF	FALSE	If set to TRUE, the function SQLStatistics returns an empty result set. This helps to resolve problems with SQLStatistics for some JDBC drivers.
JET_DROPCATALOGFROMDBMETACALLS	FALSE	If set to TRUE, NULL will be assigned to the field Catalog in the result sets of SQLTables(), SQLColumns() & SQLStatistics() calls.
JET_DROPSCHEMAFROMDBMETACALLS	FALSE	If set to TRUE, NULL will be assigned to the field Schema in the result sets of SQLTables(), SQLColumns() & SQLStatistics() calls.
JET_NOSUPPORTOFQUOTEDIDENTIFIER	FALSE	If set to TRUE, the call SQLGetInfo(SQL_IDENTIFIER_QUOTE_CHAR) will return the space (" "). This can be used if the DBMS doesn't support quoted SQL like SELECT * FROM "Account"
PATCHNULLSIZEOFSQLCHAR		If DBMS is returning a field of type SQLCHAR or SQLVARCHAR with zero size, the size will be replaced with the value of PATCHNULLSIZEOFSQLCHAR

Typical settings for PointBase, HyperSonic, and InstantDb are as follows:

[Environment Jdbc12PointBase]
;CLASSPATH =.;e:\java\pointbase\embedded\classes\pbembedded34EV.jar
;PATH =
JET_DROPCATALOGFROMDBMETACALLS = YES
JET_DROPSCHEMAFROMDBMETACALLS =  YES
JET_NOSUPPORTOFQUOTEDIDENTIFIER = YES

[Environment Jdbc12HyperSonic]
;CLASSPATH = .;e:\java\hypersonic\demo\hsql.jar
;PATH = 
PATCHNULLSIZEOFSQLCHAR = 4096
JET_SQLSTATISTICSOFF = YES

[Environment Jdbc12InstantDB]
;CLASSPATH = .;e:\InstantDB\Classes\idb.jar
;PATH = 
JET_NOSUPPORTOFQUOTEDIDENTIFIER = YES
JET_DROPSCHEMAFROMDBMETACALLS =  YES