August 1999
Intermediate to advanced
1488 pages
72h 53m
English
connection.commitTransaction()
The commitTransaction() method of the Connection object commits a new SQL transaction. This commits all the actions against the database since the last commit. If the commit is successful, 0 is returned. If a non-zero number is returned, an error is encountered. In this case, various methods of the Connection object can be used to retrieve the code and message of the error.
Listing 8.13 creates a pool of connections to an Oracle database and pulls one of the connections from the pool. After the connection has been verified, the beginTransaction() method is called and a SQL query is performed. The results are formatted in a table with the SQLTable() ...
Read now
Unlock full access