1. Error : Maximum open cursors exceeded coderanch.comHi I am using TableDataSet and QueryDataSet classes provided by weblogic, for accessing the database. i have taken care in my code to close any open TableDataSet and QueryDataSet still i get this error "maximum open cursors exceeded" after i run the application for some time. what could be the problem? has it got anything to do with database connections(Connection class)? ... |
2. JDBC Cursor Error coderanch.com |
3. Inconsistent "Invalid Cursor State" Error coderanch.comHi, I am not wasting your time for a syntax error correction. I have run out of clues on this problem. The error comes from within a bean method, when the method is called by a jsp search page within some specific search terms. The bean method works fine with most of the search terms, displaying a number of matching record. ... |
4. open cursor error coderanch.comHi , we are facing the error :"MAX number of open cursors exceed 1000", the solutions are close resultset , close statements ,close connection. I think this error is because of resultsets only but my pm don't agree with me. but some can tell me why this error is ? My assumption is right ? |
5. DISTINCT sql command and Invalid cursor error coderanch.comHI everyone, Just need a bit of help with this error I keep getting. I have written the following query. rs = db.returnQuery("SELECT DISTINCT Venue.name FROM Venue, EventsVenues WHERE EventsVenues.venueID = Venue.venueID AND eventID = " + id); while(rs.next()) venue.add(new Venue(rs.getString("name"))) *************** If I take out the DISTINCT word I dont get the error. The error is generated by rs.getString("name"); If ... |
6. jdbc cursor error in win98 coderanch.com |
7. Invalid Cursor State Error... coderanch.comHello Friends, I m trying to update one coloumn in my database table, but i m getting invalid cursor state error, i have set ResultSet Updatable and Sensitive also, next i m using J2SDK1.4.0_03, so i m not but what i m using JDBC is 2.0. So are they support to updatable resultset or not. My code is look like this. ... |
8. MAX cursor exceeded error after Migration from WAS4 to WAS5.1 coderanch.comHi , I am facing error "Max cursor exceeded" in production environment. The same application code was working well in WAS4, however, after migration to WAS5.1, the error started coming up every alternate day. We have made it sure that all RS, STMT and connection objects ae closed in finally block. To take preventive meausure, we are bouncing the server every ... |
9. Invalid Cursor sate Error... :argh: coderanch.com |
10. error "ORA-01000: maximum open cursors exceeded" coderanch.comTHE STACKTRACE SAYS THAT THE ERROR IS ON LINE 189, BUT ALL THE PREPAREDSTATEMENTS ARE CLOSED , SO WHATS THE ERROR I DON'T UNDERSTAND package com.mb.util.am4; import java.io.File; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStreamWriter; import java.sql.ResultSet; import java.sql.Statement; import java.sql.PreparedStatement; import java.text.DecimalFormat; import java.text.NumberFormat; import java.util.Calendar; import java.util.HashMap; import java.util.Map; import org.apache.log4j.Logger; import com.mb.util.DateUtils; import com.mb.util.DataExport; public class MovieDataExport extends DataExport ... |
11. the JDBC "invalid state cursor" error coderanch.com |
12. Error message : ORA-01000: Maximum number of open cursors reached ?? coderanch.comOracle documentation is your friend ... Error Message: ORA-01000 maximum open cursors exceeded Error Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user. Action: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart ... |
13. Invalid Cursor State Error coderanch.com |