ENV: Jdev1012+JHS1012(evaluation version)+MySql5.0 Or ORACLE 10.1.2
ERR INFO:
20:42:22 DEBUG (JhsDataAction) -Executing action /main
20:42:22 DEBUG (JhsDataAction) -Created searchBean map and stored on session
20:42:22 DEBUG (JhsDataAction) -Created new searchBean for SysRoleFirstLevelFuncUIModel and added to quick search bean map
20:42:22 DEBUG (JhsDataAction) -Stored searchBean for SysRoleFirstLevelFuncUIModel on request
[red]
20:42:22 DEBUG (JhsDataAction) -ViewObject SysRoleFirstLevelFuncView1: value of bind param 0 set to S001
20:42:22 DEBUG (JhsDataAction) -ViewObject SysRoleFirstLevelFuncView1: executing query, bind parameter values have changed
05/11/22 20:42:23 java.sql.SQLException: No value specified for parameter 1[red]
05/11/22 20:42:23 at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1253)
05/11/22 20:42:23 at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1201)
05/11/22 20:42:23 at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:966)
05/11/22 20:42:23 at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:691)
05/11/22 20:42:23 at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:547)
05/11/22 20:42:23 at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3354)
05/11/22 20:42:23 at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:667)
05/11/22 20:42:23 at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:773)
05/11/22 20:42:23 at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:710)
05/11/22 20:42:23 at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3294)
05/11/22 20:42:23 at oracle.adf.model.bc4j.DCJboDataControl.executeIteratorBindingIfNeeded(DCJboDataControl.java:803)
05/11/22 20:42:23 at oracle.adf.model.binding.DCIteratorBinding.executeQueryIfNeeded(DCIteratorBinding.java:1587)
05/11/22 20:42:23 at oracle.adf.model.binding.DCBindingContainer.refreshControl(DCBindingContainer.java:1544)
05/11/22 20:42:23 at oracle.jheadstart.controller.strutsadf.action.JhsDataAction.applyIterBindParams(JhsDataAction.java:2785)
05/11/22 20:42:23 at oracle.jheadstart.controller.strutsadf.action.JhsDataAction.prepareModel(JhsDataAction.java:3136)
05/11/22 20:42:23 at oracle.adf.controller.struts.actions.DataAction.prepareModel(DataAction.java:486)
05/11/22 20:42:23 at oracle.adf.controller.lifecycle.PageLifecycle.handleLifecycle(PageLifecycle.java:105)
05/11/22 20:42:23 at oracle.adf.controller.struts.actions.StrutsUixLifecycle.handleLifecycle(StrutsUixLifecycle.java:70)
05/11/22 20:42:24 at oracle.adf.controller.struts.actions.DataAction.handleLifecycle(DataAction.java:223)
05/11/22 20:42:24 at oracle.jheadstart.controller.strutsadf.action.JhsDataAction.handleLifecycle(JhsDataAction.java:389)
05/11/22 20:42:24 at oracle.adf.controller.struts.actions.DataAction.execute(DataAction.java:155)
05/11/22 20:42:24 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
05/11/22 20:42:24 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
05/11/22 20:42:24 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1485)
05/11/22 20:42:24 at oracle.jheadstart.controller.strutsadf.JhsActionServlet.process(JhsActionServlet.java:127)
05/11/22 20:42:24 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:527)
05/11/22 20:42:24 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
05/11/22 20:42:24 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
05/11/22 20:42:24 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
05/11/22 20:42:24 at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
05/11/22 20:42:24 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663)
05/11/22 20:42:24 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
05/11/22 20:42:24 at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:222)
05/11/22 20:42:24 at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
05/11/22 20:42:24 at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
05/11/22 20:42:24 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
05/11/22 20:42:24 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1485)
05/11/22 20:42:24 at oracle.jheadstart.controller.strutsadf.JhsActionServlet.process(JhsActionServlet.java:127)
05/11/22 20:42:24 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:527)
05/11/22 20:42:24 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
05/11/22 20:42:24 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
05/11/22 20:42:24 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
05/11/22 20:42:24 at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
05/11/22 20:42:24 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
05/11/22 20:42:24 at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:239)
05/11/22 20:42:24 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
05/11/22 20:42:24 at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:239)
05/11/22 20:42:24 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
05/11/22 20:42:24 at oracle.jheadstart.controller.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:172)
05/11/22 20:42:24 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:659)
05/11/22 20:42:24 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
05/11/22 20:42:24 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
05/11/22 20:42:24 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:285)
05/11/22 20:42:24 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:126)
05/11/22 20:42:24 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
05/11/22 20:42:24 at java.lang.Thread.run(Thread.java:534)
the SQL for my VO is :
SysRoleFirstLevelFuncView :
SelectList="SysTabFunction.id,
SysTabFunction.name,
SysTabFunction.address,
SysTabFunction.parent_func,
SysTabRoleRight.ROLE_ID,
SysTabRoleRight.FUNC_ID,
SysTabFunction.disp_order"
FromList="SYS_TAB_FUNCTION SysTabFunction, SYS_TAB_ROLE_RIGHT SysTabRoleRight"
Where="SysTabFunction.Level=1 and SysTabFunction.id=SysTabRoleRight.FUNC_ID And SysTabRoleRight.Access_Type='Y' And SysTabRoleRight.Role_Id=?
the Action In my struts-config.xml is :
<action path="/main" input="/WEB-INF/page/main.uix" type="oracle.jheadstart.controller.strutsadf.action.JhsDataAction" className="oracle.jheadstart.controller.strutsadf.action.JhsDataActionMapping" parameter="/WEB-INF/page/main.uix" name="DataForm" unknown="false">
<set-property property="modelReference" value="SysRoleFirstLevelFuncUIModel"/>
]red]
<set-property property="bindParams" value="SysRoleFirstLevelFuncTreeIterator=${sessionScope.UserInfo.roleId}"/>[red] <forward name="SysRoleSecondLevelFunc2" path="/StartSysRoleSecondLevelFunc2.do"/>
</action>
we can find the parameter is set in the error message.is it a bug?
thanks in advance
best regards.