| Prakash |
Thu Jan 03 07:00:37 GMT 2008 |
| |
My Name is Prakash i am using Primrose in my project it is so nice to use and much helpful for me.
I thanx primrose team for providing this. i just want to know the Max Base=? . and IdelTime=? as i get an error "Maximum No. of connection exceed " after some time and my application goes in big trouble plz give me solution for this prob. |
| |
| sedj |
Thu Jan 03 11:07:00 GMT 2008 |
| |
You are leaking cursors (ResultSet objects probably, but possibly
Statement objects too) because your code is not closing all db objects
correctly.
|
| guest |
Fri Jan 04 06:29:08 GMT 2008 |
| |
thanX for u r reply m\plz help me to solve,
I have close all resultset ,Statement and connection in Finally block of all JSP pages but if error comes on any page then the finaaly block is not executed tell me the solution to close the d/b connection when any exception occurs.
Also tell me the Base=? and IdelTime for my connection Setting Properties file. |
| sedj |
Fri Jan 04 08:51:35 GMT 2008 |
| |
Connection c = null;
Statement s = null;
ResultSet rs = null;
try {
// Get connection, do stuff
} catch {
// Do stuff to handle your exception
} finally {
try { if (rs != null) rs.close() } catch (SQLException sqle) { sqle.printStackTrace(); }
try { if (s != null) s.close() } catch (SQLException sqle) { sqle.printStackTrace(); }
try { if (c != null) c.close() } catch (SQLException sqle) { sqle.printStackTrace(); }
}
As for base & idletime, it entirely depends on your application load - there are no "you should use these" settings ... |
|
