Re: setFetchSize() bug?

From: Kim Ho <kho(at)redhat(dot)com>
To: Fernando Nasser <fnasser(at)redhat(dot)com>
Cc: Felipe Schnack <felipes(at)ritterdosreis(dot)br>, pgsql-jdbc-list <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: setFetchSize() bug?
Date: 2003-08-05 14:41:45
Message-ID: 1060094505.4892.63.camel@yay
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I am fairly sure it is because the query is not sent as a server side
prepared statement OR as a cursor.

Therefore, the statement name is not set.

That being said, I would like to see an example of the code that
produces the error (in case it differs from the way that I'm reproducing
the error).

Cheers,

Kim

On Tue, 2003-08-05 at 10:21, Fernando Nasser wrote:
> There isn't enough information to debug this in the stack trace. This
> code seems fine and is there for some time already.
>
> Do you have a small example that could be used to reproduce the problem?
> It would make it easier for us to track it down.
>
> Regards,
> Fernando
>
> 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)
> >
> >
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Fernando Nasser 2003-08-05 14:42:06 Re: setFetchSize() bug?
Previous Message Felipe Schnack 2003-08-05 14:25:31 Re: setFetchSize() bug?