4 Replies Latest reply: Apr 11, 2013 4:49 AM by DecaXD RSS

    Issue with ODI topology

    user9210815
      We are facing the below issue in the XML physical topology.The xml file is present in Oracle MDS server. Peculiar thing is its randomly throwing this error whenever I make a change in the XML file and upload it into the MDS.

      Has anyone faced a similar issue or have any idea about it please let me know.

      java.sql.SQLException: class java.sql.SQLException
      java.sql.SQLException: statement is not in batch mode
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
           at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1118)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:420)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.localConnect(SnpsDialogTestConnet.java:860)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.jButtonTest_ActionPerformed(SnpsDialogTestConnet.java:806)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.connEtoC1(SnpsDialogTestConnet.java:165)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1(SnpsDialogTestConnet.java:161)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$IvjEventHandler.actionPerformed(SnpsDialogTestConnet.java:111)
           at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
           at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2319)
           at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
           at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
           at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
           at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
           at java.awt.Component.processMouseEvent(Component.java:6289)
           at javax.swing.JComponent.processMouseEvent(JComponent.java:3268)
           at java.awt.Component.processEvent(Component.java:6054)
           at java.awt.Container.processEvent(Container.java:2042)
           at java.awt.Component.dispatchEventImpl(Component.java:4652)
           at java.awt.Container.dispatchEventImpl(Container.java:2101)
           at java.awt.Component.dispatchEvent(Component.java:4483)
           at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
           at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
           at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
           at java.awt.Container.dispatchEventImpl(Container.java:2085)
           at java.awt.Window.dispatchEventImpl(Window.java:2479)
           at java.awt.Component.dispatchEvent(Component.java:4483)
           at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
           at java.awt.EventQueue.access$000(EventQueue.java:85)
           at java.awt.EventQueue$1.run(EventQueue.java:604)
           at java.awt.EventQueue$1.run(EventQueue.java:601)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
           at java.awt.EventQueue$2.run(EventQueue.java:618)
           at java.awt.EventQueue$2.run(EventQueue.java:615)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
           at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
           at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:175)
           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:170)
           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:162)
           at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      Caused by: java.sql.SQLException: class java.sql.SQLException
      java.sql.SQLException: statement is not in batch mode
           at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.readDocument(SnpsXmlFile.java:458)
           at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.readDocument(SnpsXmlFile.java:468)
           at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.synchronizeFromFile(SnpsXmlFile.java:643)
           at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.<init>(SnpsXmlFile.java:115)
           at com.sunopsis.jdbc.driver.xml.SnpsXmlSchema.<init>(SnpsXmlSchema.java:535)
           at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.createNewSchema(SnpsXmlSchemaManager.java:294)
           at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.getSchemaFromProperties(SnpsXmlSchemaManager.java:272)
           at com.sunopsis.jdbc.driver.xml.SnpsXmlDriver.connect(SnpsXmlDriver.java:110)
           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:409)
           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385)
           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352)
           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331)
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:99)
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
           at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:74)
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:217)
           at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
           at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
           at java.util.concurrent.FutureTask.run(FutureTask.java:139)
           at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
           at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:909)
           at java.lang.Thread.run(Thread.java:662)