Does embedded connection manager (IDBManager) has an SQL wrapper (e.g. START TRANSACTION; COMMIT; / etc?), or do I need to write all my MySQL statements properly (and use java Connector instead of IDBManager), to make sure that there no inconsistencies?
EDIT:
Ill clarify further: I have an ingame system, where a user is buying items from the shop. In this system I need to do at least two updates: take the money off the user and add the item to user's inventory. To do it safely I need to use transactions, but the default JDBC config is to commit after each statement. This is not acceptable, as if one of the statements fails, then either the user wont have his item and loose his money, or other way around (whichever one of the statements fails). Am I better off using the default Connection where I can
Code: Select all
setAutoCommit(false)
Thank you.