EA3 - Multiple connections to same instance
369783Apr 12 2008 — edited Oct 16 2008In 1.2 I could have multiple SQL Worksheet connections to the same instance connection. I just tried it in EA3 and I received the following: "Status : Failure - Test failed: ORA-00604: error occured at recursive SQL level 1 ORA-01554: out of transaction slots in transaction table..."
What appears to be a corresponding java error is :
oracle.javatools.util.CanceledException
at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:560)
at oracle.dbtools.sqlworksheet.sqlview.SqlEditorWizard.invoke(SqlEditorWizard.java:113)
at oracle.ide.wizard.WizardManager.invokeWizard(WizardManager.java:317)
at oracle.dbtools.sqlworksheet.sqlview.SqlEditorController.toolbarAction(SqlEditorController.java:1267)
at oracle.dbtools.sqlworksheet.sqlview.SqlEditorController.handleEvent(SqlEditorController.java:628)
at oracle.ideimpl.controller.IdeActionHook$MetaClassController.handleEvent(IdeActionHook.java:407)
at oracle.ide.controller.IdeAction.performAction(IdeAction.java:524)
at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:855)
at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:496)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at oracle.ide.controls.ActionMenuToolButton.mav$fireActionPerformed(ActionMenuToolButton.java:77)
at oracle.ide.controls.ActionMenuToolButton$FilterActionEvents.actionPerformed(ActionMenuToolButton.java:373)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.JToggleButton$ToggleButtonModel.setPressed(JToggleButton.java:269)
at oracle.ide.controls.ActionMenuToolButton$2.setPressed(ActionMenuToolButton.java:210)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:232)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Those java errors are even worse and less descriptive than many Oracle errors.
Bill Ferguson