This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have an application web in development using JSP + Servlets in a Resin 2.1.4 integrated with the Apache 1.3.26 + J2SDK 1.4, everything turning on SuSE Linux 7.2. The application accesses a database Oracle 9i remote R1 and sometimes during the execution of some heavier routines I obtain the error message of Exausted ResultSet. What can cause this? Which the solution for the problem? I thank for the help
this seems to be an oracle specific problem try. You are probably doing something like: ResultSet result = select.executeQuery( "select * from employee where id = 'employeeID' "); try this ResultSet result = select.executeQuery("select * from employee where id = '"+employeeID+"' "); or (my preference) a PreparedStatement: PreparedStatement s = select.prepareStatement("select * from employee where id =?"); s.setInt(employeeID); ResultSet result = s.executeQuery();
chanoch<p><a href="http://www.amazon.com/exec/obidos/ASIN/1861007736/" target="_blank" rel="nofollow">Author of Professional Apache Tomcat</a></p>
"scsantos", Thanks for participating here at the Ranch. However, the name you are using does not comply with our naming convention described at http://www.javaranch.com/name.jsp . Please log in with a new name, which meets these requirements. You can change your name here. Thanks. Sean