Re: Callablestatement's resulting resultset not scrollable

Thanks a lot, Kris.

For clarification, is this then a JDBC patch work that need to be done to
enable scrollability feature in the ResultSet via CallableStatement?

Domo arigato!

ron

On 8/1/06, Kris Jurka <jurka(at)ejurka(dot)com> wrote:
>
> ron wrote:
>
> > My PostgreSQL server is version 8.0 and I'm using
> > postgresql-8.2dev-503.jdbc3.jar for my JDBC type 3 driver. I am
> > wondering how come I always get a TYPE_FORWARD_ONLY type of resultset
> > out of my callablestatement as shown below despite having given the
> > necessary parameters to my prepareCall method in order to obtain a
> > scrollable resultset. A SQLException errors occurs once I attempt to
> > move the resultset pointer with qRs.last() owing to the resulting
> > TYPE_FORWARD_ONLY resultset. How do I correct this?
> >
> > con.setAutoCommit(false);
> > String sSQLCall = "{? = call
> > \"DEMO\".fn_ins_update_employee_rec(?,?,?,?,?,?,?)}";
> > cs =
> > con.prepareCall(sSQLCall,ResultSet.TYPE_SCROLL_INSENSITIVE,
> > ResultSet.CONCUR_UPDATABLE);
> > cs.registerOutParameter(1, Types.OTHER);
> > cs.execute();
> > this.qRs = (ResultSet) cs.getObject(1);
> > qRs.last();
> >
>
> You've sent this to the list owner address, please send all non list
> administration questions to pgsql-jdbc(at)postgresql(dot)org(dot)
>
> It wouldn't be hard to allow scrolling, we just need to get that
> scrolling flag to the ResultSet. Allowing updates is not going to
> happen without some significant work. The backend would need to support
> updatable cursors because the driver has no idea what the cursor is
> actually accessing so it cannot issue updates as it does for regular
> ResultSets.
>
> I'm travelling at the moment, but will be back home next week and will
> hopefully look at this and all the other pending JDBC patches/issues.
>
> Kris Jurka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
R. Agustin
- - - - - - - - - - - - - - - - - - - - - - - - - -
E-mail: bragustin(at)gmail(dot)com
ICQ #: 146807041
_______________________________________
This email contains confidential information for the sole use of the
intended
recipient/s. If you are not the intended recipient, please contact
the sender, delete this email and maintain the confidentiality of what
you may have read.

"It is a capital mistake to theorize before one has data."
- Sherlock Holmes