1 Reply Latest reply on Dec 6, 2007 11:10 PM by 807574

    java.sql.SQLException: File input/output error: File input/output error: re

    807574
      Hi,

      We are using JCAPS 512. We use oracle eway to connect to Oracle 10g database. But sometimes we are getting the following exception
      and suddenly all jcds stop processing. If we restart the server again job continue processing, otherwise server hangs and nothing get processed.

      Exception is as follows

      java.sql.SQLException: File input/output error: File input/output error: reading: java.io.EOFException in statement [SET TABLE EVENT_STORE INDEX '11183416 55935']
           at org.hsqldb.Trace.getError(Unknown Source)
           at org.hsqldb.Log.runScript(Unknown Source)
           at org.hsqldb.Log.open(Unknown Source)
           at org.hsqldb.Database$Logger.openLog(Unknown Source)
           at org.hsqldb.Database.open(Unknown Source)
           at org.hsqldb.Database.<init>(Unknown Source)
           at org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
           at org.hsqldb.jdbcConnection.<init>(Unknown Source)
           at org.hsqldb.jdbcDriver.connect(Unknown Source)
           at java.sql.DriverManager.getConnection(DriverManager.java:525)
           at java.sql.DriverManager.getConnection(DriverManager.java:171)
           at com.stc.eventmanagement.impl.DBEventStore$EventStoreDB.addNewConnection(DBEventStore.java:359)
           at com.stc.eventmanagement.impl.DBEventStore$EventStoreDB.getConnection(DBEventStore.java:444)
           at com.stc.eventmanagement.impl.DBEventStore$EventStoreDB.executeParameterizedQuery(DBEventStore.java:777)
           at com.stc.eventmanagement.impl.DBEventStore$EventStoreDB.access$000(DBEventStore.java:250)
           at com.stc.eventmanagement.impl.DBEventStore.getEventIDsList(DBEventStore.java:133)
           at com.stc.eventmanagement.impl.DBEventStore.getEventIDsList(DBEventStore.java:115)
           at com.stc.eventmanagement.impl.EventForwarderMBean.cachePersistedEvents(EventForwarderMBean.java:728)
           at com.stc.eventmanagement.impl.EventForwarderMBean.setup(EventForwarderMBean.java:334)
           at com.stc.eventmanagement.impl.EventForwarderMBean.invoke(EventForwarderMBean.java:565)
           at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213)
           at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220)
           at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815)
           at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784)
           at com.stc.eventmanagement.impl.EventManagementService.setupEventForwarderMbean(EventManagementService.java:270)
           at com.stc.eventmanagement.impl.EventManagementService.registerMBean(EventManagementService.java:147)
           at com.stc.eventmanagement.impl.EventManagementService.startService(EventManagementService.java:96)
           at com.stc.eventmanagement.impl.EventManagementResourceAdapter.start(EventManagementResourceAdapter.java:75)
           at com.sun.enterprise.connectors.ActiveInboundResourceAdapter.<init>(ActiveInboundResourceAdapter.java:94)
           at com.sun.enterprise.connectors.ActiveRAFactory.createActiveResourceAdapter(ActiveRAFactory.java:74)
           at com.sun.enterprise.connectors.ResourceAdapterAdminServiceImpl.createActiveResourceAdapter(ResourceAdapterAdminServiceImpl.java:269)
           at com.sun.enterprise.connectors.ResourceAdapterAdminServiceImpl.createActiveResourceAdapter(ResourceAdapterAdminServiceImpl.java:372)
           at com.sun.enterprise.connectors.ConnectorRuntime.createActiveResourceAdapter(ConnectorRuntime.java:204)
           at com.sun.enterprise.server.ConnectorModuleLoader.load(ConnectorModuleLoader.java:87)
           at com.sun.enterprise.server.ConnectorModuleLoader.load(ConnectorModuleLoader.java:108)
           at com.sun.enterprise.server.AbstractManager.load(AbstractManager.java:216)
           at com.sun.enterprise.server.AbstractManager.load(AbstractManager.java:106)
           at com.sun.enterprise.server.ApplicationLifecycle.onStartup(ApplicationLifecycle.java:183)
           at com.sun.enterprise.server.ApplicationServer.onStartup(ApplicationServer.java:295)
           at com.sun.enterprise.server.PEMain.run(PEMain.java:238)
           at com.sun.enterprise.server.PEMain.main(PEMain.java:186)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:585)
           at org.apache.commons.launcher.ChildMain.run(ChildMain.java:269)
      |#]

      Please provide some suggestions to overcome this  error

      Regards
      Venkatesh.S