# CHAPTER 2: JDBC API Implementation

The JDBC API implementation is packaged as:

       empress.jdbc (category 2 implementation)
    	or
       com.empress.jdbc4 (category 4 implementation)

    Other Empress related information is as follows:

    The Driver load command is:

    Class.forName ("empress.jdbc.empressDriver");
    for category 2 JDBC driver.

    Class.forName ("empress.jdbc.empressLocalDriver");
    for category 2 JDBC "Local Access" Driver.

    Class.forName ("com.empress.jdbc4.empressDriver");
    for category 4 JDBC driver.

    The Empress URL syntax is:

    jdbc:empress:subname

    where subname is:

       //SERVER=<server name>;PORT=<port number>;DATABASE=<database name>

    For example:

    //SERVER=sv1;PORT=6322;DATABASE=testdb

    where sv1 is a server machine hostname, 6322 is the Empress
    Connectivity Server service port number and testdb is the database name.
    Database name could be logical or physical name depending on Connectivity
    Server/RDBMS configuration settings.

    Alternatevely, and only for the Category 2 Driver, subname could be
    defined as a Data Source Name (as specified in an ODBC.INI file).
    In this case, for example, URL could like like:
    jdbc:empress:myDSN

    The Empress JDBC Drivers have been tested against Java Development Kit (JDK)
    versions 1.4 and 1.5.

    The Empress JDBC Category 2 and Category 4 Drivers are implementation of JDBC 3.0,
    but some features in JDBC 3.0 are not supported.