• Topic
  • Discussion
  • UdaWikiWeb.ServerAgentAdminOJDBC(Last) -- Owiki? , 2016-08-19 15:00:56 Edit owiki 2016-08-19 15:00:56

    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...