Hi, my JSP application which is connecting to Oracle is facing the issue below:
Failed to obtain/create connection. Reason : Connection could not be allocated because: ORA-00020: maximum number of processes (150) exceeded.
We actually close all the statements and connection used. Although not sure whether the system will close the result set in the event of exception. Does closing statements and connections automatically closed the resultset?
I attached snippet of our function in Java as follows. Please advise, thanks.
public Vector getAllData()
voData vo = new voData();
Vector v = new Vector();
String querySql = "SELECT * FROM TBLDATA";
vo = new voData();
rs = null;