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 - Suggest DataBinding expressions be validated, when SQL changed
Summary: Suggest DataBinding expressions be validated, when SQL changed
Status: NEW
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 5.x
Hardware: All Windows XP
: P2 blocker (vote)
Assignee: John Baker
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-02-06 19:34 UTC by Chary Kanaparthi
Modified: 2008-02-27 07:46 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

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