How to use the UPDATE statement ... SET of SCIDB 15.12 in JAVA through the JDBDC API?


#1

stmt.executeQuery(“UPDATE m4x4 SET val=-pow(val,-1) WHERE abs(val) > 5”);

Error id: scidb::SCIDB_SE_PARSER::SCIDB_LE_QUERY_PARSING_ERROR
Error description: Error during query parsing. Query parser failed with error ‘syntax error’.
UPDATE m4x4 SET val=-pow(val,-1) WHERE abs(val) > 5


#2

Hi, you should be able to call setAfl(false) on the Connection object used to create stmt. That should get you into AQL mode, where your UPDATE statement will be good.

Sorry for the delayed response!