How to manipulate a CachedRowSet?

Hello to all:

I've encountered a tough problem with CachedRowSet. I need to construct a dynamic CacheRowSet reusable later without updating his data Source:

I've tried moveToInsertRow(); and insertRow to add a new line but it seems to me that my new rowset can not be read when I do "rs.next()" who threw an exception like: Invalid cursor position.

Anyone has a successful experience? Thanks!!!!

Waiting online!!!!

[449 byte] By [lezhanga] at [2007-11-27 11:34:18]
# 1

Can you post your code?

You should only be using rs.next() when you need to read the data in the table. You're receiving that exception because you've past the end of the cachedrowset. Try executing rs.beforeFirst(); and then rs.next().

bce_developera at 2007-7-29 16:56:29 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...