X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 83A1AD1DCAD for ; Tue, 30 Mar 2004 18:09:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95374-07 for ; Tue, 30 Mar 2004 14:09:09 -0400 (AST) Received: from ms20.pchome.com.tw (ms20.pchome.com.tw [211.20.188.145]) by svr1.postgresql.org (Postfix) with ESMTP id 43FADD1BAEA for ; Tue, 30 Mar 2004 14:08:49 -0400 (AST) Received: from pchome.com.tw (218-166-140-114.HINET-IP.hinet.net [218.166.140.114]) by ms20.pchome.com.tw (Tomail v3 Lilith) with ESMTP id 19C4C3E85F6 for ; Wed, 31 Mar 2004 01:21:37 +0800 (CST) Message-ID: <4069AE31.1000208@pchome.com.tw> Date: Wed, 31 Mar 2004 01:28:17 +0800 From: yihuey User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030922 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: Compiler 7.4 with--java Error on Redhad AS 2.4.21 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/11 X-Sequence-Number: 4832 Hello: I have the same question and environment.My Server never install old version postgreSQL. Pls tell me how to solve. Hi, I am using linux redhat 3.0 and sun jsdk 1.4.2. I try to compile pg 7.4 --with-java to be able to get the new jdbc driver. After calling gmake I get this error: gmake[3]: Leaving directory `/pginst/postgresql-7.4/src/interfaces/ecpg' gmake[3]: Entering directory `/pginst/postgresql-7.4/src/interfaces/jdbc' /usr/bin/ant -buildfile ./build.xml all Buildfile: ./build.xml all: prepare: check_versions: check_driver: driver: [copy] Copying 1 file to /pginst/postgresql-7.4/src/interfaces/jdbc/org/postgresql [echo] Configured build for the JDBC3 edition driver with NO SSL compile: [javac] Compiling 77 source files to /pginst/postgresql-7.4/src/interfaces/jdbc/build [javac] /pginst/postgresql-7.4/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3Statement.java:28: error: Invalid checked exception class `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] /pginst/postgresql-7.4/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3PreparedStatement.java:23: error: Invalid checked exception class `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] /pginst/postgresql-7.4/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] /pginst/postgresql-7.4/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3CallableStatement.java:23: error: Invalid checked exception class `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:/pginst/postgresql-7.4/src/interfaces/jdbc/build.xml:116: Compile failed; see the compiler error output for details. Total time: 2 seconds gmake[3]: *** [all] Error 1 gmake[3]: Leaving directory `/pginst/postgresql-7.4/src/interfaces/jdbc' gmake[2]: *** [all] Error 2 gmake[2]: Leaving directory `/pginst/postgresql-7.4/src/interfaces' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/pginst/postgresql-7.4/src' gmake: *** [all] Error 2 ========================================================== 超級IT輕鬆做 極秘技 http://edm-prg.epaper.com.tw/click.php?ad_code=86358 ========================================================== PChome交友~~幸福天天有 \*^o^*// http://love.pchome.com.tw/ ==========================================================