7 Replies Latest reply on Mar 25, 2010 6:20 PM by jschellSomeoneStoleMyAlias

    ISAM error: the file is locked in Informix Dynamic Server 11.5

    843859

      Hi All,

      I am using Informix Dynamic Server 11.5. I am using JDBC driver ifxjdbc.jar (version 3.00.JC3) to establish the connection.
      When from our code I try to get a read-only connection with this database I get the following exception:

      java.sql.SQLException: Could not position within a table (informix.systables).
      at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3204)
      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.a(IfxSqli.java:1532)
      at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1471)
      at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1401)
      at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:204)
      at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1212)
      at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:202)
      at com.informix.jdbc.IfxSqliConnect.d(IfxSqliConnect.java:2811)
      at com.informix.jdbc.IfxSqliConnect.a(IfxSqliConnect.java:2626)
      at com.informix.jdbc.IfxSqli.a(IfxSqli.java:2615)
      at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1800)
      at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1327)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:516)
      at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:254)
      at abcd.services.jdbc.JDBCDriverLoader.getConnection(Unknown Source)
      at abcd.services.jdbc.OpenCloseConnectionFactory.createReadOnlyConnection(Unknown Source)
      at abcd.configutils.repository.IfxDataService.processEightThousand(IfxDataService.java:384)
      at abcd.configutils.repository.IfxDataService.updateEightThousand(IfxDataService.java:364)
      at abcd.configutils.repository.IfxDataService.avanti(IfxDataService.java:176)
      at abcd.configutils.repository.RoboRepository.ifxProcess(Unknown Source)
      at abcd.configutils.repository.RoboRepository.exeMultiUpdateSql(Unknown Source)
      at abcd.configutils.repository.RoboRepository.updateDatabaseSchema(Unknown Source)
      at abcd.configutils.repository.NCRepositoryAdmin.avanti(Unknown Source)
      at abcd.configutils.repository.NCRepositoryAdmin.main(Unknown Source)
      Caused by: java.sql.SQLException: ISAM error: the file is locked.
      at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
      at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3523)

      How can I resolve this issue?