[ksgetting]

I just installed and configured SQL server 2000 (with SP4) on a Windows 2003 (with SP1) server. I am trying to open a DB connection using the DB Explorer to the SQL Server DB. Every attempt fails immediately with the following error:

java.lang.NullPointerException
at com.genuitec.eclipse.sqlexplorer.actions.OpenPasswordConnectDialogAction.perfomLoginAndRetrieval(OpenPasswordConnectDialogAction.java:114)
at com.genuitec.eclipse.sqlexplorer.actions.OpenPasswordConnectDialogAction.run(OpenPasswordConnectDialogAction.java:75)
at com.genuitec.eclipse.sqlexplorer.actions.NewConnection.run(NewConnection.java:70)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:539)
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:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1914)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:419)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
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.invokeFramework(Main.java:336)
at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
at org.eclipse.core.launcher.Main.run(Main.java:977)
at org.eclipse.core.launcher.Main.main(Main.java:952)

My Eclipse installation details are:

*** Date: Wed Dec 06 15:00:46 EST 2006

*** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_09

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 5.0 GA
Build id: 20060805-5.0-GA

*** Eclipse details:
MyEclipse Enterprise Workbench

Version: 5.0.1 GA
Build id: 20060810-5.0.1-GA

Eclipse Graphical Editing Framework

Version: 3.2.0.v20060626
Build id: 20060627-0816

Eclipse Platform

Version: 3.2.1.r321_v20060921-b_XVA-INSQSyMtx
Build id: M20060629-1905

Eclipse RCP

Version: 3.2.1.r321_v20060801-2ekW2BxmcpPUOoq
Build id: M20060629-1905

Eclipse Java Development Tools

Version: 3.2.1.r321_v20060905-R4CM1Znkvre9wC-
Build id: M20060921-0945

Eclipse Plug-in Development Environment

Version: 3.2.1.r321_v20060823-6vYLLdQ3Nk8DrFG
Build id: M20060921-0945

Eclipse Project SDK

Version: 3.2.1.r321_v20060801-tQ1w49KnTArT0FZ
Build id: M20060921-0945

The SQL server is configured to allow TCPIP (default port 1433). I have tried to set the authentication to mixed mode (Configurfation Properties, Security tab), but the setting always reverts back to Windows Only. Not sure if this has anything to do with the error.

I am using the msbase and mssqlserver jars (the newest ones I can find for SQL 2000 – 4/21/2004).

The URL is:

jdbc:microsoft:sqlserver://192.168.0.117

where the IP is the internal IP for the Windows server.

driver name:

Microsoft SQL Server

driver class name:

com.microsoft.jdbc.sqlserver.SQLServerDriver

[ksgetting]

I found a way (http://support.microsoft.com/kb/285097) to change the registry which allowed me to manually change the Authentication to mixed mode. However, the same Null pointer error still occurs.

[ksgetting]

Looks like I needed to add the 3rd jar (in my driver properties) to make it work. I was missing msutil.jar.

[Riyad Kalla]

Did you get things working? We surely appreciate you following up with your findings incase other users are having similar issues.

[Author]

Posts