Unanswered: update multiple files using one jdbc connection
I am using mysqlmax3.23.49 and mm.mysql-2.0.4 jdbc driver.
I have two mysql tables of type INNODB. lets say table A and table B.
acode is the primary key of table a. primary key of table B is acode + bcode. therefore acode is the foriegn key.
After intiating the data base connection i set auto commit false using setautocommit(false).
Then i insert a record to table B. before commiting the transaction i tried update a record in table A.
the program gives the following exception
As long as the transaction is in the same session, this shouldn't cause a problem. It seems as if the java app is starting a new session for the second update. Try the same process manually from a command prompt.