Обсуждение: RedHat Enterprise 3 and the JDBC driver

Sorry if this is a repeated report of this problem (a cursory look
through google turned up nothing).

For some reason I can't build the jdbc driver on my RHE3 box.  Works
just dandy on the RH9 box sitting right next to it.

It's not really a show stopper since it's just the driver, and you can
download it from the site seperately.

The output from ant:

driver:
     [copy] Copying 1 file to
/root/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql
     [echo] Configured build for the JDBC3 edition driver with NO SSL

compile:
    [javac] Compiling 77 source files to
/root/postgresql-7.4.1/src/interfaces/jdbc/build
    [javac]
/root/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3Statement.java:28: error: Invalid checked
exceptionclass `java.sql.SQLException' in `throws' clause. The exception must be a subclass of an exception thrown by
`org.postgresql.jdbc1.AbstractJdbc1Statement.createRefCursorResultSet(java.lang.String)'from class
`org.postgresql.jdbc1.AbstractJdbc1Statement'.
    [javac]             public PGRefCursorResultSet
createRefCursorResultSet (String cursorName) throws SQLException
    [javac]                                          ^
    [javac]
/root/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3PreparedStatement.java:23: error: Invalid checked
exceptionclass `java.sql.SQLException' in `throws' clause. The exception must be a subclass of an exception thrown by
`org.postgresql.jdbc1.AbstractJdbc1Statement.createRefCursorResultSet(java.lang.String)'from class
`org.postgresql.jdbc1.AbstractJdbc1Statement'.
    [javac]             public PGRefCursorResultSet
createRefCursorResultSet (String cursorName) throws SQLException
    [javac]                                          ^
    [javac]
/root/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3PoolingDataSource.java:29: error: Method
`org.postgresql.jdbc2.optional.PoolingDataSource.getDataSource(java.lang.String)'was defined with return type
`org.postgresql.jdbc2.optional.PoolingDataSource'in class `org.postgresql.jdbc2.optional.PoolingDataSource'. 
    [javac]        static Jdbc3PoolingDataSource getDataSource(String
name)
    [javac]                                      ^
    [javac]
/root/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3CallableStatement.java:23: error: Invalid checked
exceptionclass `java.sql.SQLException' in `throws' clause. The exception must be a subclass of an exception thrown by
`org.postgresql.jdbc1.AbstractJdbc1Statement.createRefCursorResultSet(java.lang.String)'from class
`org.postgresql.jdbc1.AbstractJdbc1Statement'.
    [javac]             public PGRefCursorResultSet
createRefCursorResultSet (String cursorName) throws SQLException
    [javac]                                          ^
    [javac] 4 errors

BUILD FAILED
file:/root/postgresql-7.4.1/src/interfaces/jdbc/build.xml:116: Compile
failed; see the compiler error output for details.

Andrew Holm-Hansen wrote:
> Sorry if this is a repeated report of this problem (a cursory look
> through google turned up nothing).
>
> For some reason I can't build the jdbc driver on my RHE3 box.  Works
> just dandy on the RH9 box sitting right next to it.
>
> It's not really a show stopper since it's just the driver, and you can
> download it from the site seperately.
>
> The output from ant:
>
> driver:
>      [copy] Copying 1 file to
> /root/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql
>      [echo] Configured build for the JDBC3 edition driver with NO SSL
>
> compile:
>     [javac] Compiling 77 source files to
> /root/postgresql-7.4.1/src/interfaces/jdbc/build
>     [javac]
> /root/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3Statement.java:28: error: Invalid checked
exceptionclass `java.sql.SQLException' in `throws' clause. The exception must be a subclass of an exception thrown by
`org.postgresql.jdbc1.AbstractJdbc1Statement.createRefCursorResultSet(java.lang.String)'from class
`org.postgresql.jdbc1.AbstractJdbc1Statement'.
>     [javac]             public PGRefCursorResultSet
> createRefCursorResultSet (String cursorName) throws SQLException

Most probably, your RHE3 box has an older version of the driver in its
CLASSPATH that is interfering with the build (the compiler is finding an
old version of some classes and using those rather than compiling the
current version from source).

-O