Monday, June 9, 2008

Implication of Connection Pooling in Windows

When we write an application to run in Windows either using ASP or Windows Application; Windows will automatically perform connection pooling. I recently wrote an application that uses multi threads to scan the database using different criteria and then update the database.

One of the threads encountered the following error ORA-01422: exact fetch returns more than requested number of rows, due to the try and catch, the routine will exit and close the connection. However, I found that other threads apparently took over the session and encountered the following error instead: ORA-02067: transaction or savepoint rollback required.

No comments: