Hi all, when I do an update with the Database Connector app, the first update is working correctly. If I do a second update on the same record (the user is changing the record for the second time on the screen), I get an error: com.mendix.core.CoreException: com.mendix.modules.microflowengine.MicroflowException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.lang.RuntimeException: java.sql.SQLException: Operation not permit on a closed resultset at MyFirstModule.ACT_UpdateDatabase (JavaAction : 'Execute query') What am I doing wrong???? Regards, Peter
Based on this SO question, it would seem the SQL Connector isn't closing the ResultSet you obtained with the first query. However, based on my review of the database connector code, the ResultSet is handled properly in a try-with-resources statement. So, apologies that this isn't really an answer but I'm hoping someone can use this info in researching their answer.