[TucsonEdM]

How do you add a new driver?

When I complete the “add new driver” dialogue box all I get is “Error Creating Driver” with no helpful information.

I am trying to create an rdbThin driver. I enter the correct url and driver class, no luck. I even point the dialogue to a jar file that contains the driver and still nothing but error.

FYI…
url = jdbc:rdbThin://<hostname>:<port>/<directory> (actual values omitted)
driver_class = com.p6spy.engine.spy.P6SpyDriver

Thanks for your help.
Ed Murpy
University of Arizona

[Riyad Kalla]

Ed,
Are these JARs freely available such that I can test them locally and possibly developed a bug report to file for the DB devs?

Also can you grab any exceptions from your <workspace dir>\.metadata\.log file that might point us at the problem? I’m thinking the most likely problem (similar to the SQL Driver problem) is that P6SpyDriver may not extend BaseDriver (or implement Driver) from the java.sql package and the driver setup may be balking at this…

[TucsonEdM]

Riyad,

You can download P6Spy from http://www.p6spy.com, the associated jar files are inside the install jar file. I’m not sure where you can get rdbthin.jar…perhaps from oracle? If you can’t find them I can send them to you.

Yes, there are exceptions in <workspace dir>\.metadata\.log file. Below is an example of this problem
————————————————————————————————————————
!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Nov 19, 2004 10:07:35.943
!MESSAGE Exception when adding driver
!STACK 0
java.lang.ClassNotFoundException: com.p6spy.engine.spy.P6SpyDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.registerSQLDriver(SQLDriverManager.java:60)
at com.genuitec.eclipse.sqlexplorer.DataCache.addDriver(Unknown Source)
at com.genuitec.eclipse.sqlexplorer.DriverModel.addDriver(Unknown Source)
at com.genuitec.eclipse.sqlexplorer.dialogs.CreateDriverDialog.okPressed(Unknown Source)
at org.eclipse.jface.dialogs.Dialog.buttonPressed(Dialog.java:391)
at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:538)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:89)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2783)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2442)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:706)
at org.eclipse.jface.window.Window.open(Window.java:684)
at com.genuitec.eclipse.sqlexplorer.plugin.wizards.ConnectionProfileWizardMainPage$3.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:89)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2783)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2442)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:706)
at org.eclipse.jface.window.Window.open(Window.java:684)
at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.NewConnectionProfileAction.run(Unknown Source)
at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.AbstractConnectionProfileAction.run(Unknown Source)
at org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:298)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:555)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:505)
at org.eclipse.jface.action.ActionContributionItem$7.handleEvent(ActionContributionItem.java:460)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2783)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2442)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1443)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1414)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:271)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:144)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:102)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:335)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:273)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:129)
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.core.launcher.Main.basicRun(Main.java:185)
at org.eclipse.core.launcher.Main.run(Main.java:704)
at org.eclipse.core.launcher.Main.main(Main.java:688)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Nov 19, 2004 10:08:41.187
!MESSAGE Exception when adding driver
!STACK 0
java.lang.ClassNotFoundException: C:\Documents and Settings\Ed\.maven\repository\oracle\jars\rdbthin.jar
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.registerSQLDriver(SQLDriverManager.java:60)
at com.genuitec.eclipse.sqlexplorer.DataCache.addDriver(Unknown Source)
at com.genuitec.eclipse.sqlexplorer.DriverModel.addDriver(Unknown Source)
at com.genuitec.eclipse.sqlexplorer.dialogs.CreateDriverDialog.okPressed(Unknown Source)
at org.eclipse.jface.dialogs.Dialog.buttonPressed(Dialog.java:391)
at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:538)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:89)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2783)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2442)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:706)
at org.eclipse.jface.window.Window.open(Window.java:684)
at com.genuitec.eclipse.sqlexplorer.plugin.wizards.ConnectionProfileWizardMainPage$3.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:89)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2783)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2442)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:706)
at org.eclipse.jface.window.Window.open(Window.java:684)
at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.NewConnectionProfileAction.run(Unknown Source)
at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.AbstractConnectionProfileAction.run(Unknown Source)
at org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:298)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:555)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:505)
at org.eclipse.jface.action.ActionContributionItem$7.handleEvent(ActionContributionItem.java:460)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2783)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2442)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1443)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1414)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:271)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:144)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:102)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:335)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:273)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:129)
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.core.launcher.Main.basicRun(Main.java:185)
at org.eclipse.core.launcher.Main.run(Main.java:704)
at org.eclipse.core.launcher.Main.main(Main.java:688)

[Riyad Kalla]

Ed,
Looking at these errors it looks like a configuration issue… could you be so kind as to package all necessary files into a project (or Zip) and send it to support@genuitec.com ATTN Riyad, then tell me roughly what steps you take to reproduce this problem and I will do it. If I find a bug, I’ll have the resources to file it with enough detail that it should be fixed quickly, that’s why I’m asking for all the files upfront. Sorry for the extra work, I don’t have my magic wand to wave over this right now, it’s in the wash 😉

[TucsonEdM]

Riyad,

Sorry for the delay in responding to your last post, I was on vacation. I will work on collecting the necessary files and send you a Zip file shortly.

Ed

[Author]

Posts