Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EA3 - Multiple connections to same instance

369783Apr 12 2008 — edited Oct 16 2008
In 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 13 2008
Added on Apr 12 2008
2 comments
814 views