Subject: CVS commit: pkgsrc/databases/jdbc-postgresql
To: None <>
From: Jim Wise <>
List: pkgsrc-changes
Date: 09/10/2001 02:35:41
Module Name:	pkgsrc
Committed By:	jwise
Date:		Sun Sep  9 23:35:40 UTC 2001

Modified Files:
	pkgsrc/databases/jdbc-postgresql: Makefile distinfo
	pkgsrc/databases/jdbc-postgresql/patches: patch-aa
	pkgsrc/databases/jdbc-postgresql/pkg: PLIST
Removed Files:
	pkgsrc/databases/jdbc-postgresql/pkg: MESSAGE

Log Message:
Update to the version of the PostgreSQL JDBC support which comes with

Most visible changes are that the authors now use jakarta-ant to build
this package, and that the authors have removed support for building
javadoc documentation for this package.  This latter is rather unfortunate,
and may need to be addressed within the package.

Also, at some point this week, I will try to rework this package to use
the postgresql Makefile.common, as the original package now fits a little
more closely into the postgresql build hierarchy.

This package also adds one to the number of jakarta-ant using packages in
pkgsrc.  At some point soonish I will code up a USE_ANT flag in
to cut out the duplication of effort...

Other changes include:

Tue Mar 06 12:05:00 GMT 2001
        - Removed org.postgresql.xa.Test from the JDBC EE driver as it's an old
          test class and prevented it from compiling.

Fri Mar 02 10:00:00 GMT 2001
        - Fixed build.xml so that PGclob is not built in the JDBC1.2 driver

Fri Feb 17 18:25:00 GMT 2001
        - Removed the last deprecation warnings from the Java2 driver. Now only
          the old examples give deprecation warnings.
        - Added a new class into core that (JDK1.3+) ensures all connections are
          closed when the VM terminates.

Fri Feb 17 15:11:00 GMT 2001
        - Reduced the object overhead in PreparedStatement by reusing the same
          StringBuffer object throughout. Similarly SimpleDateStamp's are alse
          reused in a thread save manner.
        - Implemented in PreparedStatement: setNull(), setDate/Time/Timestamp
          using Calendar, setBlob(), setCharacterStream()
        - Clob's are now implemented in ResultSet & PreparedStatement!
        - Implemented a lot of DatabaseMetaData & ResultSetMetaData methods.
          We have about 18 unimplemented methods left in JDBC2 at the current

Web Feb 14 17:29:00 GMT 2001
        - Fixed bug in LargeObject & BlobOutputStream where the stream's output
          was not flushed when either the stream or the blob were closed.
        - Fixed PreparedStatement.setBinaryStream() where it ignored the length

Tue Feb 13 16:33:00 GMT 2001
        - More TestCases implemented. Refined the test suite api's.
        - Removed need for SimpleDateFormat in ResultSet.getDate() improving
        - Rewrote ResultSet.getTime() so that it uses JDK api's better.

Tue Feb 13 10:25:00 GMT 2001
        - Added MiscTest to hold reported problems from users.
        - Fixed PGMoney.
        - JBuilder4/JDBCExplorer now works with Money fields. Patched Field &
          ResultSet (lots of methods) for this one. Also changed cash/money to
          return type DOUBLE not DECIMAL. This broke JBuilder as zero scale
          BigDecimal's can't have decimal places!
        - When a Statement is reused, the previous ResultSet is now closed.
        - Removed deprecated call in ResultSet.getTime()

Thu Feb 08 18:53:00 GMT 2001
        - Changed a couple of settings in DatabaseMetaData where 7.1 now
          supports those features
        - Implemented the DatabaseMetaData TestCase.

Wed Feb 07 18:06:00 GMT 2001
        - Added comment to Connection.isClosed() explaining why we deviate from
          the JDBC2 specification.
        - Fixed bug where the Isolation Level is lost while in autocommit mode.
        - Fixed bug where several calls to getTransactionIsolationLevel()
          returned the first call's result.

Tue Feb 06 19:00:00 GMT 2001
        - Completed first two TestCase's for the test suite. JUnit is now
          recognised by ant.

Wed Jan 31 08:46:00 GMT 2001
        - Some minor additions to Statement to make our own extensions more
        - Statement.close() will now call ResultSet.close() rather than just
          dissasociating with it.

Tue Jan 30 22:24:00 GMT 2001
        - Fixed bug where Statement.setMaxRows() was a global setting. Now
          limited to just itself.
        - Changed[],int,int) to return the actual number
          of bytes read (used to be void).
        - LargeObject now supports InputStream's!
        - PreparedStatement.setBinaryStream() now works!
        - ResultSet.getBinaryStream() now returns an InputStream that doesn't
          copy the blob into memory first!
        - Connection.isClosed() now tests to see if the connection is still alive
          rather than if it thinks it's alive.
Thu Jan 25 09:11:00 GMT 2001
        - Added an alternative constructor to PGSQLException so that debugging
          some more osteric bugs is easier. If only 1 arg is supplied and it's
          of type Exception, then that Exception's stacktrace is now included.

Wed Jan 24 09:18:00 GMT 2001
	- Removed the 8k limit by setting it to 64k

Fri Jan 19 08:47:00 GMT 2001
        - Applied patch submitted by John Schutz <> that
          fixed a bug with ANT's SQL functions (not needed for building but nice
          to have fixed).

Thu Jan 18 17:30:00 GMT 2001
        - Added new error message into "postgresql.notsensitive"
          This is used by jdbc2.ResultSet when a method is called that should
          fetch the current value of a row from the database refreshRow() for
        - These methods no longer throw the not implemented but the new noupdate
          error. This is in preparation for the Updateable ResultSet support
          which will overide these methods by extending the existing class to
          implement that functionality, but needed to show something other than
            all update*() methods, except those that took the column as a String
            as they were already implemented to convert the String to an int.
        - getFetchDirection() and setFetchDirection() now throws
          "postgresql.notimp" as we only support one direction.
          The CursorResultSet will overide this when its implemented.
        - Created a new class under jdbc2 UpdateableResultSet which extends
          ResultSet and overides the relevent update methods.
          This allows us to implement them easily at a later date.
        - In jdbc2.Connection, the following methods are now implemented:
        - The JDBC2 type mapping scheme almost complete, just needs SQLInput &
          SQLOutput to be implemented.
        - Removed some Statement methods that somehow appeared in Connection.
        - In jdbc2.Statement()
        - Finally removed the old 6.5.x driver.

Thu Jan 18 12:24:00 GMT 2001
        - These methods in org.postgresql.jdbc2.ResultSet are now implemented:
            getBigDecimal(int) ie: without a scale (why did this get missed?)
          NB: Where int represents the column name, the associated version
              taking a String were already implemented by calling the int
        - These methods no longer throw the not implemented but the new noupdate
          error. This is in preparation for the Updateable ResultSet support
          which will overide these methods by extending the existing class to
          implement that functionality, but needed to show something other than
        - Added new error message into "postgresql.noupdate"
          This is used by jdbc2.ResultSet when an update method is called and
          the ResultSet is not updateable. A new method notUpdateable() has been
          added to that class to throw this exception, keeping the binary size
        - Added new error message into "postgresql.psqlnotimp"
          This is used instead of unimplemented when it's a feature in the
          backend that is preventing this method from being implemented.
        - Removed getKeysetSize() as its not part of the ResultSet API

Thu Jan 18 09:46:00 GMT 2001
        - Applied modified patch from Richard Bullington-McGuire
          <>. I had to modify it as some of the code
          patched now exists in different classes, and some of it actually
          patched obsolete code.

Wed Jan 17 10:19:00 GMT 2001
        - Updated Implementation to include both ANT & JBuilder
        - Updated README to reflect the changes since 7.0
	- Created jdbc.jpr file which allows JBuilder to be used to edit the
          source. JBuilder _CAN_NOT_ be used to compile. You must use ANT for
          that. It's only to allow JBuilders syntax checking to improve the
          drivers source. Refer to Implementation for more details

Wed Dec 20 16:19:00 GMT 2000
	- Finished build.xml and updated and buildDriver to
	  match how Makefile and ANT operate.

Tue Dec 19 17:30:00 GMT 2000
	- Finally created ant build.xml file

Mon Nov 20 08:12:00 GMT 2000
	- Encoding patch to Connection by

Tue Oct 17 15:35:00 BST 2000
	- Changed getTimestamp() again. This time Michael Stephenson's
	  <> solution looked far better
	  than the original solution put in June.

Tue Oct 10 13:12:00 BST 2000
	- DatabaseMetaData.supportsAlterTableWithDropColumn() as psql doesn't
	  support dropping of individual columns
	- Merged in some last patches. Only 1 left, which may not be compatible
	  with jdbc1
	- Merged in my old retepsql project. Makefile now includes it.

Mon Oct 02 12:30:00 BST 2000
	- Merged in byte[] array allocation changes submitted by Gunnar R|nning

Mon Sep 25 14:22:00 BST 2000
	- Removed the DriverClass kludge. Now the org.postgresql.Driver class
	  is compiled from a template file, and now has both the connection
	  class (ie jdbc1/jdbc2) and the current version's from

Thu Jul 20 16:30:00 BST 2000
	- Fixed DatabaseMetaData.getTableTypes()

To generate a diff of this commit:
cvs rdiff -r1.10 -r1.11 pkgsrc/databases/jdbc-postgresql/Makefile
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/jdbc-postgresql/distinfo
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/jdbc-postgresql/patches/patch-aa
cvs rdiff -r1.2 -r0 pkgsrc/databases/jdbc-postgresql/pkg/MESSAGE
cvs rdiff -r1.4 -r1.5 pkgsrc/databases/jdbc-postgresql/pkg/PLIST

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.