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@micro-automation.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'
 :  :  :  :  :  :  :  :
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>