PostgreSQL JDBC Driver Homepage

What's being worked on at the moment

This is the list of things being worked on in the driver:

Item	Status	Expected
Add Stream support to large objects	Delayed	6.6
Add copy support to driver	Planning	6.5
Implement CallableStatement	I need more information on this one
Borland JBuilder Compatibility	I've had a report from Javier Pardo Vidal that JBuilder 3.0 works with the driver.

What's been changed in the driver?

These changes are in V6.5:

Jun 13 1999
	Rob Huttons instructions on getting the driver to work with Visual Cafe Database Edition 3.0 are now available on the site.
	Reaping any Large Object Orphans left when deleting rows refering to a large object, but the object remains in the database. This affects JDBC & ODBC, and a solution is implemented in C, not in Java. This is located in the src/contrib/vacuumlo directory of the source tree.
May 19 1999
	Internationalisation now done. Surprising that there's 68 error messages in the driver ;-)
May 18 1999
	Set the ImageViewer application to use transactions
	Just after committing, I realised why internationalisation isn't working. This is now fixed (in the Makefile).
May 17 1999
	PG_Stream.close() now attempts to send the close connection message to the backend before closing the streams
	Added batch support in the JDBC2, supplied by Yutaka Tanida
	Removed the old datestyle code. Now the driver uses only ISO.
	Removed some files in the postgresql directory still in CVS that were moved since 6.4.x (DatabaseMetaData.java PreparedStatement.java ResultSetMetaData.java Statement.java)
	Internationalisation of the error messages is partially implemented, however it's not enabled as it only works when the jar file is _not_ used, and work needs to be done.
Apr 11 1999
	getUpdateCount() now returns the actual update count (before it simply returned 1 for everything).
	added some updates to example.basic so it would test the new update count code.
	corrected typo in a comment in Statement.java
Jan 25 1999
	created subfolders example/corba and example/corba/idl to hold the new example showing how to hook CORBA and PostgreSQL via JDBC
	implemented some JDBC2 methods curtesy of Joachim.Gabler@t-online.de
Jan 23 1999
	Changed imports in postgresql.jdbc1.ResultSetMetaData as for some reason it didn't want to compile under jdk1.1.6
Dec 29 1998
	Refreshed the README (which was way out of date)
	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
	Fixed package imports and some references to java.sql.ResultSet in various files. Compiled and tested the JDBC1 driver.
Dec 28 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: CallableStatement Connection DatabaseMetaData PreparedStatement ResultSet ResultSetMetaData 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

These changes are in V6.4:

Oct 7 1998
	Made the driver Thread Safe

These changes have been made to the driver since V6.3.2:

June 2 1998
	Bug Fix
		PreparedStatement.setObject didn't handle short's
		ResultSet.getDate() now handles null dates (returns null rather than a NullPointerException)
		ResultSetMetaData.getPrecision() now returns 0 for VARCHAR
	New Feature
		Field now caches the typename->oid in a Hashtable to speed things up. It removes the need for some unnecessary queries to the backend.
		PreparedStatement.toString() now returns the sql statement that it will send to the backend. Before it did nothing.
		DatabaseMetaData.getTypeInfo() now does something.

How to be notified about updates