Hi there.

I get :
org.firebirdsql.jdbc.FBSQLException: GDS Exception. Dynamic SQL Error
SQL error code = -504
Cursor unknown
at org.firebirdsql.jdbc.FBStatementFetcher.fetch(FBStatementFetcher
java:119)
at org.firebirdsql.jdbc.FBStatementFetcher.next(FBStatementFetcher.java:84)
at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:173)
at sid.modelManager.ModelManager.copyKmp(ModelManager.java:355)
at sid.modelManager.ModelManager.copyMba(ModelManager.java:339)
at sid.modelManager.ModelManager.copyPlant(ModelManager.java:308)
at sid.modelManager.ModelManager$2.actionPerformed(ModelManager.java:64)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764)
at javax.swing.AbstractButton$ForwardActionEvents
actionPerformed(AbstractButton.java:1817)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
java:419)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257)
at javax.swing.plaf.basic.BasicButtonListener
mouseReleased(BasicButtonListener.java:245)
at java.awt.Component.processMouseEvent(Component.java:5093)
at java.awt.Component.processEvent(Component.java:4890)
at java.awt.Container.processEvent(Container.java:1566)
at java.awt.Component.dispatchEventImpl(Component.java:3598)
at java.awt.Container.dispatchEventImpl(Container.java:1623)
at java.awt.Component.dispatchEvent(Component.java:3439)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)
at java.awt.Container.dispatchEventImpl(Container.java:1609)
at java.awt.Window.dispatchEventImpl(Window.java:1585)
at java.awt.Component.dispatchEvent(Component.java:3439)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread
java:197)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread
java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:99)
at org.firebirdsql.gds.GDSException: Dynamic SQL Error

here's the code :


Statement st = ...;
...
ResultSet rs = st.executeQuery("Select id_mba from t_mba where id_plant = "
+ id_plant);
while(rs.next()){
copyMba(rs.getInt("id_mba"),newId);
}
(mess up with variables)...
st.execute("Insert into t_plant select " +newId+ ",'"+newName+"',DELETED,'"+
getNewMap() +"' from t_plant where id_plant = "+ id_plant);
...
(if everything's fine ) ... con.commit();
the same is done for the child in the function copyMba, which calls the
function for its "child table" for a maximum depth of 5 starting from the
top. I commit in the main function (call rollback if I get an exception).
I get the exception at depth 4 . In the resultset there should be 3 rows.
The exception is thrown on rs.next() on the last row.
Any help would be appreciated.