Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 312881

Summary:	NPE in DataSourceExplorer
Product:	[Tools] Data Tools	Reporter:	Dan Siviter <dansiviter>
Component:	SQL Results View	Assignee:	Brian Payton <bpayton>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	P3	CC:	bpayton
Version:	1.0
Target Milestone:	1.8.2
Hardware:	PC
OS:	Windows XP
Whiteboard:

Description Dan Siviter

2010-05-14 05:12:19 EDT

When using Sybase ASE (driver jConnect 6.0) within DataSourceExplorer. If using empty 'database' in the login credentials to allow access to all databases held on a host, you are unable to list the tables due to NPE reported below. When a 'database' is specified then listing the tables works fine. The lack of a 'database' name may be a red herring, but it's the only field I have removed or reintroduced to be able to replicate the error.

What steps will reproduce the problem?
1. Create new Database Connection (I used Sybase, but it may occur with others)
2. Fill in the Connection Properties leaving the 'database' field empty and save the new connection.
3. Navigate through the Database Connection tree through 'Databases' down until the 'Tables' node. Clicking expand on the 'Tables' node causes the error.
4. Open the Properties editor on the Database Connection.
5. Specify a 'database' name and save the connection.
6. Navigating through the Database Connection down to the 'Tables' node now works as expected.

It seems the version of org.eclipse.datatools.sqltools.result is 1.0.0v200906022302.

Bug 296154 and bug 292223 may be related, however there is no mention of the 'database' name being the problem. 

-- Error Details --
Date: Fri May 14 09:32:35 BST 2010
Message: An internal error occurred during: "SQL Statement Execution".
Severity: Error
Product: Eclipse 1.2.2.20100122-1337 (org.eclipse.epp.package.jee.product)
Plugin: org.eclipse.core.jobs
Session Data:
eclipse.buildId=unknown
java.version=1.6.0_16
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_GB
Framework arguments:  -product org.eclipse.epp.package.jee.product
Command-line arguments:  -os win32 -ws win32 -arch x86 -product org.eclipse.epp.package.jee.product


Exception Stack Trace:
java.lang.NullPointerException
at org.eclipse.datatools.sqltools.result.ResultsViewAPI.saveParentElapseTime(ResultsViewAPI.java:725)
at org.eclipse.datatools.sqltools.sqleditor.result.GroupSQLResultRunnable.run(GroupSQLResultRunnable.java:307)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)