JET Proxy JDBC Server

With a type 3 driver, we need to have a "Middleware" component.  The JET Proxy JDBC Server provides this function.

The JET Proxy Server is an RMI based server.  It runs it's own instance of the RMI Registry internally.  It is 100% pure java, though some of your JDBC drivers may require native pieces.

Installation and Getting Started

To install the JET Proxy server, simply download the complete JET Proxy package, and unzip into a suitable directory on your hard drive (c:\JETProxy would work, or /usr/local/JETProxy on *NIX)  Once you have done this you'll need to edit two files.

1) First, edit the start_server.bat file.  Set the JAVA_HOME property to be the root of your java installation.  (JDK/JRE 1.1-1.3 are ok)  In addition, modify the DRIVERS property to include any JDBC drivers you would like to use.  The JDBC-ODBC bridge is included with the JDK, so you won't need to include anything additional if this is the underlying driver you'll be working with.

2) Modify the config.properties file to setup shares.  Shares are the common names for the JDBC connections that users will be able to connect to.  Each share needs to define a DRIVER_CLASS, and CONNECTION_URL at a minimum.  Additional properties necessary for the driver can be put in CONNECTION_PROPERTIES.

Once configured, simply execute the start_server batch/shell script, and your server will be running.

A sample config.properties file is shown below for reference.

############################################################################
# Properties file for configuration of the 
# JET JDBC Proxy Server
#
# Copyright 2000, Java Enterprise Technologies
############################################################################

# Log File Directory.  Defaults to <install root>/log if not 
# explicitly defined here.

LOG_DIR="d:/test/proxy/log"

LOG_TO_CONSOLE="true"

#
# RMI Registry Host and port
# Use your real 
REGISTRY_HOST="localhost"
REGISTRY_PORT="52372"

#
# Define the database shares
#
SHARES=
{
	# Northwind: Sample database that comes with access
	Northwind=
	{
		DRIVER_CLASS="sun.jdbc.odbc.JdbcOdbcDriver"
		CONNECTION_URL="jdbc:odbc:Northwind"
		CONNECTION_PROPERTIES=
		{
			user=""
			password=""

		}
	}
	# By supplying the user name and password here, users of this 
	# share will not need to supply a username and password when connecting
	# to this data source.
	UnSecure=
	{	
		DRIVER_CLASS="sun.jdbc.odbc.JdbcOdbcDriver"
		CONNECTION_URL="jdbc:odbc:LocalServer"
		CONNECTION_PROPERTIES=
		{
			user="sa"
			password="mypassword"

		}
	}
	# Because no user name and password are supplied here the 
	# security defaults to the underlying driver's security.  The remote
	# JDBC client will need to specify a username and password if the  
	# underlying driver requires it.
	Secure=
	{	
		DRIVER_CLASS="sun.jdbc.odbc.JdbcOdbcDriver"
		CONNECTION_URL="jdbc:odbc:LocalServer"
		CONNECTION_PROPERTIES=
		{
		}
	}
}