Re: cursor "jdbc_curs_1" does not exist

From: tmp(at)nitwit(dot)de
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: cursor "jdbc_curs_1" does not exist
Date: 2004-06-17 13:43:04
Message-ID: 200406171543.04669.tmp@nitwit.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thursday 17 June 2004 15:17, you wrote:
> You probably meant:
>
> final Statement select = db.createStatement(ResultSet.TYPE_FORWARD_ONLY,
> ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);

Oops, of course :-)

> The current driver will throw an exception if you try this, as
> HOLD_CURSORS_OVER_COMMIT is not supported (actually, it throws in *all*

:-(

Is there a schedule when it will be supported?

But the following also doesn't work:

final Statement select = db.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);

So I really wonder how I should solve my problem other than calling commit()
once at the very end...

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-06-17 14:25:57 Re: cursor "jdbc_curs_1" does not exist
Previous Message Oliver Jowett 2004-06-17 13:17:03 Re: cursor "jdbc_curs_1" does not exist