%META:TOPICPARENT{name="ServerAgentAdministration"}%

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

Typical settings for <nop>PointBase, <nop>HyperSonic, and <nop>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
}}}