Re: JDBC, Informix and commit

jae You can commit across a cursor's resultset using hold cursors. So what you need to do is to open a cursor with HOLD. Dont know if hold cursors are supported by the Informix (or other) JDBC driver, though. HTH Sujit jpark2317@my-deja.com on 08/12/99 11:46:24 AM Please respond to jpark2317@my-deja.com To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: JDBC, Informix and commit Has anyone ever seen this before? This is the first time i am using informix, but not the first time i am using JDBC/Java. I have a result set from a select query. Depending on the data in that row, i want to update another table. I want to commit every 100 rows. So, what happens is after i do the commit, I get an sql exception saying that the cursor is closed and i cannot process the rest of my data. if i wait and commit at the end (after i'm done with the result set), everything is fine. But, if there are many rows, memory usage can be a problem. Has anyone seen this and gotten around it? any help is much appreciated. jae park Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.