Hi there,

  we are developing reporting software and want to support at least one open 
source alternative to oracle. Things were going very smoothly with postgresql 
and the only problem we are facing is the I get an exception stating that 
with the current jdbc driver prepared statements are not supported (yet). Are 
there any plans, probably even kind of time frames, when to support prepared 
statements? 

  Even if postgresql wouldn't support preparing the statement it would be 
nice if it would at least fake it, so that the API can be used. We are 
relying on a third party component, which just can do prepared statements.

Thanks,
Mariano

Tue, 3 Jul 2001 09:06:05 +0200
Mariano Kamp <mkamp@codamax.com>
JDBC Support - prepared Statements?
> ... and the only problem we are facing is the I get an exception stating
that 
> with the current jdbc driver prepared statements are not supported (yet).

Did you try the latest 7.1.2 release? I did so recently and did not
encounter any problems with PreparedStatements. (There are still other bugs in the
JDBC driver, but that's another story.)

-- 
Best regards
Rainer Klute

  Dipl.-Inform.                     E-Mail: rainer.klute@epost.de
  Rainer Klute                        Tel.: +49 172 2324824
  Kï¿½rner Grund 24                      Fax: +49 231 511809
D-44143 Dortmund

GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net

GMX Tipp:

Machen Sie Ihr Hobby zu Geld bei unserem Partner 1&1!
http://profiseller.de/info/index.php3?ac=OM.PS.PS003K00596T0409a


Tue, 3 Jul 2001 10:02:31 +0200 (MEST)
Rainer Klute <rainer.klute@gmx.de>
Re: JDBC Support - prepared Statements?
Hello Rainer,

  yes I did so. The name of the rpm I recently downloaded is: 
postgresql-jdbc-7.1.2-4PGDG.i386.rpm and it is throwing the exception when 
calling the prepareStatement() Method.
  
  But when I get back some air to breathe I will go and double-double-check 
that my classpath is setup properly ;-) 

Mariano




On Tuesday 03 July 2001 10:02 am, Rainer Klute wrote:
> > ... and the only problem we are facing is the I get an exception stating
>
> that
>
> > with the current jdbc driver prepared statements are not supported (yet).
>
> Did you try the latest 7.1.2 release? I did so recently and did not
> encounter any problems with PreparedStatements. (There are still other bugs
> in the JDBC driver, but that's another story.)

Tue, 3 Jul 2001 10:34:07 +0200
Mariano Kamp <mkamp@codamax.com>
Re: JDBC Support - prepared Statements?
>   yes I did so. The name of the rpm I recently downloaded is: 
> postgresql-jdbc-7.1.2-4PGDG.i386.rpm and it is throwing the exception when
> calling the prepareStatement() Method.

Hm, I build everything from source. Perhaps the RPM is buggy.

-- 
Best regards
Rainer Klute

  Dipl.-Inform.                     E-Mail: rainer.klute@epost.de
  Rainer Klute                        Tel.: +49 172 2324824
  Kï¿½rner Grund 24                      Fax: +49 231 511809
D-44143 Dortmund

GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net

GMX Tipp:

Machen Sie Ihr Hobby zu Geld bei unserem Partner 1&1!
http://profiseller.de/info/index.php3?ac=OM.PS.PS003K00596T0409a


Tue, 3 Jul 2001 12:25:31 +0200 (MEST)
Rainer Klute <rainer.klute@gmx.de>
Re: JDBC Support - prepared Statements?
Mariano,

The JDBC driver does support PreparedStatements and has for a while. 
Can you provide more information and preferably a code example showing 
the problem you are seeing?

thanks,
--Barry

Mariano Kamp wrote:

> Hi there,
> 
>   we are developing reporting software and want to support at least one open 
> source alternative to oracle. Things were going very smoothly with postgresql 
> and the only problem we are facing is the I get an exception stating that 
> with the current jdbc driver prepared statements are not supported (yet). Are 
> there any plans, probably even kind of time frames, when to support prepared 
> statements? 
> 
>   Even if postgresql wouldn't support preparing the statement it would be 
> nice if it would at least fake it, so that the API can be used. We are 
> relying on a third party component, which just can do prepared statements.
> 
> Thanks,
> Mariano
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 
> 



Tue, 03 Jul 2001 08:04:48 -0700
Barry Lind <barry@xythos.com>
Re: [HACKERS] JDBC Support - prepared Statements?
I would get the newest Jdbc from:

	http://jdbc.fastcrypt.com

It has more bug fixes than 7.1.X.

> Hello Rainer,
> 
>   yes I did so. The name of the rpm I recently downloaded is: 
> postgresql-jdbc-7.1.2-4PGDG.i386.rpm and it is throwing the exception when 
> calling the prepareStatement() Method.
>   
>   But when I get back some air to breathe I will go and double-double-check 
> that my classpath is setup properly ;-) 
> 
> Mariano
> 
> 
> 
> 
> On Tuesday 03 July 2001 10:02 am, Rainer Klute wrote:
> > > ... and the only problem we are facing is the I get an exception stating
> >
> > that
> >
> > > with the current jdbc driver prepared statements are not supported (yet).
> >
> > Did you try the latest 7.1.2 release? I did so recently and did not
> > encounter any problems with PreparedStatements. (There are still other bugs
> > in the JDBC driver, but that's another story.)
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 3 Jul 2001 12:41:01 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: JDBC Support - prepared Statements?
> >   yes I did so. The name of the rpm I recently downloaded is: 
> > postgresql-jdbc-7.1.2-4PGDG.i386.rpm and it is throwing the exception when
> > calling the prepareStatement() Method.
> 
> Hm, I build everything from source. Perhaps the RPM is buggy.

I would get the JAR from:

	http://jdbc.fastcrypt.com

This is a copy of the CVS tree, which has some bugs fixed from 7.1.2.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 10 Jul 2001 17:21:01 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: JDBC Support - prepared Statements?
The release postgresql-jdbc-7.1.2-4PGDG.i386.rpm  is definately buggy. Or at
least there has been a confusion with versioning. I have a had a number of
small issues, but when I downloaded the source and compiled the JDBC drivers
through ANT they worked fine.

addBatch() and executeBatch() should work also in the RPM but they throw
"method not yet implemented errors"...

jon folland

head of technology
_ tripledash /

phone	 +44 020 7377 07 75
fax  	 +44 020 7247 69 30
mobile	 +44 07974 324 260

www.tripledash.co.uk



-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: 10 July 2001 22:21
To: Rainer Klute
Cc: Mariano Kamp; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] JDBC Support - prepared Statements?


> >   yes I did so. The name of the rpm I recently downloaded is:
> > postgresql-jdbc-7.1.2-4PGDG.i386.rpm and it is throwing the exception
when
> > calling the prepareStatement() Method.
>
> Hm, I build everything from source. Perhaps the RPM is buggy.

I would get the JAR from:

	http://jdbc.fastcrypt.com

This is a copy of the CVS tree, which has some bugs fixed from 7.1.2.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

http://www.postgresql.org/search.mpl





RE: [HACKERS] JDBC Support - prepared Statements?



The release postgresql-jdbc-7.1.2-4PGDG.i386.rpm  is definately buggy. Or at least there has been a confusion with versioning. I have a had a number of small issues, but when I downloaded the source and compiled the JDBC drivers through ANT they worked fine.
addBatch() and executeBatch() should work also in the RPM but they throw "method not yet implemented errors"...

jon folland

head of technology
_ tripledash /

phone    +44 020 7377 07 75
fax      +44 020 7247 69 30
mobile   +44 07974 324 260

www.tripledash.co.uk 



-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: 10 July 2001 22:21
To: Rainer Klute
Cc: Mariano Kamp; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] JDBC Support - prepared Statements?


> >   yes I did so. The name of the rpm I recently downloaded is: 
> > postgresql-jdbc-7.1.2-4PGDG.i386.rpm and it is throwing the exception when
> > calling the prepareStatement() Method.
> 
> Hm, I build everything from source. Perhaps the RPM is buggy.

I would get the JAR from:

        http://jdbc.fastcrypt.com

This is a copy of the CVS tree, which has some bugs fixed from 7.1.2.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

http://www.postgresql.org/search.mpl
Wed, 11 Jul 2001 11:42:24 +0100
"Jon Folland" <jon@hot-computers.com>
RE: JDBC Support - prepared Statements?