To me, there seems to be quite a bit wrong with this note. I've been able to figure out some of it, but I'm still stuck.
1. The note requires you to execute 'INSERT' SQL statements to add config lines to the virsa_cc_config table. The trouble is, the note doesn't include the table columns in the insert statement, so it fails.
The INSERT statement should read:
INSERT INTO virsa_cc_config (CNFGPARAM, CNFGSEQ, CNFGVALUE, COMMENT) VALUES etc...
2. CNFGPARAM is a VARCHAR not an INT.
Quotes have to be inserted around the values for the field.. ie
VALUES ('105', 0, 'http', 'J2EE Engine Protocol')
My current issue:
When I go to execute the query, I get an error saying:
ERROR: "INSERT" statements cannot be executed by method "executeQuery()"
So, how do you execute these SQL statements using BgJobStart?debug=1 as per the note?