Skip site navigation (1) Skip section navigation (2)

Re: Prepare Statement

From: Kris Jurka <books(at)ejurka(dot)com>
To: Jie Liang <jie(at)stbernard(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org,pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Prepare Statement
Date: 2004-06-17 04:30:03
Message-ID: Pine.BSO.4.56.0406162324530.27722@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-sql

On Wed, 16 Jun 2004, Jie Liang wrote:

> Kris,
> Thank you for your valuable response, I used the code you list
> following:
>
> [7.5 code example]
>
> Then, the compiler complaint:
> ServerSidePreparedStatement.java:20: cannot resolve symbol symbol  :
> method setPrepareThreshold  (int)
> location: interface org.postgresql.PGStatement
>                 pgstmt.setPrepareThreshold(3); I downloaded
> pg74.213.jdbc2.jar and pg74.213.jdbc2ee.jar at

This example is from the 7.5 documentation and requires a
pgdev.302.jdbcX.jar file.  I mentioned this cvs example because this 
functionality is undocumented in the released version.  In the 7.4 version 
the enabling of server side statements is only possible via a boolean flag 
at the statement level, namely PGStatement.setUseServerPrepare(true);

Kris Jurka

In response to

pgsql-sql by date

Next:From: Hannes KorteDate: 2004-06-17 11:01:08
Subject: use of a composite type in CREATE TABLE?
Previous:From: Greg Sabino MullaneDate: 2004-06-17 03:03:31
Subject: Re: Is there a faster way to do this?

pgsql-jdbc by date

Next:From: Amit HandaDate: 2004-06-17 04:54:48
Subject: Re: Support for JDK 1.5 RowSets
Previous:From: Bruce MomjianDate: 2004-06-17 02:04:20
Subject: Re: Nested transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group