Version: 15.0.0-dev-51

Build #: 35184

Build Date: 2013-Dec-11 04:31:36 PM

 

Excel Driver - disable autocommit and change server gives SQL Operation not supported

 

1. Open a query window to an Excel data source.

2. Disable Auto Commit

3. Now change Server

4. A message is displayed. Click Yes and you get in error log

 

\\...\\ .\\हिñçêČάй語简??한\\.Aꃲꄸᡲꅚ int try: SQL operation is not supported.

        at \\...\\ .\\हिñçêČάй語简??한\\.w⢓ᡢ⣙ꆴ default.commit(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.Eꀼ⢼̋ꈀ float static.commit(Unknown Source)

        at com.aquafold.datastudio.queryanalyzer.Pꐞꉢꂰꀖ case.commit(Unknown Source)

        at com.aquafold.datastudio.queryanalyzer.Pꐞꉢꂰꀖ case.cOQ(Unknown Source)

        at com.aquafold.datastudio.queryanalyzer.Pꐞꉢꂰꀖ case.IG(Unknown Source)

        at com.aquafold.datastudio.queryanalyzer._ꒂ͂ꑀꍴ.action(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.kꇅꋁ̄ꐾ abstract try.actionPerformed(Unknown Source)

        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028)

        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351)

        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 com.jidesoft.plaf.basic.BasicJideButtonListener.mouseReleased(Unknown Source)

        at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)

        at java.awt.Component.processMouseEvent(Component.java:6382)

        at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)

        at java.awt.Component.processEvent(Component.java:6147)

        at java.awt.Container.processEvent(Container.java:2083)

        at java.awt.Component.dispatchEventImpl(Component.java:4744)

        at java.awt.Container.dispatchEventImpl(Container.java:2141)

        at java.awt.Component.dispatchEvent(Component.java:4572)

        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4619)

        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4280)

        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4210)

        at java.awt.Container.dispatchEventImpl(Container.java:2127)

        at java.awt.Window.dispatchEventImpl(Window.java:2489)

        at java.awt.Component.dispatchEvent(Component.java:4572)

        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:710)

        at java.awt.EventQueue.access$400(EventQueue.java:82)

        at java.awt.EventQueue$2.run(EventQueue.java:669)

        at java.awt.EventQueue$2.run(EventQueue.java:667)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)

        at java.awt.EventQueue$3.run(EventQueue.java:683)

        at java.awt.EventQueue$3.run(EventQueue.java:681)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

        at java.awt.EventQueue.dispatchEvent(EventQueue.java:680)

        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)

        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)

        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)

        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)

        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)

        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)