Error Could Not Position Within A File Via An Index
Contents |
the accompanying ISAM error code for isam error record is locked more information. The table file or the index file might have been corrupted. Unless the ISAM error code or an operating-system message points to another cause, run the oncheck utility (secheck with IBM Informix SE or tbcheck with IBM Informix OnLine) to check and repair table and index. Copyright Privacy
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Exception: java.sql.SQLException: Could http://www.oninit.com/errorcode/index.php?pageid=-245 not position within a table (informix.tblName) up vote 1 down vote favorite Query: my_table is a view not a table static final String query= "SELECT "+MailboxId+", " + Action+", " + ActionType+", " + MsgType+", " + Priority+", " + MsgID+", " + MsgCountsSequenceNumber+", " + MsgCounts+", " + TimeOfEvent+" " + "FROM my_table " + "ORDER BY TimeOfEvent;"; public ResultSet executeQuery(Statement st, String query) http://stackoverflow.com/questions/31958581/exception-java-sql-sqlexception-could-not-position-within-a-table-informix-tb throws SQLException { boolean isDeadlock= false; ResultSet rs = null; int retries= deadlockRetries; do { try { rs = st.execute(query); //here it produces exception } catch (SQLException e) { if (e.getErrorCode() == SQLERR_DEADLOCK) { diag_log(LOG, "Deadlock exception generated during execute query=", sqlQuery, ". Retries=", Integer.toString(retries)); isDeadlock= true; synchronized(_lock) { deadlockCount++; } } else { diag_log(LOG, "SQL Exception: ", Integer.toString(e.getErrorCode()), " query=", sqlQuery, " exception= ", e.getMessage() != null ? e.getMessage() : "unavailable"); // this log gets printed throw e; } } } while (isDeadlock && retries-- > 0); return rs; } Logs: Failed to read database Mydyndb with query SELECT MailboxId, Action, ActionType, MsgType, Priority, MsgID, MsgCountsSequenceNumber, MsgCounts, TimeOfEvent FROM my_table ORDER BY TimeOfEvent;. TECHNICAL DETAILS: Exception: java.sql.SQLException: Could not position within a table (informix.my_table). Need to know the reason for this exception sql jdbc informix sqlexception share|improve this question edited Aug 12 '15 at 10:32 asked Aug 12 '15 at 7:23 quintin 16312 Can you show us the code where you create your statement and also the query string? –Tim Biegeleisen Aug 12 '15 at 7:26 1 You get this exception when there is a lock on th
index If this is your first 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 http://www.dbforums.com/showthread.php?1198005-java-sql-SQLException-Could-not-position-within-a-file-via-an-index visit from the selection below. Results 1 to 3 of 3 Thread: java.sql.SQLException: Could not position within a file via an index Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode https://supportforums.cisco.com/discussion/10869236/database-error-cucm7-cluster Switch to Hybrid Mode Switch to Threaded Mode 10-05-05,10:48 #1 zhongyu View Profile View Forum Posts Registered User Join Date Oct 2005 Posts 3 Unanswered: java.sql.SQLException: Could not position within a file via an index Hi guys, First I had could not the 243 problem (Couldn't not position within a table(table name)) first. then I changed my isolation level to "READ_UNCOMMITTED", but now I got stuck on the error 245. when i looked at the lock logs, the other process was getting IX,X table/page/row locks on the table my process was trying to access, plus the X locks on the primary key and foreign keys. Any suggestion? Thanks very much! Zz Reply With Quote 10-05-05,11:12 #2 gurey View Profile View Forum Posts could not position Registered User Join Date Aug 2003 Location Argentina Posts 780 Hi, Please run before SET LOCK MODE TO [WAIT|| n seconds], next run sql. Gustavo. Reply With Quote 10-05-05,11:43 #3 zhongyu View Profile View Forum Posts Registered User Join Date Oct 2005 Posts 3 index locking? Thanks Gustavo. Actually I did set the lock mode to -1(which is wait until the lock releases). Everything worked on my test(i did a lock table in exclusive mode) and my own application/proc waited until I issued the unlock command. However, as soon as the other app runs(the test team and I had the test case of running two apps at the same time), I watched the locks and the locks showed indexes being locked as well(along with some system locks that I am not familar with), then my app will get this 245 error Could not position within a file via index). of course, after 3 mins when the other app is done, my app worked as usual. Any insight is highly appreciated! I have been stuck with this issue for a week. Zhongyu Last edited by zhongyu; 10-05-05 at 12:06. 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 JA
Us Help Follow Us YouTube Facebook Twitter Google + LinkedIn Newsletter Instagram DirectoryNetwork InfrastructureWAN, Routing and Switching LAN, Switching and Routing Network Management Remote Access Optical Networking Getting Started with LANs IPv6 Integration and Transition EEM Scripting Other Subjects SecurityVPN Security Management Firewalling Intrusion Prevention Systems/IDS AAA, Identity and NAC Physical Security MARS Email Security Web Security Other Subjects Service ProvidersMetro MPLS Voice Over IP XR OS and Platforms Video Other Subjects Collaboration, Voice and VideoIP Telephony Video Over IP Jabber Clients Unified Communications Applications TelePresence Digital Media System Contact Center Conferencing UC Migrations Other Subjects Wireless - MobilitySecurity and Network Management Wireless IP Voice and Video Getting Started with Wireless WLCCA Other Subjects ServicesCisco ServiceGrid Connected Analytics Smart Call Home Smart Net Total Care Operations Exchange Mobile ApplicationsCisco Proximity Cisco Technical Support Online Tools and ResourcesCisco Bug Discussions Technical Documentation Ideas Cisco CLI Analyzer Support Community Help Data CenterApplication Centric Infrastructure Application Networking Intelligent Automation Server Networking Storage Networking Unified Computing Wide Area Application Services (WAAS) Other Subjects Small BusinessNetwork Storage Routers Security Surveillance Switches Voice and Conferencing Wireless Solutions and ArchitecturesBorderless Networks Collaboration Cisco User GroupsSeattle Cisco User Group (SEACUG) Silicon Valley Cisco User Group (SVCUG) Southern California Cisco User Group (SCCUG) Cisco Certifications Cisco.com Idea Center Cisco Cafe Expert CornerTop Contributors Leaderboards Cisco Live! Events Events Community CornerAwards & Recognition Behind the Scenes Feedback Forum Cisco Certifications Cisco Press Café Cisco On Demand Support & Downloads Community Resou