ServerAgentAdminOJDBCServer Agent AdministrationServer Agent Administration Bridge Agent for JDBC Data Sources (jdbc*_mv, jdbc*_sv) Table: 1. Default Rule Book settings <tgroup><thead /><tbody> <row><entry> <emphasis>Rule Book Section & parameters</emphasis> </entry><entry> <emphasis>Default Rule Book Settings</emphasis> </entry><entry> <emphasis>Notes</emphasis> </entry></row> <row><entry> [Environment Jdbc12] [Environment Jdbc13] </entry><entry> </entry><entry> Parameters are common to JDBC 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8 </entry></row> <row><entry> JET_SQLSTATISTICSOFF </entry><entry> FALSE </entry><entry> If set to TRUE, the function SQLStatistics returns an empty result set. This helps to resolve problems with SQLStatistics for some JDBC drivers. </entry></row> <row><entry> JET_DROPCATALOGFROMDBMETACALLS </entry><entry> FALSE </entry><entry> If set to TRUE, NULL will be assigned to the field Catalog in the result sets of SQLTables(), SQLColumns() & SQLStatistics() calls. </entry></row> <row><entry> JET_DROPSCHEMAFROMDBMETACALLS </entry><entry> FALSE </entry><entry> If set to TRUE, NULL will be assigned to the field Schema in the result sets of SQLTables(), SQLColumns() & SQLStatistics() calls. </entry></row> <row><entry> JET_NOSUPPORTOFQUOTEDIDENTIFIER </entry><entry> FALSE </entry><entry> 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 <emphasis>SELECT * FROM "Account"</emphasis> </entry></row> <row><entry> PATCHNULLSIZEOFSQLCHAR </entry><entry> </entry><entry> <para>If DBMS is returning a field of type SQLCHAR or SQLVARCHAR with zero size, the size will be replaced with the value of PATCHNULLSIZEOFSQLCHAR </para></entry></row> </tbody></tgroup></table> <para>Typical settings for PointBase, HyperSonic, and InstantDb are as follows:</para><programlisting>[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 </programlisting></section></docbook>