This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
most of the code deals with hibernate and some orther parts with jdbc connections.
the places where jdbc connection was used, prepared statements,connection cons, and results sets were used and they were later not closed.
i believe this would be root cause to this error. so iam planning to close all three jdbc related in code using finally block.
on the orther end of the line , i am planning to increase my cursors size in oracle 9i db as well.
kindly guide me , appropriate steps to close these connection, or any orther way to close these cursors through in the code.
the problem is when you opening a connection, statement,resultset it is recomanded to close the connection and statement ans resultset.
it will work. fne
Joined: Apr 09, 2012
thanks for reply
G krishna kumar wrote:the problem is when you opening a connection, statement,resultset it is recomanded to close the connection and statement ans resultset.
it will work. fne
i am closing the all the connections,resultsets etc as suggested. however this process needs to be done through out my project and without effecting any functional changes.
so iam looking for a way to identify such a part of code where more number of connections opened, or like more number of resultsets are used, more like to track the trouble part of code .
if i am able to track them i am planning to close them on top proirity. any ideas will be appreciated.
my suggestion is that identify your java applications where you are performing the database operation to obtain the connections.
then try to close all the connection in all appropriate java application.