I'm trying to update a table using xsjs using the following code:
var query = 'UPDATE "ABC"."TABLENAME" SET SOMEFIELD = ?';var pstmt = conn.prepareStatement(query);pstmt.setString(1, 'test');pstmt.executeUpdate();conn.commit();
This unfortunately doesn't work.
I've tried to debug this, and when executing line 4 it crashes.
- Is there an obvisous mistake?
- In the debugger view where can I see what's going wrong? Debugging without error messages is not so helpfull...
FYI: When I do a INSERT instead of an UPDATE it works fine.
Thanks a lot for any help!