Autocommit setting for zxJDBC in FDMEE 11.2.8 differs from that of 11.2.3

Hello All! We have recently deployed EPM 11.2.8 in a new distributed environment and set up all the artifacts and data in the new environment. For FDMEE, we migrated all the artifacts through LCM. We are running the custom scripts and validating the results against the old 11.2.3 environment. We find huge differences in the results that are due to the missing mappings, etc. in the new envt.

The actual issue we are facing is that the SQL statements that we execute through the Jython scripts get auto committed in 11.2.3 like a sql variable holding a truncate and an insert statement like the below doesn't truncate the table really. New records get inserted to the table with the existing records intact.