| Subject | Re: [Firebird-Java] Problem with ResultSet.HOLD_CURSORS_OVER_COMMIT and jaybird 2.1.1 |
|---|---|
| Author | Aljoscha Rittner |
| Post date | 2007-11-22T16:59:57Z |
Ok, I found *my* bug ;-)
The right way:
PreparedStatement prp = con.prepareStatement (dbo.getStatement (),
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY,
ResultSet.HOLD_CURSORS_OVER_COMMIT);
Thank you for your audience.
best regards,
josh.
> PreparedStatement prp =This is absolute wrong.
> conAC.prepareStatement (dbo.getStatement (),
> ResultSet.FETCH_FORWARD,
> ResultSet.TYPE_SCROLL_INSENSITIVE,
> ResultSet.HOLD_CURSORS_OVER_COMMIT);
The right way:
PreparedStatement prp = con.prepareStatement (dbo.getStatement (),
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY,
ResultSet.HOLD_CURSORS_OVER_COMMIT);
Thank you for your audience.
best regards,
josh.