Thread: compiling pg 7.4 and jdbc

compiling pg 7.4 and jdbc

From
pginfo
Date:
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


How can I solve this problem?

regards,
ivan.


Re: compiling pg 7.4 and jdbc

From
Dave Cramer
Date:
My guess is that you still have an old jar in the classpath.

Dave
On Fri, 2003-12-05 at 00:49, pginfo wrote:
> 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
>
>
> How can I solve this problem?
>
> regards,
> ivan.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>


Re: compiling pg 7.4 and jdbc

From
pginfo
Date:
Hi,
I think no.
I send my classpath:
CLASSPATH=.:/j2sdk1.4.2_01/jre/lib/rt.jar

regards,
ivan.

Dave Cramer wrote:

> My guess is that you still have an old jar in the classpath.
>
> Dave
> On Fri, 2003-12-05 at 00:49, pginfo wrote:
> > 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
> >
> >
> > How can I solve this problem?
> >
> > regards,
> > ivan.
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
> >




Re: compiling pg 7.4 and jdbc

From
Dave Cramer
Date:
Well, then until someone else comes up with a solution, I'd suggest
downloading the jars from the site.

Dave
On Fri, 2003-12-05 at 08:30, pginfo wrote:
> Hi,
> I think no.
> I send my classpath:
> CLASSPATH=.:/j2sdk1.4.2_01/jre/lib/rt.jar
>
> regards,
> ivan.
>
> Dave Cramer wrote:
>
> > My guess is that you still have an old jar in the classpath.
> >
> > Dave
> > On Fri, 2003-12-05 at 00:49, pginfo wrote:
> > > 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
> > >
> > >
> > > How can I solve this problem?
> > >
> > > regards,
> > > ivan.
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> > >
> > >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>


Re: compiling pg 7.4 and jdbc

From
pginfo
Date:
Hm,
ok but this drivers are quit old :).
I see only dev-driver for 7.4 from 09.2003.
I do not know how stable is this and how full.
I can not use thle 7.3 jdbc because it have commit (discused here) problem.

regards,
ivan.

Dave Cramer wrote:

> Well, then until someone else comes up with a solution, I'd suggest
> downloading the jars from the site.
>
> Dave
> On Fri, 2003-12-05 at 08:30, pginfo wrote:
> > Hi,
> > I think no.
> > I send my classpath:
> > CLASSPATH=.:/j2sdk1.4.2_01/jre/lib/rt.jar
> >
> > regards,
> > ivan.
> >
> > Dave Cramer wrote:
> >
> > > My guess is that you still have an old jar in the classpath.
> > >
> > > Dave
> > > On Fri, 2003-12-05 at 00:49, pginfo wrote:
> > > > 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
> > > >
> > > >
> > > > How can I solve this problem?
> > > >
> > > > regards,
> > > > ivan.
> > > >
> > > >
> > > > ---------------------------(end of broadcast)---------------------------
> > > > TIP 4: Don't 'kill -9' the postmaster
> > > >
> > > >
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >
> >




Re: compiling pg 7.4 and jdbc

From
pginfo
Date:
Dave,
thanks!

It will be great if possible.
regards,
ivan.

Dave Cramer wrote:

> I can build you one and email it to you?
>
> dave
>
> On Fri, 2003-12-05 at 08:55, pginfo wrote:
> > Hm,
> > ok but this drivers are quit old :).
> > I see only dev-driver for 7.4 from 09.2003.
> > I do not know how stable is this and how full.
> > I can not use thle 7.3 jdbc because it have commit (discused here) problem.
> >
> > regards,
> > ivan.
> >
> > Dave Cramer wrote:
> >
> > > Well, then until someone else comes up with a solution, I'd suggest
> > > downloading the jars from the site.
> > >
> > > Dave
> > > On Fri, 2003-12-05 at 08:30, pginfo wrote:
> > > > Hi,
> > > > I think no.
> > > > I send my classpath:
> > > > CLASSPATH=.:/j2sdk1.4.2_01/jre/lib/rt.jar
> > > >
> > > > regards,
> > > > ivan.
> > > >
> > > > Dave Cramer wrote:
> > > >
> > > > > My guess is that you still have an old jar in the classpath.
> > > > >
> > > > > Dave
> > > > > On Fri, 2003-12-05 at 00:49, pginfo wrote:
> > > > > > 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
> > > > > >
> > > > > >
> > > > > > How can I solve this problem?
> > > > > >
> > > > > > regards,
> > > > > > ivan.
> > > > > >
> > > > > >
> > > > > > ---------------------------(end of broadcast)---------------------------
> > > > > > TIP 4: Don't 'kill -9' the postmaster
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ---------------------------(end of broadcast)---------------------------
> > > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> > > >
> > > >
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
> >