Database-side JDBC routines using non-nested connectionsA database-side JDBC routine can create a new connection instead
of using a nested connection. Statements executed in the routine will be
part of a different transaction, and so can issue commits and rollbacks.Database-side JDBC routinesusing non-nested
connections
Such a routine can connect to a database different from the one to which
the parent SQL statement that called it is connected. The routine does not
use the same transaction or Connection. It establishes a new Connection and
transaction.
If database-side JDBC routines do not use nested connections, this
means that they are operating outside of the normal DBMS transaction control,
so it is not good practice to use them indiscriminately.