ORA-01000: maximum open cursors exceeded

[ujjwal soni]

I am getting this below error.

Oracle/PLSQL: ORA-01000 Error

--------------------------------------------------------------------------------
Error:
ORA-01000: maximum open cursors exceeded


I am using hibernate with struts framework.

I am doing this in finally clause of each dao.

finally
{
rs.close(); //resultset
connection.close(); //connection
session.disconnect(); //session
}

please help

[Bauke Scholtz]

ujjwal soni wrote:

finally
{
rs.close(); //resultset
connection.close(); //connection
session.disconnect(); //session
}

Bad code. If rs is null, connection will never be closed.
And how about statements?

[Scott Selikoff]

Actually even if rs is not null, it can still throw an exception preventing the connection from ever being closed. Each statement in the finally should have a try/catch around them. I wrote an article on closing JDBC resources some time back.

[Bauke Scholtz]

(Prepared)Statements are also expensive resources.
If you use connection pooling, the connection.close() won't close any opened Statements.