Thread: Postgresql installation Errors

Hello
We are currently trying to set up postgresql 7.4.3 on linux Enterprise
Server for use on a software platform called DSpace, as such we have also
installed Java, Apache-Ant and Tomcat 5.0.19 which are required for use with
Dspace. We have been unable to get past the gmake command in the
installation of Pgsql. We have retyped the error we encounter below

[javac]
/usr/dspace/postgresl-7.4.3/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3Ca
llableStatement.java:23: error: Invalid checked exception class
'java.sql.SQLExcception' in 'throws' clause.  The exception must be a
subclass of an exception thrown by
'org.postgresql.jdbc1.AbstractJdbc1Statment.createRefCursorResultSet(java.la
ng.String)' from calss 'org.postgresql.jdbc1.AbstractJdbcStatement.'

    [javac]        public PGRefCursorResultSet createRefCursorResultSet
(String cursorName) throws SqlException
    [javac]
    [javac]    4 errors

BUILD FAILED
file:/usr/dsapce/postgresql-7.4.3/src/interfaces/jdbc/build.xml:119 Compile
failed; see the compiler error output for details.

Total time: 1 saecond
gmake[3]: ***[all] Error 1
gmake[3]: Leaving derectory '/....../postgresql-7.4.3/src/interfaces/jdbc'
gmake[2]: ***[all] Error 2
gmake[2]: Leaving derectory '/....../postgresql-7.4.3/src/interfaces'
gmake[1]: ***[all] Error 2
gmake[1]: Leaving derectory '/....../postgresql-7.4.3/src'
gmake: *** [all] Error 2

We've also noticed that some missing entities such as prototypes,
declarations and arguments during the execution of the gmake command.  We
have retyped the error we encounter below

gcc -02 -fno-Strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations -fpic  -I../../../../src/interfaces/ecpg/include
-I../../../../src/interfaces/libpq -I../../../../src/include  -D_GNU_SOURCE
-c -o typename.o typename.c

gcc... -c -o descriptor.o descriptor.c

gcc... -c -o data.o data.c

gcc... -c -o error.o error.c

gcc... -c -o prepare.o prepare.c

.
.
.

gcc... -c -o misc.o misc.c



Please note to set up our source tree, we ran configure --enable-multibyte
--enable-unicode --with-java

Your help will be greatly appreciated in setting up pgsql to install
properly.

On Thu, 16 Dec 2004, Christine Warren wrote:

> We are currently trying to set up postgresql 7.4.3 on linux Enterprise
> Server for use on a software platform called DSpace, as such we have also
> installed Java, Apache-Ant and Tomcat 5.0.19 which are required for use with
> Dspace. We have been unable to get past the gmake command in the
> installation of Pgsql. We have retyped the error we encounter below
>
> [javac]
> /usr/dspace/postgresl-7.4.3/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3Ca
> llableStatement.java:23: error: Invalid checked exception class
> 'java.sql.SQLExcception' in 'throws' clause.  The exception must be a
> subclass of an exception thrown by
> 'org.postgresql.jdbc1.AbstractJdbc1Statment.createRefCursorResultSet(java.la
> ng.String)' from calss 'org.postgresql.jdbc1.AbstractJdbcStatement.'
>
>     [javac]        public PGRefCursorResultSet createRefCursorResultSet
> (String cursorName) throws SqlException
>     [javac]
>     [javac]    4 errors
>

This is clearly not the original error message, it looks like you've
retyped it adding numerous errors.  This makes it difficult to determine
what the real problem is.  I believe the problem is that another version
of the JDBC driver is in your classpath or is otherwise available to
the compiler which is causing the error.  Please check what existing jar
files you have installed.

Also note that you do not need to build the driver and you can simply
download a pre-built version from http://jdbc.postgresql.org/download.html

Kris Jurka