J
jleinbac
Guest
DataDirect Cloud does not support transactions at this time. Unfortunately, some applications do not work when a driver reports that transactions are not supported. As a result, the DataDirect Cloud JDBC driver implements a connection property called TransactionMode. The default behavior of the driver is to report that transactions are not supported and the driver returns an error if the application tries to start a manual transaction. Setting TransactionMode=ignore causes the driver to allow an application to start a manual transaction. However, DataDirect Cloud is really still operating as if in auto-commit mode. This means that any INSERT, UPDATE and DELETE statements are committed to the backend database at the time the statement is executed. When operating in this mode, the driver will allow an application to commit a manual transaction, but the driver will return an error if the application attempts to rollback the transaction since the writes were already committed to the backend. Please try setting TransactionMode=ignore when you connect to DataDirect Cloud to workaround the problem keeping in mind the limitations mentioned above.
Continue reading...
Continue reading...