Re: ResultSet-Session

Just an extra side not while i'm at it.

When I attempt to replace the following line

ps = conn.prepareStatement("SELECT ename, rowid FROM emp WHERE rowid > ?");

with

ps = conn.prepareStatement("SELECT ename, rowid FROM emp WHERE rowid > ? FOR UPDATE");

My servlet returns a "ORA-01002 Fetch out of sequence" error. Basically I'm trying to lock the records until my select is finished. Any ideas?

Regards,

Robert

Reply via email to