This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 111674 - Query Editor is not available - NullPointerException
Summary: Query Editor is not available - NullPointerException
Status: VERIFIED WORKSFORME
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 5.x
Hardware: All All
: P1 blocker (vote)
Assignee: _ jimdavidson
URL:
Keywords:
: 111671 (view as bug list)
Depends on:
Blocks:
 
Reported: 2007-08-01 19:21 UTC by _ alexpetrov
Modified: 2007-08-02 15:19 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
messages.log (29.65 KB, text/plain)
2007-08-01 19:22 UTC, _ alexpetrov
Details
screenshot (12.14 KB, image/jpeg)
2007-08-01 19:22 UTC, _ alexpetrov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description _ alexpetrov 2007-08-01 19:21:51 UTC
NB 5.5.1 (0704122300), VWP 5.5.1 (070516_2), C/C++ (20070731)
j2sdk 1.6.0_02
WinXP

1. Connect to DB Derby Travel
2. Create new VWP project (Sun Application Server 9, Java EE 5, Java BluePrints)
3. DnD JSF component Table on Designer, DnD DB table TRIP on it.
Result:
- the appropriate Row Set and Data Provider have been created

4. Use popup menu item "Edit SQL Statement" for a created tripRowSet

Result:
- error-dialog will appear (see an attached screenshot).
- NullPointerException will appear in the messages.log (see an attached file):
java.lang.NullPointerException
	at com.sun.rave.queryeditor.querybuilder.QueryBuilder.openCustomizerPanel(QueryBuilder.java:399)
	at com.sun.rave.dataconnectivity.customizers.SqlCommandCustomizer.getCustomizerPanel(SqlCommandCustomizer.java:78)
	at com.sun.rave.insync.live.DesignBeanNode.invokeCustomizer(DesignBeanNode.java:1165)
	at com.sun.rave.insync.live.CustomizeAction.performAction(CustomizeAction.java:73)
	at org.openide.util.actions.NodeAction$DelegateAction$1.run(NodeAction.java:537)
	at org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:53)
	at org.openide.util.actions.NodeAction$DelegateAction.actionPerformed(NodeAction.java:533)
	at com.sun.rave.insync.live.CustomizeAction$DelegateAction.actionPerformed(CustomizeAction.java:106)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
	at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1216)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1257)
	at java.awt.Component.processMouseEvent(Component.java:6038)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
	at java.awt.Component.processEvent(Component.java:5803)
	at java.awt.Container.processEvent(Container.java:2058)
	at java.awt.Component.dispatchEventImpl(Component.java:4410)
	at java.awt.Container.dispatchEventImpl(Container.java:2116)
	at java.awt.Component.dispatchEvent(Component.java:4240)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
	at java.awt.Container.dispatchEventImpl(Container.java:2102)
	at java.awt.Window.dispatchEventImpl(Window.java:2429)
	at java.awt.Component.dispatchEvent(Component.java:4240)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
[catch] at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Comment 1 _ alexpetrov 2007-08-01 19:22:21 UTC
Created attachment 46024 [details]
messages.log
Comment 2 _ alexpetrov 2007-08-01 19:22:58 UTC
Created attachment 46025 [details]
screenshot
Comment 3 _ alexpetrov 2007-08-01 19:43:03 UTC
j2sdk 1.5.0_12 - the same result.
Comment 4 _ jimdavidson 2007-08-01 22:49:32 UTC
*** Issue 111671 has been marked as a duplicate of this issue. ***
Comment 5 _ jimdavidson 2007-08-01 22:53:34 UTC
These are two instances of the same problem.  As the error message indicates, the CachedRowSet can't get a connection to
the database, because the driver class can't be found.

This is a pretty standard scenario, and I just tried it successfully.  

Please clean out your userdir, and try again.  If you can reproduce the bug, reopen the issue, and include information
about the exact version of SJSAS9 you are using; also include the list of files in the jdbc-drivers directory.
Comment 6 _ jimdavidson 2007-08-02 00:51:47 UTC
I missed the part about the C/C++ pack.  Since I can't run that on my Mac, I can't test it. 

If you can reproduce the problem, please reopen the bug, with as much information as possible.
Comment 7 _ krystyna 2007-08-02 01:00:52 UTC
Jim, here is the link to the installers - there is one for mac:
http://smetiste.czech.sun.com/builds/cnd/5.5.1u1/Build070731/installers/
Comment 8 _ jimdavidson 2007-08-02 07:36:58 UTC
I just tested this on both Windows and Mac.  I installed NB5.5.1, VWP, and C/C++.  Followed the instructions in desc1.

Everything worked fine.

If you can reproduce, please provide as much information as possible.
Comment 9 _ alexpetrov 2007-08-02 15:19:21 UTC
NB 5.5.1 (0704122300), VWP 5.5.1 (070516_2), C/C++ Pack 5.5.1 u1 (20070731)
j2sdk 1.6.0_02
WinXP

Not reproduced.

The reason was:
When NB 5.5.1 FCS VWP 5.5.1 RC2 starts for the 1st time (directory <user_dir>/.netbeans/5.5.1 isn't exist), 
it doesn't recognize DB settings (JDBC driver path,...), which an user defines in this 1st session. 
This causes java.lang.ClassNotFoundException: org.apache.derby.jdbc.ClientDriver.

DB settings are stored in:
<user_dir>/.netbeans/5.5.1/jdbc-drivers/datasourceconfig.xml  
<user_dir>/.netbeans/5.5.1/config/Databases/JDBCDrivers/org_apache_derby_jdbc_ClientDriver.xml

When NB 5.5.1 FCS VWP 5.5.1 RC2 starts next time, it reads stored DB settings (JDBC driver path,...) and 
works with Row Set properly.