Re: setFetchSize() bug? - Mailing list pgsql-jdbc

From Kim Ho
Subject Re: setFetchSize() bug?
Date
Msg-id 1060094505.4892.63.camel@yay
Whole thread Raw
In response to Re: setFetchSize() bug?  (Fernando Nasser <fnasser@redhat.com>)
List 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
wonderingif it's a bug, probably it is. I just found that if you don't use server-side preparedstatements, the
followingexception 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)
> >
> >
>


pgsql-jdbc by date:

Previous
From: Felipe Schnack
Date:
Subject: Re: setFetchSize() bug?
Next
From: Fernando Nasser
Date:
Subject: Re: setFetchSize() bug?