EAServer creates Oracle connections with the default autocommit setting, autocommit off. In non-transactional components, you must explicitly issue a commit command to commit update and insert queries. In transactional components, the EAServer transaction manager issues commit and rollback commands for connections used by the components that participate in an EAServer transaction.
In a non-transactional component, if you do not explicitly
issue commit or rollback after
sending Oracle commands, the commands may be committed when a transactional
component uses the same connection. EAServer issues a commit to
clear the connection status before passing Oracle connections to
a transactional component.
