Re: compile of jdbc driver failed

hi again,

I retried compiling the jdbc driver with jdk1.3 and it worked. I even found
the messages in this mailing list that refer to this incmpability problem.

Does someone know if there is already a patch (or unstable version etc.) of
the driver for jdk1.4?

cheers
Chantal

There was an earlier post about this. The driver works fine with the
1.4.0 JRE, but it does need to be compiled with 1.3.1 due to the fact
that the ANT build.xml file hasn't been update to reflect the 1.4.0 JDK
as of 7.2.0. In brief, the script mistakenly identifies 1.4.0 J2SE as a
J2EE variant. You can easily "kludge" this by changing line 34 in the
build.xml file to read:

...
<available property="jdk1.2e+" classname="javax.sql.DataSourceX" />
...

This will prevent ANT from mistaking J2SE for J2EE since
javax.sql.DataSourceX doesn't exist in J2SE (or J2EE obviously). You can
then just run make from the command line. However, if you already have
compiled using 1.3.1, it makes no difference, and can just use that
version with the 1.4.0 JRE.

Cheers,

Marc

Chantal Ackermann wrote:

> hi again,
>
> I retried compiling the jdbc driver with jdk1.3 and it worked. I even found
> the messages in this mailing list that refer to this incmpability problem.
>
> Does someone know if there is already a patch (or unstable version etc.) of
> the driver for jdk1.4?
>
> cheers
> Chantal
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>

Ok, I reworked build.xml to be "smarter" hopefully it is. The upshot is
that you can compile the driver under jdk1.4

Please report any problems to me. I have tested it under jdk1.1, 1.2,
1.3, 1.4 and it built for me, but...

Dave

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Marc Lavergne
Sent: Thursday, February 21, 2002 2:20 PM
To: chantal(dot)ackermann(at)web(dot)de
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] compile of jdbc driver failed

There was an earlier post about this. The driver works fine with the
1.4.0 JRE, but it does need to be compiled with 1.3.1 due to the fact
that the ANT build.xml file hasn't been update to reflect the 1.4.0 JDK
as of 7.2.0. In brief, the script mistakenly identifies 1.4.0 J2SE as a
J2EE variant. You can easily "kludge" this by changing line 34 in the
build.xml file to read:

...
<available property="jdk1.2e+" classname="javax.sql.DataSourceX" />
...

This will prevent ANT from mistaking J2SE for J2EE since
javax.sql.DataSourceX doesn't exist in J2SE (or J2EE obviously). You can

then just run make from the command line. However, if you already have
compiled using 1.3.1, it makes no difference, and can just use that
version with the 1.4.0 JRE.

Cheers,

Marc

Chantal Ackermann wrote:

> hi again,
>
> I retried compiling the jdbc driver with jdk1.3 and it worked. I even
> found
> the messages in this mailing list that refer to this incmpability
problem.
>
> Does someone know if there is already a patch (or unstable version
> etc.) of
> the driver for jdk1.4?
>
> cheers
> Chantal
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

Thank you Marc, for your detailed answer, and thank you Dave the change. As I
have already compiled the driver with 1.3, I will stick with it (as it makes
no difference which jdk to use for compilation).

oh - and thank you all involved for this fine work!
Chantal

Am Freitag, 22. Februar 2002 03:09 schrieb Dave Cramer:
> Ok, I reworked build.xml to be "smarter" hopefully it is. The upshot is
> that you can compile the driver under jdk1.4
>
> Please report any problems to me. I have tested it under jdk1.1, 1.2,
> 1.3, 1.4 and it built for me, but...
>
> Dave
>
> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Marc Lavergne
> Sent: Thursday, February 21, 2002 2:20 PM
> To: chantal(dot)ackermann(at)web(dot)de
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: [JDBC] compile of jdbc driver failed
>
>
> There was an earlier post about this. The driver works fine with the
> 1.4.0 JRE, but it does need to be compiled with 1.3.1 due to the fact
> that the ANT build.xml file hasn't been update to reflect the 1.4.0 JDK
> as of 7.2.0. In brief, the script mistakenly identifies 1.4.0 J2SE as a
> J2EE variant. You can easily "kludge" this by changing line 34 in the
> build.xml file to read:
>
> ...
> <available property="jdk1.2e+" classname="javax.sql.DataSourceX" />
> ...
>
> This will prevent ANT from mistaking J2SE for J2EE since
> javax.sql.DataSourceX doesn't exist in J2SE (or J2EE obviously). You can
>
> then just run make from the command line. However, if you already have
> compiled using 1.3.1, it makes no difference, and can just use that
> version with the 1.4.0 JRE.
>
> Cheers,
>
> Marc
>
> Chantal Ackermann wrote:
> > hi again,
> >
> > I retried compiling the jdbc driver with jdk1.3 and it worked. I even
> > found
> > the messages in this mailing list that refer to this incmpability
>
> problem.
>
> > Does someone know if there is already a patch (or unstable version
> > etc.) of
> > the driver for jdk1.4?
> >
> > cheers
> > Chantal
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

I got the following from a jdbc call:
Exception: Callable Statements are not supported at this time.

this exception comes out from a third party pure java report engine, thus
the detailed information is not very much clear to me. When I was using
Oracle as database backend, this exception is not there. however, when I
change to postgres's pgjdbc2.jar JDBC driver, this exception raises. Does
that mean Postgres doesn't support stored procesure?

thanks a lot!

Henry,
postgresql do support stored procedures.
You just can´t call them with CallableStatement in the jdbc interface.
You should use Statement or PreparedStatement.
There has been discussions on this list earlier. See the archives
Also, look at http://lab.applinet.nl./postgresql-jdbc/

Regards,
Per-Olof Norén

----- Original Message -----
From: "Henry" <hxzhang(at)cs(dot)ualberta(dot)ca>
To: <pgsql-jdbc(at)postgresql(dot)org>
Sent: Friday, February 22, 2002 11:00 PM
Subject: [JDBC] set parameter not enabled?

> I got the following from a jdbc call:
> Exception: Callable Statements are not supported at this time.
>
> this exception comes out from a third party pure java report engine, thus
> the detailed information is not very much clear to me. When I was using
> Oracle as database backend, this exception is not there. however, when I
> change to postgres's pgjdbc2.jar JDBC driver, this exception raises.
Does
> that mean Postgres doesn't support stored procesure?

>
> thanks a lot!
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

Henry,

Postgres does not natively support a stored procedure the way that
others do. There is a patch in the pipe which attempts to convert a
Callable statement into a postgres "stored proc", but I'm not sure it
will work.

Dave

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Henry
Sent: Friday, February 22, 2002 5:00 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] set parameter not enabled?

I got the following from a jdbc call:
Exception: Callable Statements are not supported at this time.

this exception comes out from a third party pure java report engine,
thus the detailed information is not very much clear to me. When I was
using Oracle as database backend, this exception is not there. however,
when I change to postgres's pgjdbc2.jar JDBC driver, this exception
raises. Does that mean Postgres doesn't support stored procesure?

thanks a lot!

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org