Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 312881 - NPE in DataSourceExplorer
Summary: NPE in DataSourceExplorer
Status: NEW
Alias: None
Product: Data Tools
Classification: Tools
Component: SQL Results View (show other bugs)
Version: 1.0   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: 1.8.2   Edit
Assignee: Brian Payton CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-05-14 05:12 EDT by Dan Siviter CLA
Modified: 2010-09-22 19:31 EDT (History)
1 user (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dan Siviter CLA 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)