Re: setFetchSize() bug?

That's not the problem, I'm already with autocommit set to false... the problem is elsewhere. I believe it's on server side prepared statements (or the lack of it) use.

On 04 Aug 2003 15:24:26 -0400
Kim Ho <kho(at)redhat(dot)com> wrote:

> Hi,
>
> You might want to do a
> con.setAutoCommit(false);
> to force it to use cursors.
>
>
> As you put it, the driver is probably not using server side prepared
> statements or cursors.
>
> Cheers,
>
> Kim
>
> On Mon, 2003-08-04 at 11:18, Felipe Schnack wrote:
> > I just found something about the way setFetchSize() is implemented in current CVS version of the driver, I'm wondering if it's a bug, probably it is. I just found that if you don't use server-side preparedstatements, the following exception is thrown (I sent this same exception earlier today). This is a bug? I can't understand it very well.... seems to me that the driver uses the statement's name as the cursor name??
> >
> > java.sql.SQLException: ERROR: parser: parse error at or near "null" at character 23
> > at org.postgresql.core.QueryExecutor.executeV2(QueryExecutor.java:286)
> > at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:104)
> > at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:66)
> > at org.postgresql.jdbc1.AbstractJdbc1ResultSet.next(AbstractJdbc1ResultSet.java:135)
> > at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:135)
> --
> Kim Ho <kho(at)redhat(dot)com>
>

--

/~\ The ASCII Felipe Schnack (felipes(at)ritterdosreis(dot)br)
\ / Ribbon Campaign Analista de Sistemas
X Against HTML Cel.: 51-91287530
/ \ Email! Linux Counter #281893

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter(at)ritterdosreis(dot)br
Fone: 51-32303341