Metacat

Change back to pass connection as paramter in getUniqueID, otherwise new connection will cause a error:
sequence XML_NODES_ID_SEQ.CURRVAL is not yet defined in this session

Add a new method - createStatement.

Correct the parameter of getDBConnection - methodName in code.

Change for every method to use getDBConnection and returnDBConnection to manage DBConnection.

Using getDBConenction rather than pass connection as parameter.

Using getDBConnection rather than pass connection as a parameter.

Using getDBConnection method rather than a parameter.

Change the prototype of method getUniqeID

Add DBConnectionPool object in servlet's init method and DBConnectionPool's release method in servlet's destory method.

Delete connection as a class field and make every method to check in and check out connection if it need.