[roymcbrayer]

– System Setup ——————————-
Operating System and version: windows xp
Eclipse version: 3.1 and 3.1.1
Eclipse build id: M20050929-0840
Fresh Eclipse install (y/n): y
If not, was it upgraded to its current version using the update manager? no
Other installed external plugins: none
Number of plugins in the <eclipse>/plugins directory that begin with org.eclipse.pde.*:
MyEclipse version: 4.02
Eclipse JDK version: 1.5_03
Application Server JDK version:
Are there any exceptions in the Eclipse log file?

If this is a DB related question please answer the following:

RDBMS vendor and version: Oracle 10
JDBC driver vendor and version, and access type (thin, type-2, etc): Latest ojdbc14.jar
Connection URL:
Eclipse error logs related to com.genuitec.eclipse.sqlexplorer packages:

– Message Body ——————————-

Cannot get a connection in DB Browser. I set up a connection but I get no reponse when I try to open the connection. Same driver and connection info works fine in quantumdb and exadel studio.

[roymcbrayer]

This is the entry from the error log that I found that applies to the problem I reported previously.

!ENTRY org.eclipse.ui 4 4 2005-10-11 13:40:05.296
!MESSAGE Unhandled event loop exception

!ENTRY org.eclipse.ui 4 0 2005-10-11 13:40:05.296
!MESSAGE java.lang.NullPointerException
!STACK 0
java.lang.NullPointerException
at com.genuitec.eclipse.sqlexplorer.actions.OpenConnectionDialog.createDialogArea(OpenConnectionDialog.java:150)
at org.eclipse.jface.dialogs.TitleAreaDialog.createContents(TitleAreaDialog.java:157)
at com.genuitec.eclipse.sqlexplorer.actions.OpenConnectionDialog.createContents(OpenConnectionDialog.java:102)
at org.eclipse.jface.window.Window.create(Window.java:418)
at org.eclipse.jface.dialogs.Dialog.create(Dialog.java:996)
at org.eclipse.jface.window.Window.open(Window.java:776)
at com.genuitec.eclipse.sqlexplorer.actions.OpenPasswordConnectDialogAction.run(OpenPasswordConnectDialogAction.java:79)
at com.genuitec.eclipse.sqlexplorer.actions.NewConnection.run(NewConnection.java:70)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:996)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:538)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:400)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)

[roymcbrayer]

After unchecking the “Prompt for Password”, I get the below when trying to open the connection. I have

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-11 13:42:36.490
!MESSAGE Error while trying to login to database
!STACK 0
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:96)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Thread.java:595)

[Brian Fernandes]

Roy,

Thank you for all the detail upfront.

It looks like your driver isn’t setup correctly. Go tothe Driver preference page ( Window > Preferences > MyEclipse > Database Explorer > Drivers) and edit your Oracle profile.
Go to the Driver Libraries tab and add remove the jar files listed there to be sure. Then re-add the ojdbc14.jar file and click Ok.
The existing DB profiles which you use to connect should work with the same driver.

Let us know how it goes,
Best,
Brian.

[Eaton]

I had the same problem on a custom made oracle driver and this solution works. It seems strange but It does work.

[Author]

Posts