Thread: 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
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.)
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, Pennsylvania19026
> 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 2324824Kö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
> ... 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 2324824Kö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
> > 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, Pennsylvania19026
<p><font size="2">The release postgresql-jdbc-7.1.2-4PGDG.i386.rpm is definately buggy. Or at least there has been a confusionwith versioning. I have a had a number of small issues, but when I downloaded the source and compiled the JDBC driversthrough ANT they worked fine.</font><p><font size="2">addBatch() and executeBatch() should work also in the RPM butthey throw "method not yet implemented errors"...</font><p><font size="2">jon folland</font><p><font size="2">head oftechnology</font><br /><font size="2">_ tripledash /</font><p><font size="2">phone +44 020 7377 07 75</font><br /><fontsize="2">fax +44 020 7247 69 30</font><br /><font size="2">mobile +44 07974 324 260</font><p><font size="2">www.tripledash.co.uk</font><br /><br /><p><font size="2">-----Original Message-----</font><br /><font size="2">From:Bruce Momjian [<a href="mailto:pgman@candle.pha.pa.us">mailto:pgman@candle.pha.pa.us</a>]</font><br /><fontsize="2">Sent: 10 July 2001 22:21</font><br /><font size="2">To: Rainer Klute</font><br /><font size="2">Cc: MarianoKamp; pgsql-hackers@postgresql.org</font><br /><font size="2">Subject: Re: [HACKERS] JDBC Support - prepared Statements?</font><br/><p><font size="2">> > yes I did so. The name of the rpm I recently downloaded is: </font><br/><font size="2">> > postgresql-jdbc-7.1.2-4PGDG.i386.rpm and it is throwing the exception when</font><br/><font size="2">> > calling the prepareStatement() Method.</font><br /><font size="2">> </font><br/><font size="2">> Hm, I build everything from source. Perhaps the RPM is buggy.</font><p><font size="2">I wouldget the JAR from:</font><p> <font size="2"><a href="http://jdbc.fastcrypt.com">http://jdbc.fastcrypt.com</a></font><p><fontsize="2">This is a copy of the CVS tree, whichhas some bugs fixed from 7.1.2.</font><p><font size="2">-- </font><br /><font size="2"> Bruce Momjian | <a href="http://candle.pha.pa.us">http://candle.pha.pa.us</a></font><br /><font size="2"> pgman@candle.pha.pa.us | (610) 853-3000</font><br /><font size="2"> + If your life is a hard drive, | 830 Blythe Avenue</font><br /><font size="2"> + Christ can be your backup. | Drexel Hill, Pennsylvania19026</font><p><font size="2">---------------------------(end of broadcast)---------------------------</font><br/><font size="2">TIP 6: Have you searched our list archives?</font><p><fontsize="2"><a href="http://www.postgresql.org/search.mpl">http://www.postgresql.org/search.mpl</a></font>