Forums » Toad Extension for Eclipse » Toad Extension for Eclipse

Thread: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection

This question is answered. Helpful answers available: 2. Answered answers available: 1.

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List Point your RSS reader here for a feed of the latest messages in all forums

Permlink Replies: 12 - Pages: 1 - Last Post: Apr 22, 2011 2:45 AM by: Madhu Panyala Threads: [ Previous | Next ]
Madhu Panyala

Posts: 6
Registered: 3/9/11
Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Mar 9, 2011 7:50 AM 		 
  Click to reply to this thread Reply

Hello,

I have tried to get the TEE plugin work in my computer using Eclipse 3.5 (one of the service releases), Eclipse 3.6 SR1, Eclipse 3.6 as well. It doesn't seem to work.

Here are the details about the environment on which I have last tried TEE plugin:

OS: Windows XP SP3
Eclipse: 3.6 (without any service releases)
TEE version: 1.1.2
JRE (public) already installed: 1.6.0_20
JDK already installed: 1.6.0_14

In Eclipse, using Toad Extension properties, the path to JDBC driver has been set like this:

C:\jdbc_drivers\ojdbc14.jar

After setting the above property, Eclipse has been restarted.

Problem Description: After Eclipse is open and in Toad Extension perspective, clicking on Connection button throws up an error window with title "SQL error" and message "null".

From the Eclipse .log file, I could the get following:

!ENTRY com.quest.toadext.ui 4 2 2011-03-09 20:46:23.457
!MESSAGE Problems occurred when invoking code from plug-in: "com.quest.toadext.ui".
!STACK 0
java.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleV9.getOracleHomes(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleV9.getOracleHomes(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleInstallationRegistry.getAllOracleHomes(Unknown Source)
at com.quest.toadext.connections.dialogs.ConnectionPropertiesDialog.<init>(Unknown Source)
at com.quest.toadext.connections.dialogs.NewConnectionDialog.<init>(Unknown Source)
at com.quest.toadext.connections.view.NewConnectionAction.doRun(Unknown Source)
at com.quest.toadext.ui.actions.ToadextActionDelegate.doRunWithEvent(Unknown Source)
at com.quest.toadext.ui.actions.ToadextActionDelegate$1.run(Unknown Source)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
at com.quest.toadext.ui.actions.ToadextActionDelegate.runWithEvent(Unknown Source)
at org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:241)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2629)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2593)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2427)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:670)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:663)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
at org.eclipse.equinox.launcher.Main.run(Main.java:1407)

Appreciate if one of the gurus suggest or provide inputs to resolve this problem. Will the jdbc driver (ojdbc14.jar) work with JRE 1.6.0_20? What I found is, in the Path property, if I type some garbage path and tab out, I could see a message like this:

Selected JDBC driver is not compatible with the current JRE.
Your current JRE version is 1.6.0_20

Is there a jdbc driver that is compatible with the said JRE? I have looked at Oracle's site on jdbc drivers but couldn't locate anything like that. May be I am missing something?


Tomas

Posts: 558
Registered: 1/26/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Mar 11, 2011 4:08 AM   in response to: Madhu Panyala 		 
  Click to reply to this thread Reply

Hi,

Your post is very interesting because there should be no problem running TEE plugin on your configuration. Do you get the error message after clicking on the New Connection button?
One more question - you use the ojdbc14.jar driver. Do you know which Oracle version your driver belongs to? The version from Oracle 9 does not support parsing tns file, the versions from a higher Oracle version do... I don't now if there might be a cause of your problem.
I tested connecting through the ojdbc14 driver from Oracle 9. I got error messages, but I got to the new connection dialog and the thin connection succeeded, so I cannot reproduce your problem.
It's better to use ojdbc5.jar or ojdbc6.jar driver. If you don't have the Oracle 10 or 11 client, you can download the driver. Please try this first. You can also try the new verison of Toad Extension - 1.1.3. I hope this will help you. If it doesn't, we will try to fix the problem.

Sincerely, Tomas

Madhu Panyala

Posts: 6
Registered: 3/9/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Mar 11, 2011 7:47 AM   in response to: Tomas 		 
  Click to reply to this thread Reply

Hi Tomas,

Glad to see your response and thanks for providing help and support. First to answer your questions:

1. Yes, I get the error message on clicking the New Connection button
2. The jdbc driver ojdbc14.jar belongs to Oracle 10.2. We have other J2EE applications that connect to Oracle 10.2.0.3 databases using the very same driver. Infact I've copied the driver from one of our J2EE applications.

Next steps that I've tried:
1. I've downloaded Eclipse 3.6.2 Classic (171 MB file) and installed TEE 1.1.3
2. I have already got Oracle 11 client installed in my machine. So I've pointed TEE Oracle path to ojdbc5.jar available in Oracle 11 client installation. Didn't work.
3. Next, I have pointed TEE Oracle path to ojdbc6.jar available in Oracle 11 client installation. Didn't work.

The following is from the Eclipse log. Seems like finding Oracle (client) or jdbc is a problem:


!SESSION 2011-03-11 21:01:26.953 -----------------------------------------------
eclipse.buildId=M20110210-1200
java.version=1.6.0_20
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.equinox.preferences 4 2 2011-03-11 21:01:31.671
!MESSAGE Problems occurred when invoking code from plug-in: "org.eclipse.equinox.preferences".
!STACK 0
java.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleV9.getOracleHomes(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleV9.getOracleHomes(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleInstallationRegistry.getAllOracleHomes(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleInstallationRegistry.lookupDriver(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleInstallationRegistry.getJdbcDriverLocation(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleInstallationRegistry.getJdbcDriverLocation(Unknown Source)
at com.quest.toadext.oracle.prefs.ToadextOraclePreferences.initializeDefaultPreferences(Unknown Source)
at com.quest.toadext.oracle.prefs.PreferenceInitializer.initializeDefaultPreferences(Unknown Source)
at org.eclipse.core.internal.preferences.PreferenceServiceRegistryHelper$1.run(PreferenceServiceRegistryHelper.java:281)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.core.internal.preferences.PreferenceServiceRegistryHelper.runInitializer(PreferenceServiceRegistryHelper.java:284)
at org.eclipse.core.internal.preferences.PreferenceServiceRegistryHelper.applyRuntimeDefaults(PreferenceServiceRegistryHelper.java:130)
at org.eclipse.core.internal.preferences.PreferencesService.applyRuntimeDefaults(PreferencesService.java:369)
at org.eclipse.core.internal.preferences.DefaultPreferences.applyRuntimeDefaults(DefaultPreferences.java:166)
at org.eclipse.core.internal.preferences.DefaultPreferences.load(DefaultPreferences.java:237)
at org.eclipse.core.internal.preferences.EclipsePreferences.create(EclipsePreferences.java:307)
at org.eclipse.core.internal.preferences.EclipsePreferences.internalNode(EclipsePreferences.java:543)
at org.eclipse.core.internal.preferences.EclipsePreferences.node(EclipsePreferences.java:669)
at org.eclipse.core.internal.preferences.AbstractScope.getNode(AbstractScope.java:38)
at org.eclipse.core.runtime.preferences.DefaultScope.getNode(DefaultScope.java:67)
at org.eclipse.ui.preferences.ScopedPreferenceStore.getDefaultPreferences(ScopedPreferenceStore.java:250)
at org.eclipse.ui.preferences.ScopedPreferenceStore.getPreferenceNodes(ScopedPreferenceStore.java:285)
at org.eclipse.ui.preferences.ScopedPreferenceStore.internalGet(ScopedPreferenceStore.java:475)
at org.eclipse.ui.preferences.ScopedPreferenceStore.getString(ScopedPreferenceStore.java:535)
at com.quest.toadext.oracle.ToadextOraclePlugin.getJdbcDriverProperty(Unknown Source)
at com.quest.toadext.oracle.ToadextOraclePlugin.start(Unknown Source)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:783)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:774)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:755)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:370)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:284)
at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:417)
at org.eclipse.osgi.internal.loader.BundleLoader.setLazyTrigger(BundleLoader.java:265)
at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:106)
at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:453)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:216)
at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:393)
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:469)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.osgi.internal.loader.BundleLoader.loadClass(BundleLoader.java:338)
at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:232)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1197)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:174)
at org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:904)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243)
at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:55)
at com.quest.toadext.sql.adapter.DatabaseAdapterRegistry.<init>(Unknown Source)
at com.quest.toadext.sql.adapter.DatabaseAdapterRegistry.<init>(Unknown Source)
at com.quest.toadext.sql.adapter.DatabaseAdapterRegistry.<clinit>(Unknown Source)
at com.quest.toadext.integration.toad.ToadConnectionLoader.<init>(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:184)
at org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:904)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243)
at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:55)
at com.quest.toadext.services.impl.ConnectionService.addStores(Unknown Source)
at com.quest.toadext.services.impl.ConnectionService.start(Unknown Source)
at com.quest.toadext.services.impl.ConnectionService.start(Unknown Source)
at com.quest.toadext.ToadextPlugin.start(Unknown Source)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:783)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:774)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:755)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:370)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:284)
at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:417)
at org.eclipse.osgi.internal.loader.BundleLoader.setLazyTrigger(BundleLoader.java:265)
at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:106)
at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:453)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:216)
at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:393)
at org.eclipse.osgi.internal.loader.SingleSourcePackage.loadClass(SingleSourcePackage.java:33)
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:466)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(Unknown Source)
at com.quest.toadext.ui.ToadextUiPlugin.isOptIn(Unknown Source)
at com.quest.toadext.ui.ToadextUiPlugin.start(Unknown Source)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:783)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:774)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:755)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:370)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:284)
at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:417)
at org.eclipse.osgi.internal.loader.BundleLoader.setLazyTrigger(BundleLoader.java:265)
at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:106)
at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:453)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:216)
at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:393)
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:469)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.osgi.internal.loader.BundleLoader.loadClass(BundleLoader.java:338)
at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:232)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1197)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:174)
at org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:904)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243)
at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:55)
at org.eclipse.ui.internal.WorkbenchPlugin$1.run(WorkbenchPlugin.java:267)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.ui.internal.WorkbenchPlugin.createExtension(WorkbenchPlugin.java:263)
at org.eclipse.ui.internal.registry.ViewDescriptor.createView(ViewDescriptor.java:63)
at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:327)
at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:229)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)
at org.eclipse.ui.internal.WorkbenchPage$ActivationList.setActive(WorkbenchPage.java:4218)
at org.eclipse.ui.internal.WorkbenchPage$18.runWithException(WorkbenchPage.java:3277)
at org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4041)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3660)
at org.eclipse.ui.application.WorkbenchAdvisor.openWindows(WorkbenchAdvisor.java:803)
at org.eclipse.ui.internal.Workbench$31.runWithException(Workbench.java:1567)
at org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4041)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3660)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2548)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575)
at org.eclipse.equinox.launcher.Main.run(Main.java:1408)

!ENTRY org.eclipse.equinox.preferences 4 2 2011-03-11 21:01:32.031
!MESSAGE Problems occurred when invoking code from plug-in: "org.eclipse.equinox.preferences".
!STACK 0
java.lang.NullPointerException
at com.quest.toadext.integration.ApplicationLoader.getByAppPath(Unknown Source)
at com.quest.toadext.integration.ApplicationRegistry.getDefaultApplication(Unknown Source)
at com.quest.toadext.integration.prefs.ToadextIntegrationPreferences.initializeDefaultPreferences(Unknown Source)
at com.quest.toadext.integration.prefs.PreferenceInitializer.initializeDefaultPreferences(Unknown Source)
at org.eclipse.core.internal.preferences.PreferenceServiceRegistryHelper$1.run(PreferenceServiceRegistryHelper.java:281)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.core.internal.preferences.PreferenceServiceRegistryHelper.runInitializer(PreferenceServiceRegistryHelper.java:284)
at org.eclipse.core.internal.preferences.PreferenceServiceRegistryHelper.applyRuntimeDefaults(PreferenceServiceRegistryHelper.java:130)
at org.eclipse.core.internal.preferences.PreferencesService.applyRuntimeDefaults(PreferencesService.java:369)
at org.eclipse.core.internal.preferences.DefaultPreferences.applyRuntimeDefaults(DefaultPreferences.java:166)
at org.eclipse.core.internal.preferences.DefaultPreferences.load(DefaultPreferences.java:237)
at org.eclipse.core.internal.preferences.EclipsePreferences.create(EclipsePreferences.java:307)
at org.eclipse.core.internal.preferences.EclipsePreferences.internalNode(EclipsePreferences.java:543)
at org.eclipse.core.internal.preferences.EclipsePreferences.node(EclipsePreferences.java:669)
at org.eclipse.core.internal.preferences.AbstractScope.getNode(AbstractScope.java:38)
at org.eclipse.core.runtime.preferences.DefaultScope.getNode(DefaultScope.java:67)
at org.eclipse.ui.preferences.ScopedPreferenceStore.getDefaultPreferences(ScopedPreferenceStore.java:250)
at org.eclipse.ui.preferences.ScopedPreferenceStore.getPreferenceNodes(ScopedPreferenceStore.java:285)
at org.eclipse.ui.preferences.ScopedPreferenceStore.internalGet(ScopedPreferenceStore.java:475)
at org.eclipse.ui.preferences.ScopedPreferenceStore.getBoolean(ScopedPreferenceStore.java:387)
at com.quest.toadext.integration.toad.ToadConnectionLoader.synchronize(Unknown Source)
at com.quest.toadext.integration.toad.ToadConnectionLoader.restore(Unknown Source)
at com.quest.toadext.services.impl.ConnectionService.restoreStores(Unknown Source)
at com.quest.toadext.services.impl.ConnectionService.start(Unknown Source)
at com.quest.toadext.services.impl.ConnectionService.start(Unknown Source)
at com.quest.toadext.ToadextPlugin.start(Unknown Source)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:783)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:774)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:755)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:370)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:284)
at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:417)
at org.eclipse.osgi.internal.loader.BundleLoader.setLazyTrigger(BundleLoader.java:265)
at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:106)
at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:453)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:216)
at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:393)
at org.eclipse.osgi.internal.loader.SingleSourcePackage.loadClass(SingleSourcePackage.java:33)
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:466)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(Unknown Source)
at com.quest.toadext.ui.ToadextUiPlugin.isOptIn(Unknown Source)
at com.quest.toadext.ui.ToadextUiPlugin.start(Unknown Source)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:783)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:774)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:755)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:370)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:284)
at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:417)
at org.eclipse.osgi.internal.loader.BundleLoader.setLazyTrigger(BundleLoader.java:265)
at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:106)
at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:453)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:216)
at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:393)
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:469)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.osgi.internal.loader.BundleLoader.loadClass(BundleLoader.java:338)
at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:232)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1197)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:174)
at org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:904)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243)
at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:55)
at org.eclipse.ui.internal.WorkbenchPlugin$1.run(WorkbenchPlugin.java:267)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.ui.internal.WorkbenchPlugin.createExtension(WorkbenchPlugin.java:263)
at org.eclipse.ui.internal.registry.ViewDescriptor.createView(ViewDescriptor.java:63)
at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:327)
at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:229)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)
at org.eclipse.ui.internal.WorkbenchPage$ActivationList.setActive(WorkbenchPage.java:4218)
at org.eclipse.ui.internal.WorkbenchPage$18.runWithException(WorkbenchPage.java:3277)
at org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4041)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3660)
at org.eclipse.ui.application.WorkbenchAdvisor.openWindows(WorkbenchAdvisor.java:803)
at org.eclipse.ui.internal.Workbench$31.runWithException(Workbench.java:1567)
at org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4041)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3660)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2548)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575)
at org.eclipse.equinox.launcher.Main.run(Main.java:1408)

!ENTRY com.quest.toadext.ui 4 2 2011-03-11 21:01:37.171
!MESSAGE Problems occurred when invoking code from plug-in: "com.quest.toadext.ui".
!STACK 0
java.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleV9.getOracleHomes(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleV9.getOracleHomes(Unknown Source)
at com.quest.toadext.oracle.detectors.OracleInstallationRegistry.getAllOracleHomes(Unknown Source)
at com.quest.toadext.connections.dialogs.ConnectionPropertiesDialog.<init>(Unknown Source)
at com.quest.toadext.connections.dialogs.NewConnectionDialog.<init>(Unknown Source)
at com.quest.toadext.connections.view.NewConnectionAction.doRun(Unknown Source)
at com.quest.toadext.ui.actions.ToadextActionDelegate.doRunWithEvent(Unknown Source)
at com.quest.toadext.ui.actions.ToadextActionDelegate$1.run(Unknown Source)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
at com.quest.toadext.ui.actions.ToadextActionDelegate.runWithEvent(Unknown Source)
at org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:241)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575)
at org.eclipse.equinox.launcher.Main.run(Main.java:1408)


Tomas

Posts: 558
Registered: 1/26/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Mar 11, 2011 11:56 AM   in response to: Madhu Panyala 		 
  Click to reply to this thread Reply

Hi,
Your information is valuable, I think the development team can cope with this issue even when we couldn't reproduce the bug. I'm writing just briefly from home to let you know... we will get to the problem after weekend.

Thanks, Tomas

Tomas

Posts: 558
Registered: 1/26/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Mar 16, 2011 5:28 AM   in response to: Madhu Panyala 		 
  Click to reply to this thread Reply

Hi... are you there?

I have something regarding your problem. Although we couldn't reproduce the bug, the developer team analyzed the call stack you had sent us and localized the probable cause of the bug.
The next release (1.1.4) will contain the fix and we would be glad if you tried it and reported us whether it worked for you or not. We want to put this release to the download site next day.

Thank you, Tomas

Madhu Panyala

Posts: 6
Registered: 3/9/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Mar 17, 2011 4:08 AM   in response to: Tomas 		 
  Click to reply to this thread Reply

Hi Tomas,

I am pretty much here and appreciate your help. Great to know that you guys have localized the cause of this bug.

I'll keep a tab on TEE 1.1.4 and see if that resolves my problem. Will keep you posted.

Thanks! :-)


Tomas

Posts: 558
Registered: 1/26/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Mar 20, 2011 11:20 PM   in response to: Madhu Panyala 		 
  Click to reply to this thread Reply

Hi,

We are curious if our fix worked for you. The version 1.1.4 can be downloaded since 18.3.
Tomas

Madhu Panyala

Posts: 6
Registered: 3/9/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Mar 29, 2011 5:38 AM   in response to: Tomas 		 
  Click to reply to this thread Reply

Hi Tomas,

I was away for a while and couldn't follow up with this post.

Glad to inform that TEE 1.1.5 has worked for me! I have installed Eclipse 3.6.1 classic IDE (a while back) and installed TEE 1.1.5 today. Ensured all TEE settings are in place and on click on Connect button, I got the dialog box asking for connectivity details.

Got connected to a local Oracle DB and did a quick test on various features of TEE 1.1.5 - no issues and so far so good. Also noticed that TEE has retained the settings from the previous installation - which is nice.

Couple questions though (may not be related to actual thread), if I may post it here:

1. Does TEE support bind variables in queries?
2. If yes, how do we specify them in queries? I have tried both : and & notation - didn't work for me

Majority of the queries that we deal have bind variables. Any support from TEE would ease our life - the way currently TOAD has - it's pretty good.

Thanks for all your help and support from your team. Keep up the good work!


Tomas

Posts: 558
Registered: 1/26/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Mar 30, 2011 5:29 AM   in response to: Madhu Panyala 		 
  Click to reply to this thread Reply

Hi,

so our fix has worked for you, that's great!

Regarding bind variables, it would be better if you gave us an example of your code. We are not concerned with this stuff yet. Anyway, I think that simple selects using bind variables should work ok.

Tomas

Madhu Panyala

Posts: 6
Registered: 3/9/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Apr 5, 2011 12:33 AM   in response to: Tomas 		 
  Click to reply to this thread Reply

Hi Tomas,

Here's a simple example of bind variables in SQL query (that I have tried using):

SELECT first_name, last_name, dob
FROM persons
WHERE id = :person_id;

The above query in other IDEs would prompt the user to input a value for "person_id". I understand TEE is a plug-in and am not comparing with any of the IDEs - just wondering if some of these TOAD features are incorporated, it would make developer's life easy :-)

Regards,
Madhu


Tomas

Posts: 558
Registered: 1/26/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Apr 5, 2011 2:27 AM   in response to: Madhu Panyala 		 
  Click to reply to this thread Reply

Hi Madhu,

This form of bind variables input is not supported at this time. The development team might consider implementing the possibility of user input. I cannot tell you now more about this issue, it also depends of what priority such a feature is in the users' eyes.
The truth is that your example (adapted for another table) works in Toad very well. So we will see...

Tomas

Tomas

Posts: 558
Registered: 1/26/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Apr 5, 2011 4:51 AM   in response to: Tomas 		 
  Click to reply to this thread Reply

One more reply from me - the implementation of bind variables including user input was considered to be useful in Toad Extension. The change request TEE-25 was created for this purpose. Thank you for your post.

Tomas

Madhu Panyala

Posts: 6
Registered: 3/9/11
Re: Unable to use TEE 1.1.2 on Eclipse Helios - problem with Connection
Posted: Apr 22, 2011 2:45 AM   in response to: Tomas 		 
  Click to reply to this thread Reply

Hi Tomas,

Thanks for the update. Yeah, I've seen another user asking for the same change request.

Madhu


Pages: 1
Back to Thread List Back to Thread List
Threads: [ Previous | Next ]
Legend
MVP: 2501 + pts
Guru: 2001 - 2500 pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums