Informix Error Cursor Not Open
Contents |
user forum > Topic: Informix JDBC driver: cursor not open 2 replies Latest Post - 2008-11-02T10:50:30Z by SystemAdmin Display:ConversationsBy informix cursor with hold Date 1-3 of 3 Previous Next SystemAdmin 110000D4XK 1143 Posts
Informix Cursor Example
Pinned topic Informix JDBC driver: cursor not open 2008-10-28T14:45:44Z | Tags: Answered question This there is no current cursor informix question has been answered. Unanswered question This question has not been answered yet. I have a scenario selecting rows from the source table informix sql error and updating the target table, but while it was reading from a source table, I am getting this error. Caused by: java.sql.SQLException: Cursor not open. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373) at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3208) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2353) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2269) at com.informix.jdbc.IfxSqli.j(IfxSqli.java:1946) at com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4246) at com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:511) I am not closing any result or
Informix Odbc Error
something, but it is complaining from the result set... Does anybody know why I am getting this error? Thanks. Log in to reply. Updated on 2008-11-02T10:50:30Z at 2008-11-02T10:50:30Z by SystemAdmin SystemAdmin 110000D4XK 1143 Posts Re: Informix JDBC driver: cursor not open 2008-10-28T18:29:13Z This is the accepted answer. This is the accepted answer. I posted a wrong scenario. Basically, I was doing a select and update on a same table. So I use a same jdbc connection with setAutoCommit(false) and setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED). The problem is that it seems the cursor is closed after I commit at a number of rows. That's the exception that I get. Log in to reply. SystemAdmin 110000D4XK 1143 Posts Re: Informix JDBC driver: cursor not open 2008-11-02T10:50:30Z This is the accepted answer. This is the accepted answer. SystemAdmin 110000D4XK 2008-10-28T18:29:13Z I posted a wrong sce
visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit informix error 951 from the selection below. Results 1 to 2 of 2 Thread: Error -249: Cursor not informix error codes list open...HEEEEEEEELP! Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode
Informix Error 908
Switch to Threaded Mode 11-18-05,12:26 #1 pitris View Profile View Forum Posts Registered User Join Date Nov 2005 Posts 5 Unanswered: Error -259: Cursor not open...HEEEEEEEELP! Hi Here's the thing: my java application launches several threads sharing the https://www.ibm.com/developerworks/community/forums/thread.jspa?threadID=231507 same db connection. I know that the java.sql-connection object is not threadsafe, so I created a wrapper class which, among other things, synchronizes the access to the connection object. One of the threads just reads requests from an entry table and assigns them to several worker threads which do some processing and, if successfull, delete the request from the entry table and insert an answer in a response table. This delete/insert should be done in a http://www.dbforums.com/showthread.php?1202298-Error-249-Cursor-not-open-HEEEEEEEELP! single transacion. My first problem was a "Could not position within a table" error. The sugestion I got from a nice guy from this forum (thanks Gustavo ) was to set the lock mode to wait. I did this and now I'm getting a new error ("Error -259: Cursor not open") when executing the select statement. Does anyone have a clue on what's happening? How can the cursor be closed when I'm opening it with a select statement? I'm no DB expert, as you probably already figured out, and I could really use some help. Thanks in advance! Last edited by pitris; 11-21-05 at 05:49. Reply With Quote 11-22-05,06:12 #2 pitris View Profile View Forum Posts Registered User Join Date Nov 2005 Posts 5 Found out the problem: when executing the select statement I had Autocommit set to false. I'm not sure why this was a problem, but setting it to true before the select solved the problem... Reply With Quote Quick Navigation Informix Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, Manipulation & Batch Languages ASP Crystal Reports Delphi, C etc JAVA Perl and the DBI PHP ANSI SQL Unix Shell Scripts Visual Basic PC based Database Applications Brilliant
open problem if synchronizeMapping set trueAgile Board ExportXMLWordPrintableJSON Details Type: Bug Status: Closed Priority: Major informix error Resolution: Fixed Affects Version/s: 1.2.0 Fix Version/s: 1.2.1, 1.3.0, 2.0.0-M2 Component/s: jdbc Labels: None Description Informix JDBC driver default resultSet Holdability informix error cursor is 2 (CLOSE_CURSORS_OVER_COMMIT), which causes SQLException :Cursor not open.