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

Referenced by...

Server Agent Administration

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

Bridge Agent for JDBC Data Sources (jdbc_mv, jdbc_sv)