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.