Re: Unable to download/compile postgresql.jar for PG 7.3 with JDK 1.4.1

On Thursday 02 January 2003 09:27, Rich Cullingford wrote:

#1. Your log seems to indicate a 7.2.3 installation, based on the paths.
#2. If it is 7.3 extracted into a directory called 'postgresql-7.2.3', then
your JAVA_HOME is set incorrectly to point at a JDK 1.3.x or earlier JDK,
instead of JDK 1.4.x. It shows you're compiling for the J2EE version of the
driver rather than the JDK 1.4 version of the driver (i.e. JDBC 2 EE, not
JDBC 3).

> All:
> This is a brand new installation of PG 7.3 (i.e., no old versions of the
> JDBC jar file exist).
>
> I've tried several methods of getting a working driver. First, I
> obtained pg73jdbc3.jar from the d/l site. In trying to test it with
> DatabaseMetaData, I get the following odd error on a getColumns() call:
>
> Exception in thread "main" java.sql.SQLException: ERROR: No such
> attribute a.oid
>
> at org.postgresql.Connection.ExecSQL(Connection.java:393)
> at
> org.postgresql.jdbc2.DatabaseMetaData.getColumns(DatabaseMetaData.java:1880
>) at com.sysd.sql.SchemaInfo.main(SchemaInfo.java:639)
>
> If I'm interpreting the comments on the JDBC 2.0 Compliance site
> correctly, column-type metadata should be supported in PG 7.3.
>
> Next, I tried compiling from source using the --with-java flag to
> configure. The 1.4.1 compiler complains about uses of deprecated
> classes/methods and missing symbols, and finally craps out:
>
> -----------extract of javac log-------------
>
> [echo] Configured build for the JDBC2 Enterprise edition driver
>
> compile:
> [javac] Compiling 53 source files to
> /n/winwood/u/winwood/rculling/pg/postg
> esql-7.2.3/src/interfaces/jdbc/build
> [javac]
> /n/winwood/u/winwood/rculling/pg/postgresql-7.2.3/src/interfaces/jd
> c/org/postgresql/xa/XAConnectionImpl.java:57: cannot resolve symbol
> [javac] symbol : class RollbackException
> [javac] location: package transaction
> [javac] import javax.transaction.RollbackException;
> [javac] ^
> [javac]