.SUFFIXES:.class .java

.PHONY:all clean doc

.PHONY:all clean doc examples

all: postgresql.jar

@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"place (under unix this could be /usr/local/lib) and add it"

@echo to the class path.

@echo

@echo Then either add -Djdbc.drivers=postgresql.Driver to the

@echo commandline when running your application, or edit the

@echo"properties file (~/.hotjava/properties under unix), and"

@echo add a line containing jdbc.drivers=postgresql.Driver

@echo

@echo More details arein the README file.

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

@echo To build the examples, type:

@echo" make examples"

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

@echo

doc:

$(JAVADOC) -public postgresql

export CLASSPATH=.;\

$(JAVADOC) -public\

postgresql\

postgresql.fastpath\

postgresql.largeobject

OBJS=postgresql/CallableStatement.class\

postgresql/Connection.class\

postgresql/DatabaseMetaData.class\

postgresql/Driver.class\

postgresql/Field.class\

postgresql/PG_Object.class\

postgresql/PG_Stream.class\

postgresql/PGbox.class\

postgresql/PGcircle.class\

postgresql/PGlobj.class\

postgresql/PGlseg.class\

postgresql/PGpath.class\

postgresql/PGpoint.class\

postgresql/PGpolygon.class\

postgresql/PGtokenizer.class\

postgresql/PreparedStatement.class\

postgresql/ResultSet.class\

postgresql/ResultSetMetaData.class\

postgresql/Statement.class

postgresql/Statement.class\

postgresql/fastpath/Fastpath.class\

postgresql/fastpath/FastpathArg.class\

postgresql/geometric/PGbox.class\

postgresql/geometric/PGcircle.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/PGobject.class\

postgresql/util/PGtokenizer.class

postgresql.jar:$(OBJS)

$(JAR) -c0vf$@$^

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

clean:

$(FIND). -name"*~" -exec$(RM) {}\;

$(FIND). -name"*.class" -exec$(RM) {}\;

$(FIND). -name"*.html" -exec$(RM) {}\;

$(RM) postgresql.jar

-$(RM) -rf Package-postgresql*output

postgresql/DatabaseMetaData.class:postgresql/DatabaseMetaData.java

postgresql/Driver.class:postgresql/Driver.java

postgresql/Field.class:postgresql/Field.java

postgresql/PG_Object.class:postgresql/PG_Object.java

postgresql/PG_Stream.class:postgresql/PG_Stream.java

postgresql/PGbox.class:postgresql/PGbox.java

postgresql/PGcircle.class:postgresql/PGcircle.java

postgresql/PGlobj.class:postgresql/PGlobj.java

postgresql/PGlseg.class:postgresql/PGlseg.java

postgresql/PGpath.class:postgresql/PGpath.java

postgresql/PGpoint.class:postgresql/PGpoint.java

postgresql/PGpolygon.class:postgresql/PGpolygon.java

postgresql/PGtokenizer.class:postgresql/PGtokenizer.java

postgresql/PreparedStatement.class:postgresql/PreparedStatement.java

postgresql/ResultSet.class:postgresql/ResultSet.java

postgresql/ResultSetMetaData.class:postgresql/ResultSetMetaData.java

postgresql/Statement.class:postgresql/Statement.java

postgresql/fastpath/Fastpath.class:postgresql/fastpath/Fastpath.java

postgresql/fastpath/FastpathArg.class:postgresql/fastpath/FastpathArg.java

postgresql/geometric/PGbox.class:postgresql/geometric/PGbox.java

postgresql/geometric/PGcircle.class:postgresql/geometric/PGcircle.java

postgresql/geometric/PGlseg.class:postgresql/geometric/PGlseg.java

postgresql/geometric/PGpath.class:postgresql/geometric/PGpath.java

postgresql/geometric/PGpoint.class:postgresql/geometric/PGpoint.java

postgresql/geometric/PGpolygon.class:postgresql/geometric/PGpolygon.java

postgresql/largeobject/LargeObject.class: postgresql/largeobject/LargeObject.java

postgresql/largeobject/LargeObjectManager.class: postgresql/largeobject/LargeObjectManager.java

postgresql/util/PGobject.class:postgresql/util/PGobject.java

postgresql/util/PGtokenizer.class:postgresql/util/PGtokenizer.java

EX=example/basic.class\

example/blobtest.class\

example/datestyle.class\

example/psql.class\

example/ImageViewer.class

examples:postgresql.jar$(EX)

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

@echo The examples have been built.

@echo

@echo For instructions on how to use them, simply run them. For example:

@echo

@echo" java example.blobtest"

@echo

@echo This would display instructions on how to run the example.

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

@echo Available examples:

@echo

@echo" example.basic Basic JDBC useage"

@echo" example.blobtest Binary Large Object tests"

@echo" example.datestyle Shows how datestyles are handled"

@echo" example.ImageViewer Example application storing images"

@echo" example.psql Simple java implementation of psql"

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

@echo

example/basic.class:example/basic.java

example/blobtest.class:example/blobtest.java

example/datestyle.class:example/datestyle.java

example/psql.class:example/psql.java

example/ImageViewer.class:example/ImageViewer.java

http://www.blackdown.org

For problems with this driver, then refer to the postgres-interfaces email

list:

http://www.postgresql.org

By the time V6.3 is released, full documentation will be on the web, and in

the distribution.

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

COMPILING

By default, the driver doesn't use password authentication. You can enable

this by adding the argument auth. ie:

jdbc:postgresql:database?user=me&password=mypass&auth=y

jdbc:postgresql:database?user=me&password=mypass&auth=password

or if passing the user & password directly via DriverManager.getConnection():

jdbc:postgresql:database?auth=y

jdbc:postgresql:database?auth=password

PS: Password authentication is enabled if the value of auth starts with 'y'.

PS: Password authentication is enabled if the value of auth starts with 'p'.

It is case insensitive.

As of postgresql 6.3, Ident (RFC 1413) authentication is also supported.

Simply use auth=ident in the url.

Also, as of 6.3, a system property of postgresql.auth is supported. This

defines the default authentication to use. The auth property overides this.

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

That's the basics related to this driver. You'll need to read the JDBC Docs

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

Peter T Mount,October 28 1997

Peter T Mount,January 11 1998

home email: pmount@maidast.demon.co.ukhttp://www.demon.co.uk/finder

work email: peter@maidstone.gov.ukhttp://www.maidstone.gov.uk

Ok, here's the JDBC patch.

The jdbc6.3.tar.gz file that I've uploaded ftp.postgresql.org contains the

following files:

README_6.3 This message

blob.patch The patch to src/backend/tcop/fastpath.c fixing large objects

jdbc.tar The entire jdbc driver

I've put the entire driver here, rather than a patch, because its become

too complicated to do one this time. Files have been moved, two files

removed because they were obsolete, and there are a lot of new files.

Heres what the patch does:

* Memory overflow problem in the backend causing large objects to fail in

both libpq & jdbc (causing the backend to crash with a Segmentation

Violation)

* Problem with equals() method on the geometric support classes if the

class being checked wasn't the same class

* Fixed output of PGpath and PGpolygon support classes (missing , separator)

* Optimised the geometric support classes

* HTMLised the inline documentation, so the output of javadoc is easier

to read (mainly paragraphs)

* Removed obsolete class PGlobj (it never worked, and has been replaced

to read (mainly paragraphs)

* Removed obsolete class PGlobj (it never worked, and has been replaced

by the postgresql.largeobject package)

* Removed obsolete example JDBC_Test.java (replaced by new examples)

* Added < and > to nesting in PGtokenizer.

* Added fastpath support as a new package

* Added large object support as a new package

* Added ability of user code to handle custom storage types.

* Added new example testing the importing and exporting of a large object

* Added example application showing how to store and display images stored

as large objects

* Added example implementing part of psql client. This shows how to find out

what tables/columns are in a database (not yet complete)

* ResultSet.getBytes() now returns large object if field is an oid

* ResultSet.getString() now doesn't call getBytes() as this now would

cause an infinite loop because of large object support in getBytes()

* PreparedStatement.setBytes() now create a large object, and store its

oid into the column

* Reworked date style handling to make it easier to support new styles

* Added german and ISO styles, now all styles supported by postgresql

are now supported by the driver

* Fixed DatabaseMetaData.getTables()

* DatabaseMetaData.getTableTypes() returns our supported types.

* Fixed DatabaseMetaData.getColumns()

These three are required for Borland's JBuilder to work. For now they

return an empty result, as I'm not sure yet on how to get the

required results.

* DatabaseMetaData.getBestRowIdentifier()

* DatabaseMetaData.getProcedureColumns()

* DatabaseMetaData.getIndexInfo()

Finally, one change that is incompatible with earlier versions of the

driver. This change only affects any client code that uses the geometric

classes (eg: PGpoint) or the getObject()/setObject() methods.

Because of a problem with javac, if user code includes the line:

import postgresql.*;

then javac will fail, saying that interfaces cannot be instanciated.

To fix this, I've moved these classes into a new sub package,

postgresql.geometric and the PG_Object (renamed PGobject), and PGtokenizer

to postgresql.util.So the above line would become:

import postgresql.geometric.*;

Anyhow, I'm going to start writing some proper documentation for the

driver. For now, there is some available temporarily at:

http://www.demon.co.uk/finder/postgres/jdbc/packages.html