Re: Postgresql 7.3.1 + JDBC Build from Source

Hi,

I have done the following:

1) Install j2sdk
2) Install Jakarta Ant
3) Set up JAVA_HOME, ANT_HOME and PATH environments variables.
4) Install PostgreSQL (7.3.1):
4.1) ./configure --with-java
4.2) make
4.3) make install
5) Set up CLASSPATH
5.1) export CLASSPATH=/usr/local/pgsql/share/java/postgresql.jar:.
     DON'T FORGET THE "."

and I got it running! I think it help you!!

See ya,

Marcelo Pereira

-- Remember that only God and ^[:w saves.
        __
       (_.\           © Marcelo Pereira     |
        / / ___       marcelo@pereira.com   |
       / (_/ _ \__    [Math|99]-IMECC       |
_______\____/_\___)___Unicamp_______________/

--- Alan Searles, with his fast fingers, wrote:

:> 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
resolvesymbol  
:> > >     [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'
:>  :  :  :  :  :  :  :  :
:> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
:>
:>
:> ---------------------------(end of broadcast)---------------------------
:> TIP 2: you can get off all lists at once with the unregister command
:>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
:>