JDBC Support - prepared Statements?
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
... 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
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
Show quoted text
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.)
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
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:
Show quoted text
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?
I would get the newest Jdbc from:
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 19026yes 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:
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
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:
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?