Re: Postgresql 7.3.1 + JDBC Build from Source

On Fri, 2003-01-17 at 23:16, Dave Cramer wrote:
> Alan,
>
> You likely have an old version of the jar somewhere in the classpath.
>
> Dave
> On Fri, 2003-01-17 at 22:02, Alan Searles wrote:
> > I am currently running Mandrake Linux 8.2. uname -r ==> 2.4.18-6mdk. I
> > have recently installed Sun Java 1.4.1, GNU GCC 3.2.1, as well as
> > Jakarta ANT 1.5.1
> >
> > Now I want to install the latest version of PostgreSQL (7.3.1) from
> > source... but I have having some problems getting the JDBC code to
> > compile properly.
> >
> > After I downloaded the source code... and un-compressed it...
> >
> > 1) I ran the ./configure command (all went well)
> > 2) I ran the gmake command
> >
> > ... and all went well with the 'gmake' until it came to the JDBC code.
> > I am getting the following messages:
> >
> > =================================================================================================
> > [javac]
> > /usr/src/postgresql-7.3.1/src/interfaces/jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java:240: cannot resolve symbol
> > [javac] symbol : constructor Array
> > (org.postgresql.PGConnection,int,org.postgresql.Field,java.sql.ResultSet)
> > [javac] location: class org.postgresql.jdbc2.Array
> > [javac] return (java.sql.Array) new org.postgresql.jdbc2.Array(
> > connection, i, fields[i - 1], (java.sql.ResultSet) this );
> > [javac]
> > /usr/src/postgresql-7.3.1/src/interfaces/jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java:420: incompatible types
> > [javac] found : java.sql.Statement
> > [javac] required: org.postgresql.jdbc2.Statement
> > [javac] return statement;
> > [javac] ^
> > [javac]
> > /usr/src/postgresql-7.3.1/src/interfaces/jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java:560: incompatible types
> > [javac] found : java.sql.PreparedStatement
> > [javac] required: org.postgresql.jdbc2.PreparedStatement
> > [javac] deleteStatement = ((java.sql.Connection)
> > connection).prepareStatement(deleteSQL.toString());
> > :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: ::
> > ==============================================================================================
> >
> > These are a sampling of the messages; there are others.
> >
> > What am I doing wrong ????? I very much want to get the Java interface
> > into PostgreSQL working.
> >
> > /Alan
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> --
> Dave Cramer <Dave(at)micro-automation(dot)net>
>

I have included some more messages below from the ANT/JAVA
compilation. As you can see, the CLASSPATH being used is....

/usr/src/postgresql-7.3.1/src/interfaces/jdbc/build <<-- PGsql 7.3.1

/usr/local/ant/lib/xml-apis.jar <<-- ANT 1.5.1
/usr/local/ant/lib/xercesImpl.jar <<--
/usr/local/ant/lib/optional.jar <<--
/usr/local/ant/lib/ant.jar <<--

/usr/java/j2sdk1.4.1_01/lib/tools.jar <<-- Java 1.4.1

I do not understand exactly how more "old" jar code is getting
included ???

<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
: : : : :
[javac] Compiling 26 source files to
/usr/src/postgresql-7.3.1/src/interfaces/jdbc/build
[javac] Using modern compiler
[javac] Compilation arguments:
[javac] '-d'
[javac] '/usr/src/postgresql-7.3.1/src/interfaces/jdbc/build'
[javac] '-classpath'
[javac]
'/usr/src/postgresql-7.3.1/src/interfaces/jdbc/build:/usr/local/ant/lib/xml-apis.jar:/usr/local/ant/lib/xercesImpl.jar:/usr/local/ant/lib/optional.jar:/usr/local/ant/lib/ant.jar:/usr/java/j2sdk1.4.1_01/lib/tools.jar'
[javac] '-sourcepath'
[javac] '/usr/src/postgresql-7.3.1/src/interfaces/jdbc'
[javac] '-g'
: : : : : : : :
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>