Top

5.2.11.ODBC-JDBC Bridges for Java

OpenLink Lite Drivers for Unix can be configured in 3 ways:

Web Based Wizard
Web Based Forms
Manually

Once you have configured the generic parts of the data source using one of the above listed methods, you will need to define the driver environment. Below are the common options with their descriptions for the environment section:

      [Environment Jdbc14]
      CLASSPATH =.;c:\Program Files\OpenLink\Virtuoso 3.0\jdk14\virtjdbc3.jar
      ;PATH =
      ;JET_DROPCATALOGFROMDBMETACALLS  = YES
      ;JET_DROPSCHEMAFROMDBMETACALLS   = YES
      ;JET_NOSUPPORTOFQUOTEDIDENTIFIER = YES
      ;PATCHNULLSIZEOFSQLCHAR = 4096
      ;JET_SQLSTATISTICSOFF   = YES
    

Note that CLASSPATH is the critical environment variable that must be set to enable the JDBC driver class files to be located.