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 94720

Summary:	Suggest DataBinding expressions be validated, when SQL changed
Product:	obsolete	Reporter:	Chary Kanaparthi <charyk>
Component:	visualweb	Assignee:	John Baker <jbaker>
Status:	NEW ---
Severity:	blocker	CC:	wjprakash
Priority:	P2
Version:	5.x
Hardware:	All
OS:	Windows XP
Issue Type:	ENHANCEMENT	Exception Reporter:

Description Chary Kanaparthi 2007-02-06 19:34:34 UTC

Thrsher ML RC3

From the forum thread:
https://feedbackprograms.sun.com/project/forum/post.html?cap={3F4DA363-16D3-4D4C-920C-992ECB054B6D}&forid={CC6B8562-F896-4A44-ACB6-4684BDD05E19}&topid={95A27CED-DA35-41E8-8966-203CF76F0319}&tp=1

- create new project
- drop a table component
- drop TRAVEL.PERSON onto table
- Change the default query to use UNION clause as in:
SELECT ALL TRAVEL.PERSON.PERSONID, TRAVEL.PERSON.NAME, 
TRAVEL.PERSON.JOBTITLE, TRAVEL.PERSON.FREQUENTFLYER 
FROM TRAVEL.PERSON WHERE PERSONID=1
UNION 
SELECT ALL TRAVEL.PERSON.PERSONID, TRAVEL.PERSON.NAME, 
TRAVEL.PERSON.JOBTITLE, TRAVEL.PERSON.FREQUENTFLYER 
FROM TRAVEL.PERSON  WHERE PERSONID=2 
- Run Project
It gives:
[#|2006-01-23T10:11:58.171-0800|SEVERE|sun-appserver-pe8.1_02|javax.enterprise.system.container.web|_ThreadID=13;|StandardWrapperValve[Faces
Servlet]: Servlet.service() for servlet Faces Servlet threw exception
com.sun.rave.web.ui.appbase.ApplicationException:
org.apache.jasper.JasperException: java.lang.IllegalArgumentException:
PERSON.PERSONID
        at
com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.destroy(ViewHandlerImpl.java:601)
        at
com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.java:316)
        at
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)
        at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:221)
        at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
        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.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
        at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)
        at
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:257)
        at
org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55)
        at
org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:161)
        at java.security.AccessController.doPrivileged(Native Method)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
        at com.sun.rave.web.ui.util.UploadFilter.doFilter(UploadFilter.java:194)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:210)
        at
org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55)
        at
org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:161)
        at java.security.AccessController.doPrivileged(Native Method)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:263)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
        at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:225)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:173)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:132)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933)
        at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:185)
        at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:653)
        at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:534)
        at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.doTask(ProcessorTask.java:403)
        at
com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:55)
Caused by: javax.faces.FacesException: org.apache.jasper.JasperException:
java.lang.IllegalArgumentException: PERSON.PERSONID
        at
com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:327)
        at
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)
        at
com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.java:311)
        ... 39 more
*** (#1 of 1): 2006-01-23 10:36:14 PST sakthivel
Evaluation :
-----------

We don't have a common mechanism to validate the binding when corresponding data
provider changes in the background. There are other bugs reported because of
this problem.

For mako we should look in to this issue
*** (#1 of 1): 2006-02-24 12:29:47 PST winston

Comment 1 _ jimdavidson 2007-03-06 18:13:18 UTC

Winston, this is filed as a Defect.  Should it be an enhancement?

Exactly what should we be doing when the SQL is changed?

Comment 2 Jayashri Visvanathan 2007-08-01 20:04:40 UTC

Jim,
 Why is this marked incomplete ? Per Winston's comments, this is something we should fix in NetBeans 6.0.
I am removing the keyword for now.

Comment 3 _ jimdavidson 2007-08-02 00:07:33 UTC

Marking as enhancement.