2 Replies Latest reply on Mar 20, 2015 10:06 PM by Gary Graham-Oracle

    Query not running in sql developer, neither connecting to database. Following error - java.util.UnknownFormatConversionException: Conversion = '0'. Please reply soon.

    user9094328

      when i try to connect to oracle 11g rdbms, following error occurs -->

       

      1. sql developer version - 4.0.3.16 (jdk - jdk1.7.0_51 externally installed) -- newly installed, giving following error when try to connect to oracle 11g rdbms.

      2. sql developer version - 3.1.07.42 (jre1.6.0 included) -- used to run earlier.

       

      java.util.UnknownFormatConversionException: Conversion = '0'

        at java.util.Formatter.checkText(Formatter.java:2547)

        at java.util.Formatter.parse(Formatter.java:2533)

        at java.util.Formatter.format(Formatter.java:2469)

        at java.util.Formatter.format(Formatter.java:2423)

        at java.lang.String.format(String.java:2797)

        at oracle.dbtools.raptor.backgroundTask.internal.SimpleRaptorTaskUI.getFormattedTime(SimpleRaptorTaskUI.java:288)

        at oracle.dbtools.raptor.backgroundTask.internal.RaptorTaskUI.setState(RaptorTaskUI.java:43)

        at oracle.dbtools.raptor.backgroundTask.internal.SimpleRaptorTaskUI.<init>(SimpleRaptorTaskUI.java:63)

        at oracle.dbtools.raptor.backgroundTask.internal.RaptorTaskUI.<init>(RaptorTaskUI.java:36)

        at oracle.dbtools.raptor.backgroundTask.ui.TaskProgressViewer$4.<init>(TaskProgressViewer.java:346)

        at oracle.dbtools.raptor.backgroundTask.ui.TaskProgressViewer.createTaskUI(TaskProgressViewer.java:346)

        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.initViewers(RaptorTaskManager.java:373)

        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.access$400(RaptorTaskManager.java:45)

        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$4.run(RaptorTaskManager.java:299)

        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.invokeInDispatchThreadIfNeeded(RaptorTaskManager.java:313)

        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.addTask(RaptorTaskManager.java:302)

        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.addTask(RaptorTaskManager.java:200)

        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.addTask(RaptorTaskManager.java:161)

        at oracle.dbtools.worksheet.editor.OpenWorksheetWizard.invoke(OpenWorksheetWizard.java:425)

        at oracle.ide.wizard.WizardManager.invokeWizard(WizardManager.java:446)

        at oracle.ide.wizard.WizardManager.invokeWizard(WizardManager.java:390)

        at oracle.dbtools.worksheet.editor.WorksheetOpenController$1.run(WorksheetOpenController.java:84)

        at oracle.dbtools.worksheet.editor.WorksheetOpenController.openWorksheetWizard(WorksheetOpenController.java:90)

        at oracle.dbtools.worksheet.editor.WorksheetOpenController.handleEvent(WorksheetOpenController.java:49)

        at oracle.ide.controller.IdeAction$ControllerDelegatingController.handleEvent(IdeAction.java:1482)

        at oracle.ide.controller.IdeAction.performAction(IdeAction.java:663)

        at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:1153)

        at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:618)

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

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

        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)

        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)

        at javax.swing.AbstractButton.doClick(AbstractButton.java:376)

        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)

        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        at java.awt.EventQueue.access$200(EventQueue.java:103)

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

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

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

        at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

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

        at java.awt.EventQueue$4.run(EventQueue.java:708)

        at java.awt.EventQueue$4.run(EventQueue.java:706)

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

        at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

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

        at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

        at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

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

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

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

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

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

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