Tue Dec 29 15:45:00 GMT 1998

- Refreshed the README (which was way out of date)

Tue Dec 29 15:45:00 GMT 1998

- Finished adding the additional methods into the JDBC2 driver.

- Had to add some explicit package references for the JDK1.2 Javac to

cope with the driver

Tue Dec 29 12:40:00 GMT 1998

- Fixed package imports and some references to java.sql.ResultSet in

various files. Compiled and tested the JDBC1 driver.

Mon Dec 28 19:01:37 GMT 1998

- created a new package postgresql.jdbc2 which will contain the JDBC 2

specific classes. A similar new package (postgresql.jdbc1) has been

created to hold the JDBC 1 specific classes.

- modified Makefile to allow compilation of the JDBC 1 & 2 drivers,

with the possibility of building a dual-spec driver.

- changed the version number in postgresql.Driver to 6.5

- modified postgresql.Driver class to initiate the correct driver when

used under a 1.1 or 1.2+ JVM.

- postgresql.Connection and postgresql.jdbc2.Connection now extends the

new class postgresql.ConnectionStub, which allows us to dynamically

open the JDBC1 or JDBC2 drivers.

- enabled compilation of the driver under Win32 when using the Make

from the CygWin package (Cygnus B20.1 was used).

- To make future development easier (now we have 2 specifications to

work with) the following classes have moved from the postgresql to

the postgresql.jdbc1 package:

CallableStatementConnection

DatabaseMetaDataPreparedStatement

ResultSetResultSetMetaData

Statement

Some of these classes have common code that is not dependent on

either JDBC specification. These common code are still in the

postgresql package.

Ie: postgresql.jdbc1.Connection extends postgresql.Connection

and postgresql.jdbc2.Connection extends postgresql.Connection

Web Oct 7 22:00:00 BST 1998

- removed syncronised from Connection.ExecSQL(). See next entry.

- added new syncronised locking in the Connection.ExecSQL() and

and getSchemaName().

- Created new class postgresql.util.PGmoney to map the money type

- Created new class postgresql.geometric.PGline to map the line type

This short document is provided to help programmers through the internals of

the PostgreSQL JDBC driver.

Makefile

--------

All compilation must be done by using Make. This is because there are two

versions of the driver, one for JDBC1 (for JDK 1.1.x) and the other for JDBC2

(for JDK 1.2 or later). The makefile determines which version to compile by

using a helper class makeVersion. This class is only used by make, and is not

stored in the Jar file.

Note:It is not sufficient to simply call javac on postgresql/Driver.java as

some classes are dynamically loaded, so javac will not compile them.

postgresql.jar

--------------

This jar file is produced by make, and contains the driver for your JDK

platform.

Note:It is possible to compile the driver under say JDK1.1.7, then under

JDK 1.2. Because make doesn't remove the old classes before compiling,

jar will simply package both sets together. When the driver is loaded,

the postgresql.Driver class will sort out which set of classes to use.

Importing packages

------------------

In user code, you may have to import one or more packages, if and only if you

are using the non jdbc extensions (like FastPath, or LargeObject).

DO NOT import the postgresql, postgresql.jdbc1 or postgresql.jdbc2 packages!

Internally, some classes will import the packages when there is a link between

them and the other packages. However, the above rule still applies. It's there

because Javac becomes confused between the different places that similar class

names are present.

However, there are places where they need to refer to classes in the postgresql

package. In this case, import the individual classes, and not the entire

package.

ie:import postgresql.Field

NOTimport postgresql.*

Package Layout

--------------

The driver is split into several packages:

postgresqlcore classes, common to both JDBC 1 & 2

postgresql.jdbc1classes used only in implementing JDBC 1

postgresql.jdbc2classes used only in implementing JDBC 2

postgresql.fastpathFastPath to backend functions

postgresql.geometric2D Geometric types mapped to Java Objects

postgresql.largeobjectLow level Large Object access

postgresql.utilUtility classes

Package postgresql

------------------

This package holds the core classes.

Driverregisters the driver when it's loaded, and determines which

Connection class (in jdbc1 or jdbc2 packages) to use when

connecting to a database.

FieldUsed internally to represent a Field

PG_StreamUsed internally to manage the network stream.

These classes contains common code that is not dependent to the

two JDBC specifications.

ConnectionCommon code used in Connections, mainly Network Protocol stuff.

ResultSetCommon code used in ResultSet's

Package postgresql.fastpath

---------------------------

FastpathHandles executing a function on the PostgreSQL Backend

FastpathArgDefines an argument for a function call

Package postgresql.geometric

----------------------------

PGboxMaps to postgresql type box

PGcircleMaps to postgresql type circle

PGlineMaps to postgresql type line

PGlsegMaps to postgresql type lseg

PGpathMaps to postgresql type path

PGpointMaps to postgresql type point

PGpolygonMaps to postgresql type polygon

Package postgresql.jdbc1

------------------------

The classes in this package handle the JDBC 1 Specification, for JDK 1.1.x

All interfaces in the java.sql package are present here.

Package postgresql.jdbc2

------------------------

The classes in this package handle the JDBC 2 Specification, for JDK 1.2

All interfaces in the java.sql, and javax.sql packages are present here.

Package postgresql.largeobject

------------------------------

LargeObjectRepresents an open LargeObject

LargeObjectManagerHandles the opening and deleting of LargeObjects

Package postgresql.util

-----------------------

PGmoneyMaps to postgresql type money

PGobjectUsed to represent postgresql types that have no Java equivalent

PGtokenizerHelper class for the geometric types

SerializeUsed to serialise Java objects into tabes, rather than Blobs

UnixCryptUsed to handle crypt authentication

FIND= find

JAR= jar

JAVA= java

.SUFFIXES:.class .java

.PHONY:all clean doc examples

all: postgresql.jar

all:makeVersion.class

make$$($(JAVA) makeVersion)

@echo ------------------------------------------------------------

@echo The JDBC driver has now been built. To make it available to

@echo other applications, copy the postgresql.jar file to a public

@echo"under unix for HotJava), and add a line containing"

@echo jdbc.drivers=postgresql.Driver

@echo

@echo More details arein the README file.

@echo More details arein the README file andin the main postgresql

@echo documentation.

@echo

@echo ------------------------------------------------------------

@echo To build the examples, type:

@echo" make examples"

OBJS=postgresql/CallableStatement.class\

postgresql/Connection.class\

postgresql/DatabaseMetaData.class\

postgresql/Driver.class\

postgresql/Field.class\

postgresql/PG_Stream.class\

postgresql/PreparedStatement.class\

postgresql/ResultSet.class\

postgresql/ResultSetMetaData.class\

postgresql/Statement.class\

postgresql/fastpath/Fastpath.class\

postgresql/fastpath/FastpathArg.class\

postgresql/geometric/PGbox.class\

postgresql/geometric/PGcircle.class\

postgresql/geometric/PGline.class\

postgresql/geometric/PGlseg.class\

postgresql/geometric/PGpath.class\

postgresql/geometric/PGpoint.class\

postgresql/geometric/PGpolygon.class\

postgresql/largeobject/LargeObject.class\

postgresql/largeobject/LargeObjectManager.class\

postgresql/util/PGmoney.class\

postgresql/util/PGobject.class\

postgresql/util/PGtokenizer.class\

postgresql/util/Serialize.class\

postgresql/util/UnixCrypt.class

postgresql.jar:$(OBJS)

OBJ_COMMON=postgresql/Connection.class\

postgresql/Driver.class\

postgresql/Field.class\

postgresql/PG_Stream.class\

postgresql/ResultSet.class\

postgresql/fastpath/Fastpath.class\

postgresql/fastpath/FastpathArg.class\

postgresql/geometric/PGbox.class\

postgresql/geometric/PGcircle.class\

postgresql/geometric/PGline.class\

postgresql/geometric/PGlseg.class\

postgresql/geometric/PGpath.class\

postgresql/geometric/PGpoint.class\

postgresql/geometric/PGpolygon.class\

postgresql/largeobject/LargeObject.class\

postgresql/largeobject/LargeObjectManager.class\

postgresql/util/PGmoney.class\

postgresql/util/PGobject.class\

postgresql/util/PGtokenizer.class\

postgresql/util/Serialize.class\

postgresql/util/UnixCrypt.class

OBJ_JDBC1=postgresql/jdbc1/CallableStatement.class\

postgresql/jdbc1/Connection.class\

postgresql/jdbc1/DatabaseMetaData.class\

postgresql/jdbc1/PreparedStatement.class\

postgresql/jdbc1/ResultSet.class\

postgresql/jdbc1/ResultSetMetaData.class\

postgresql/jdbc1/Statement.class

OBJ_JDBC2=postgresql/jdbc2/ResultSet.class\

postgresql/jdbc2/PreparedStatement.class\

postgresql/jdbc2/CallableStatement.class\

postgresql/jdbc2/Connection.class\

postgresql/jdbc2/DatabaseMetaData.class\

postgresql/jdbc2/ResultSetMetaData.class\

postgresql/jdbc2/Statement.class

jdbc0:

@echo

@echo FATAL ERROR!

@echo

@echo makeVersion has not been able to determine what version of

@echo the JDK you are using, and hence what version of the driver

@echo to compile.

@echo

@echo There are two versions available, one that conforms to the

@echo JDBC 1 specification, and one to the JDBC 2 specification.

@echo

@echo To build the driverfor JDBC 1 (usuallyfor JDK 1.1 thru 1.1.7)

@echothen type: make jdbc1

@echo

@echo To build the driverfor JDBC 2 (usuallyfor JDK 1.2 and later)

@echothen type: make jdbc2

@echo

@echo If you still have problems,then please email the interfaces

@echo or bugs lists, or better still to me direct (peter@retep.org.uk)

@echo

jdbc1:$(OBJ_COMMON)$(OBJ_JDBC1) postgresql.jar

jdbc2:$(OBJ_COMMON)$(OBJ_JDBC2) postgresql.jar

postgresql.jar:$(OBJ)$(OBJ_COMMON)

$(JAR) -c0f$@$$($(FIND) postgresql -name "*.class" -print)

clean: