Java Development Tools

JDev 10.1.3.1.0, ADF/BC

I am receiving the "Missing IN or OUT parameter at index:: 1" when deployed to 10iAS, which I didn't receive at all during testing through embedded OC4J. After reading several threads I set the configuration for jbo.ampool.doampooling to false. Now I get the error in embedded OC4J, which is great for debugging. All I have is an expert mode view object with a singe bound variable (TheUserID). In a jspx binding I have an ExecuteWithParams action passing in a ${userInfo.userId} bean variable and then an invoke Action calling this action. I use this technique all over the system to only show the user information that he has created. What is wrong with this process. Of course now I'm in a panic because I thought everything was cool (running from embedded), arrrrgh! Following is my debug info. One last thing if I take the bound variable out and have an Execute action (hard code a user in the vo) all works as expected.
Thanks,
Doug


06/11/30 10:47:10 [761] Resolving VO:ActiveSitesForUser for iterator binding:ActiveSitesForUserIterator
06/11/30 10:47:10 [762] DCUtil, returning:oracle.adfinternal.view.faces.model.binding.FacesCtrlListBinding, for ActiveSitesForUser
06/11/30 10:47:10 [763] Changing iterator range size from :1 to :10
06/11/30 10:47:10 [764] Column count: 3
06/11/30 10:47:10 [765] ViewObject: ActiveSitesForUser close prepared statements...
06/11/30 10:47:10 [766] ViewObject: ActiveSitesForUser Created new QUERY statement
06/11/30 10:47:10 [767] ActiveSitesForUser>#q computed SQLStmtBufLen: 333, actual=196, storing=226
06/11/30 10:47:10 [768] SELECT * FROM (select s.site_name, s.site_id
from crf_Site_users u,
crf_sites s
where user_id = :TheUserId
and u.site_id = s.site_id
and s.enabled_flag = 'Yes') QRSLT ORDER BY SITE_NAME
06/11/30 10:47:10 [769] Bind params for ViewObject: ActiveSitesForUser
06/11/30 10:47:10 [770] ViewObject: ActiveSitesForUser close single-use prepared statements
06/11/30 10:47:10 [771] QueryCollection.executeQuery failed...
06/11/30 10:47:10 [772] java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1566)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2996)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:856)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:665)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3657)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:742)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:891)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:805)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:799)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3577)
at oracle.adf.model.bc4j.DCJboDataControl.executeIteratorBindingIfNeeded(DCJboDataControl.java:827)
at oracle.adf.model.binding.DCIteratorBinding.executeQueryIfNeeded(DCIteratorBinding.java:1798)
at oracle.adf.model.binding.DCBindingContainer.internalRefreshControl(DCBindingContainer.java:2494)
at oracle.adf.model.binding.DCBindingContainer.refresh(DCBindingContainer.java:2260)
at oracle.adf.controller.v2.lifecycle.PageLifecycleImpl.prepareModel(PageLifecycleImpl.java:99)
at oracle.adf.controller.faces.lifecycle.FacesPageLifecycle.prepareModel(FacesPageLifecycle.java:73)
at abbott.crf.view.frameworkExt.CRFPageLifecycle.prepareModel(CRFPageLifecycle.java:324)
at oracle.adf.controller.v2.lifecycle.Lifecycle$8.execute(Lifecycle.java:210)
at oracle.adf.controller.v2.lifecycle.Lifecycle.executePhase(Lifecycle.java:116)
at oracle.adf.controller.faces.lifecycle.ADFPhaseListener.mav$executePhase(ADFPhaseListener.java:33)
at oracle.adf.controller.faces.lifecycle.ADFPhaseListener$1.before(ADFPhaseListener.java:416)
at oracle.adf.controller.faces.lifecycle.ADFPhaseListener.beforePhase(ADFPhaseListener.java:81)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:228)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:137)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:214)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfFacesFilterImpl.java:367)
at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:336)
at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:196)
at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:105)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:167)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:619)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)