validation not working

hi am trying to do this validation https://mjabr.wordpress.com/2011/05/27/how-to-create-a-custom-jsf-validator/
but am geting this error
<oracle.adf.model> <DCJboDataControl> <initializeApplicationModule> <[677] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate>
<oracle.adf.model> <DCBindingContainerState> <validateToken> <[678] Process BindingContainer state token(decompressed state):BCST:=0%V%=N%R=0%taskflowcal1=BCST:=0%V%=N%R=1%view_pageDefs_CalmainPageDef_WEB_INF_task_flow_cal_xml_task_flow_cal=BCST:=0%V%=NCalMain1Iterator=-D-,,,>
<oracle.adf.model> <DCBindingContainer> <internalRefreshControl> <[679] **** refreshControl() for BindingContainer :view_pageDefs_CalmainPageDef_WEB_INF_task_flow_cal_xml_task_flow_cal>
<oracle.adf.model> <DCBindingContainerState> <validateToken> <[680] Process BindingContainer state token(decompressed state):BCST:=0%V%=N%R=0%taskflowcal1=BCST:=0%V%=N%R=1%view_pageDefs_CalmainPageDef_WEB_INF_task_flow_cal_xml_task_flow_cal=BCST:=0%V%=NCalMain1Iterator=-D-,,,>
<oracle.adf.model> <DCExecutableBinding> <refreshIfNeeded> <[681] Invoke refresh for :CalMain1Iterator>
<oracle.adf.model> <DCIteratorBinding> <refresh> <[682] Executing and syncing on IteratorBinding.refresh from :CalMain1Iterator>
<oracle.adf.model> <DCUtil> <findSpelObject> <[683] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for AppModuleTstDataControl>
<oracle.adf.model> <DCJboDataControl> <initializeApplicationModule> <[684] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate>
<oracle.adf.model> <ApplicationPoolImpl> <reuseReferencedInstance> <[685] Reusing a cached session application module instance>
<oracle.adf.model> <DCIteratorBinding> <getViewObject> <[686] Resolving VO:CalMain1 for iterator binding:CalMain1Iterator>
<oracle.adf.model> <DebugDiagnostic> <print> <[687] DBG: beforeActionPerformed :signOnId>
<oracle.adf.model> <DCUtil> <findSpelObject> <[688] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for AppModuleTstDataControl>
<oracle.adf.model> <JUCtrlActionBinding> <doIt> <[689] Invoke method Action:signOnId, fullname:data.view_erdlinkPageDef.taskflowcal1.view_pageDefs_CalmainPageDef_WEB_INF_task_flow_cal_xml_task_flow_cal.signOnId>
<oracle.adf.model> <DebugDiagnostic> <print> <[690] DBG: DataControl:Looking for :DataProvider>
<oracle.adf.model> <DCInvokeMethod> <invokeMethod> <[691] DCInvokeMethod:Invoking AppModuleTstDataControl.dataProvider.signOnId()>
<oracle.adf.model> <ViewObjectImpl> <createViewCriteriaManagerImpl> <[692] ViewObject:_LOCAL_VIEW_USAGE_model_CalMain_UntLov1 creating ViewCriteriaManager instance.>
<oracle.adf.model> <ViewObjectImpl> <createViewCriteriaManagerImpl> <[693] ViewObject:_LOCAL_VIEW_USAGE_model_CalMain_ViewU1 creating ViewCriteriaManager instance.>
<oracle.adf.model> <ViewObjectImpl> <createViewCriteriaManagerImpl> <[694] ViewObject:_LOCAL_VIEW_USAGE_model_CalMain_ViewLoc1 creating ViewCriteriaManager instance.>
<oracle.adf.model> <DebugDiagnostic> <print> <[695] DBG: afterActionPerformed :signOnId>
<oracle.adf.model> <DCBindingContainer> <internalRefreshControl> <[696] **** refreshControl() for BindingContainer :view_pageDefs_CalmainPageDef_WEB_INF_task_flow_cal_xml_task_flow_cal>
<oracle.adf.model> <DCUtil> <findSpelObject> <[697] DCUtil, returning:oracle.jbo.uicli.binding.JUFormBinding, for view_pageDefs_CalmainPageDef_WEB_INF_task_flow_cal_xml_task_flow_cal>
<oracle.adf.model> <DCIteratorBinding> <releaseDataInternal> <[698] Releasing iterator binding:CalMain1Iterator>
<oracle.adf.model> <DCIteratorBinding> <releaseDataInternal> <[699] Releasing iterator binding:CalMain1Iterator>
<oracle.adf.model> <DCIteratorBinding> <releaseDataInternal> <[700] Releasing iterator binding:CalMain1Iterator>



i put this in my java option
-Djbo.debugoutput=console


 /*public void validate1(FacesContext facesContext,UIComponent uIComponent,Object object)throws ValidatorException
 {
 //add your validation logic here
  String phone = object.toString();
  if (phone.length() < 9) {
  FacesMessage fm = new FacesMessage("Phone number should be at least 9 digits");
 throw new ValidatorException(fm);
  }
  }*/
}


package view;

import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.faces.validator.Validator;
import javax.faces.validator.ValidatorException;

import oracle.adf.model.BindingContext;

import oracle.binding.BindingContainer;
import oracle.binding.OperationBinding;

import oracle.jbo.JboException;
import oracle.jbo.Row;
import oracle.jbo.ViewObject;

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import java.util.HashMap;


import javax.faces.application.FacesMessage;

import model.common.AppModuleTst;

import oracle.jbo.JboException;
import oracle.jbo.Row;
import oracle.jbo.ViewObject;
import oracle.jbo.server.ApplicationModuleImpl;

import oracle.jbo.server.ViewObjectImpl;

//import sun.security.validator.ValidatorException;

import utils.system;

public class SignOnValidation implements Validator {
    public SignOnValidation() {
        super();
    }

    public void validate(FacesContext facesContext, UIComponent uIComponent,
                         Object object) throws ValidatorException {
        
        String inputString = object.toString().toUpperCase();
        
        
        OperationBinding oBindings = getOperationBinding("signOnId");
        
        oBindings.execute();
        FacesContext.getCurrentInstance().renderResponse();
    }
    public static OperationBinding getOperationBinding(String pOperationName) {
        BindingContainer bc =
            BindingContext.getCurrent().getCurrentBindingsEntry();
        return bc.getOperationBinding(pOperationName);
    }

Open in new window

   
this is how i call my procedure
procedure SignId(p_signid varchar2, proc_err_msg varchar2) is
chalie001Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

girionisCommented:
This is not the error message, but the logs from the operation. Do you get any exception? If yes, can you post it?
chalie001Author Commented:
no i don't get exception at all
girionisCommented:
So when you say it's not working what do you mean?
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

chalie001Author Commented:
am getting this error
<oracle.adf.view> <LifecycleImpl> <_handleException> <ADF_FACES-60098:Faces lifecycle receives unhandled exceptions in phase PROCESS_VALIDATIONS 3>


javax.faces.el.EvaluationException: java.lang.NullPointerException

  at org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:58)

  at org.apache.myfaces.trinidad.component.UIXEditableValue.validateValue(UIXEditableValue.java:422)

  at org.apache.myfaces.trinidad.component.UIXEditableValue.validate(UIXEditableValue.java:181)

  at org.apache.myfaces.trinidad.component.UIXEditableValue._executeValidate(UIXEditableValue.java:616)

  at org.apache.myfaces.trinidad.component.UIXEditableValue.processValidators(UIXEditableValue.java:304)

  at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl$ProcessValidationsCallback.invokeContextCallback(LifecycleImpl.java:1675)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1661)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnNamingContainerComponent(UIXComponentBase.java:1625)

  at oracle.adf.view.rich.component.fragment.UIXRegion.invokeOnComponent(UIXRegion.java:713)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at oracle.adf.view.rich.component.rich.RichDocument.invokeOnComponent(RichDocument.java:170)

  at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:720)

  at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:678)

  at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:467)

  at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:219)

  at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)

  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:211)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:133)

  at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:478)

  at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

  at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:478)

  at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:303)

  at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:208)

  at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138)

  at java.security.AccessController.doPrivileged(Native Method)

  at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

  at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464)

  at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121)

  at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211)

  at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

Caused by: java.lang.NullPointerException

  at view.SignOnValidation.SignIdValidator(SignOnValidation.java:81)

  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:597)

  at com.sun.el.parser.AstValue.invoke(AstValue.java:187)

  at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)

  at org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:53)

  ... 65 more

<oracle.adf.view> <XmlErrorHandler> <handleError> <ADF_FACES-60096:Server Exception during PPR, #1>

javax.servlet.ServletException

  at javax.faces.webapp.FacesServlet.service(FacesServlet.java:277)

  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:211)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:133)

  at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:478)

  at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

  at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:478)

  at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:303)

  at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:208)

  at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138)

  at java.security.AccessController.doPrivileged(Native Method)

  at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

  at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464)

  at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121)

  at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211)

  at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

Caused by: java.lang.NullPointerException

  at view.SignOnValidation.SignIdValidator(SignOnValidation.java:81)

  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:597)

  at com.sun.el.parser.AstValue.invoke(AstValue.java:187)

  at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)

  at org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:53)

  at org.apache.myfaces.trinidad.component.UIXEditableValue.validateValue(UIXEditableValue.java:422)

  at org.apache.myfaces.trinidad.component.UIXEditableValue.validate(UIXEditableValue.java:181)

  at org.apache.myfaces.trinidad.component.UIXEditableValue._executeValidate(UIXEditableValue.java:616)

  at org.apache.myfaces.trinidad.component.UIXEditableValue.processValidators(UIXEditableValue.java:304)

  at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl$ProcessValidationsCallback.invokeContextCallback(LifecycleImpl.java:1675)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1661)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnNamingContainerComponent(UIXComponentBase.java:1625)

  at oracle.adf.view.rich.component.fragment.UIXRegion.invokeOnComponent(UIXRegion.java:713)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)

  at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)

  at oracle.adf.view.rich.component.rich.RichDocument.invokeOnComponent(RichDocument.java:170)

  at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:720)

  at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:678)

  at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:467)

  at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:219)

  at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
this is the code am using
public String signOnId(String  signid){ 
              ViewObject svo = this.findViewObject("CalMain1"); 
              String err_msa = null;
              Row row = svo.first(); 
              signid = getSignid(); 
                    if(row!=null){ 
                    if(row.getAttributeIndexOf("SignId")!=-1){ 
                    int index=row.getAttributeIndexOf("SignId"); 
                    Object[] values=row.getAttributeValues(); 
                    if(values[index]!=null){ 
                    //signid = (String)row.getAttribute("SignId"); 
              callPerformSdmsLogon("calmain.SignId(?,?)", new Object[] { signid.toUpperCase(),err_msa }); 
                } 
                } 
                    
                }
    return err_msa;
            } 
     
     
        
        public void SignIdValidator(FacesContext facesContext, UIComponent uIComponent, 
                                Object object) { 
            String msg =null; 
              OperationBinding oBindings = getOperationBinding("signOnId"); 
              oBindings.getParamsMap().put("signid",object);   
              oBindings.execute(); 
    String msg = oBindings.getResult().toString();
              if(msg != null) { 
                FacesMessage fm = new FacesMessage(msg); 
                throw new ValidatorException(fm); 
            }
 

Open in new window

girionisCommented:
Can you post the SignOnValidation.java file? All of it, and specifically line 81, that's where the error occurs.
chalie001Author Commented:
this is where the error is check in the above code
String msg = oBindings.getResult().toString();
chalie001Author Commented:
this is the whole class
package view;

import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.faces.validator.Validator;
import javax.faces.validator.ValidatorException;

import oracle.adf.model.BindingContext;

import oracle.binding.BindingContainer;
import oracle.binding.OperationBinding;

import oracle.jbo.JboException;
import oracle.jbo.Row;
import oracle.jbo.ViewObject;

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import java.util.HashMap;


import java.util.Map;

import javax.faces.application.FacesMessage;

import model.common.AppModuleTst;

import oracle.jbo.JboException;
import oracle.jbo.Row;
import oracle.jbo.ViewObject;
import oracle.jbo.server.ApplicationModuleImpl;

import oracle.jbo.server.ViewObjectImpl;

//import sun.security.validator.ValidatorException;

import utils.system;

public class SignOnValidation implements Validator {
    private Map<String, Object> parameterMap = new HashMap<String, Object>();

    public SignOnValidation() {
        super();
    }

    
     

    public static OperationBinding getOperationBinding(String pOperationName) {
        BindingContainer bc =
            BindingContext.getCurrent().getCurrentBindingsEntry();
        return bc.getOperationBinding(pOperationName);
    }
    
    public void SignIdValidator(FacesContext facesContext, UIComponent uIComponent, 
                                  Object object) { 
             
                OperationBinding oBindings = getOperationBinding("signOnId"); 
                oBindings.getParamsMap().put("signid",object);   
                oBindings.execute(); 
                
      String msg = oBindings.getResult().toString();
      
                if(msg != null) { 
                  FacesMessage fm = new FacesMessage(msg); 
                  throw new ValidatorException(fm); 
              }
			  }

Open in new window

girionisCommented:
Are you sure this is the whole class? The error indicates

  at view.SignOnValidation.SignIdValidator(SignOnValidation.java:81)

which means that the line 81 is throwing the exception. What is this line?
chalie001Author Commented:
yes is in this method
public void SignIdValidator(FacesContext facesContext, UIComponent uIComponent, 
                                  Object object) { 
             
                OperationBinding oBindings = getOperationBinding("signOnId"); 
                oBindings.getParamsMap().put("signid",object);   
                oBindings.execute(); 
                
      [b]String msg = oBindings.getResult().toString();[/b]
      
                if(msg != null) { 
                  FacesMessage fm = new FacesMessage(msg); 
                  throw new ValidatorException(fm); 
              }
			  }

Open in new window

girionisCommented:
this is where the error is check in the above code
String msg = oBindings.getResult().toString();  

Then the oBindings.getResult() is null. I suggest you change the following statement

String msg = oBindings.getResult().toString();
if(msg != null) { 
                  FacesMessage fm = new FacesMessage(msg); 
                  throw new ValidatorException(fm); 
              }

Open in new window


to

Object o = oBindings.getResult();
if(o != null) { 
   String msg = o.toString();
                  FacesMessage fm = new FacesMessage(msg); 
                  throw new ValidatorException(fm); 
              }

Open in new window

chalie001Author Commented:
am getting this error now
<oracle.adf.model> <ViewXmlImpl> <parse> <PARSE_VIEW_PAGE_NAME_FAILED>
<oracle.adf.model> <ActivityXmlImpl> <parse> <ADFc: /WEB-INF/adfc-config.xml: > 
<oracle.adf.model> <ActivityXmlImpl> <parse> <PARSE_ACTIVITY_FAILED_2>
<org.apache.myfaces.trinidadinternal.skin.SkinCSSDocumentHandler> <SkinCSSDocumentHandler> <_parseAgentProperties> <INVALID_AGENT_PROPERTY>
<oracle.adf.common> <ConfigPropsUtil> <validateKey> <The key name must start with ORACLE. and it's length must be less than76 characeters. Also key must be defined in adf-settings.xml ORG.APACHE.MYFACES.TRINIDAD.UIXEDITABLEVALUE.VALIDATE_EMPTY_FIELDS does not satisfy one or more these criteria so returning null value>
<oracle.adf.common> <ConfigPropertyManager> <getPropertyInternal> <The key name must start with ORACLE. and it's length must be less than 76 characeters. Key ORG.APACHE.MYFACES.TRINIDAD.UIXEDITABLEVALUE.VALIDATE_EMPTY_FIELDS is not valid. Not storing the value>
<oracle.adf.controller> <Utils> <buildFacesMessage> <ADF: Adding the following JSF error message: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "shemaname.pakage", line 56
ORA-01403: no data found
ORA-06512: at line 1

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "shemaname.pakage", line 56
ORA-01403: no data found
ORA-06512: at line 1

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
      at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
      at model.AppModuleTstImpl.callPerformSdmsLogon(AppModuleTstImpl.java:96)
      at model.AppModuleTstImpl.signOnId(AppModuleTstImpl.java:178)
      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:597)
      at oracle.adf.model.binding.DCInvokeMethod.invokeMethod(DCInvokeMethod.java:690)
      at oracle.adf.model.binding.DCDataControl.invokeMethod(DCDataControl.java:2181)
      at oracle.adf.model.bc4j.DCJboDataControl.invokeMethod(DCJboDataControl.java:3141)
      at oracle.adf.model.binding.DCInvokeMethod.callMethod(DCInvokeMethod.java:262)
      at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1708)
      at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2188)
      at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:789)
      at oracle.adf.controller.v2.lifecycle.PageLifecycleImpl.executeEvent(PageLifecycleImpl.java:410)
      at oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding._execute(FacesCtrlActionBinding.java:252)
      at oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding.execute(FacesCtrlActionBinding.java:210)
      at view.SignOnValidation.SignIdValidator(SignOnValidation.java:80)
      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:597)
      at com.sun.el.parser.AstValue.invoke(AstValue.java:187)
      at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
      at org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:53)
      at org.apache.myfaces.trinidad.component.UIXEditableValue.validateValue(UIXEditableValue.java:422)
      at org.apache.myfaces.trinidad.component.UIXEditableValue.validate(UIXEditableValue.java:181)
      at org.apache.myfaces.trinidad.component.UIXEditableValue._executeValidate(UIXEditableValue.java:616)
      at org.apache.myfaces.trinidad.component.UIXEditableValue.processDecodes(UIXEditableValue.java:253)
      at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl$ApplyRequestValuesCallback.invokeContextCallback(LifecycleImpl.java:1647)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1661)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnNamingContainerComponent(UIXComponentBase.java:1625)
      at oracle.adf.view.rich.component.fragment.UIXRegion.invokeOnComponent(UIXRegion.java:713)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at oracle.adf.view.rich.component.rich.RichDocument.invokeOnComponent(RichDocument.java:170)
      at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:720)
      at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:678)
      at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:467)
      at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:219)
      at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:211)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:133)
      at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:478)
      at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
      at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:478)
      at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:303)
      at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:208)
      at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138)
      at java.security.AccessController.doPrivileged(Native Method)
      at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
      at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464)
      at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121)
      at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211)
      at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
<oracle.adf.controller> <Utils> <buildFacesMessage> <ADF: Adding the following JSF error message: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "shemaname.pakage", line 56
ORA-01403: no data found
ORA-06512: at line 1

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "schemaname.pakage", line 56
ORA-01403: no data found
ORA-06512: at line 1

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
      at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
      at model.AppModuleTstImpl.callPerformSdmsLogon(AppModuleTstImpl.java:96)
      at model.AppModuleTstImpl.signOnId(AppModuleTstImpl.java:178)
      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:597)
      at oracle.adf.model.binding.DCInvokeMethod.invokeMethod(DCInvokeMethod.java:690)
      at oracle.adf.model.binding.DCDataControl.invokeMethod(DCDataControl.java:2181)
      at oracle.adf.model.bc4j.DCJboDataControl.invokeMethod(DCJboDataControl.java:3141)
      at oracle.adf.model.binding.DCInvokeMethod.callMethod(DCInvokeMethod.java:262)
      at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1708)
      at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2188)
      at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:789)
      at oracle.adf.controller.v2.lifecycle.PageLifecycleImpl.executeEvent(PageLifecycleImpl.java:410)
      at oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding._execute(FacesCtrlActionBinding.java:252)
      at oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding.execute(FacesCtrlActionBinding.java:210)
      at view.SignOnValidation.SignIdValidator(SignOnValidation.java:80)
      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:597)
      at com.sun.el.parser.AstValue.invoke(AstValue.java:187)
      at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
      at org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:53)
      at org.apache.myfaces.trinidad.component.UIXEditableValue.validateValue(UIXEditableValue.java:422)
      at org.apache.myfaces.trinidad.component.UIXEditableValue.validate(UIXEditableValue.java:181)
      at org.apache.myfaces.trinidad.component.UIXEditableValue._executeValidate(UIXEditableValue.java:616)
      at org.apache.myfaces.trinidad.component.UIXEditableValue.processDecodes(UIXEditableValue.java:253)
      at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl$ApplyRequestValuesCallback.invokeContextCallback(LifecycleImpl.java:1647)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1661)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnNamingContainerComponent(UIXComponentBase.java:1625)
      at oracle.adf.view.rich.component.fragment.UIXRegion.invokeOnComponent(UIXRegion.java:713)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1565)
      at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1682)
      at oracle.adf.view.rich.component.rich.RichDocument.invokeOnComponent(RichDocument.java:170)
      at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:720)
      at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:678)
      at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:467)
      at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:219)
      at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:211)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:133)
      at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:478)
      at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
      at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:478)
      at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:303)
      at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:208)
      at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138)
      at java.security.AccessController.doPrivileged(Native Method)
      at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
      at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464)
      at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121)
      at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211)
      at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)


and message is display like this
msg
chalie001Author Commented:
the error is in this method
    protected void callPerformSdmsLogon(String stmt, Object[] bindVars) {
                  PreparedStatement st;
                  st = null;
                  try {
                      // 1. Create a JDBC PreparedStatement for
                      st = getDBTransaction().createPreparedStatement("begin " + stmt + ";end;", 0);

                      if (bindVars != null) {
                          // 2. Loop over values for the bind variables passed in, if any
                          for (int z = 0; z < bindVars.length; z++) {
                              // 3. Set the value of each bind variable in the statement
                              st.setObject(z + 1, bindVars[z]);
                          }
                      }
                      // 4. Execute the statement
                      st.executeUpdate();
                  } catch (SQLException e) {
                      throw new JboException(e);
                  } finally {
                      if (st != null) {
                          try {
                              // 5. Close the statement
                            st.close();
                          } catch (SQLException e) {
                          }
                      }
                  }
              }

Open in new window


in this line st.executeUpdate();
girionisCommented:
This error means that you're trying to pass a value that is too big for the database. E.g. you try to insert a string of 20 characters where the column allows strings with only 10 characters in length. You either have to change the database or see why the value is too big.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chalie001Author Commented:
the error is in this line
  proc_err_msg := 'Invalid sign-on id/password; logon denied..';
        
       and this is how I define my procdure  procedure SignId(p_signid varchar2,proc_err_msg out varchar2) is
chalie001Author Commented:
girionisCommented:
The actual error is in the picture you posted which means that you're trying to pass a value that is too big for the database. You will have to find out what value you pass in order to change it.
chalie001Author Commented:
I change the code to above example this is the best way to do it
girionisCommented:
Obviously the example above works with a specific set of data, while you use different data. This is the problem. You need to match the data with the column type and length of your database.
chalie001Author Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for chalie001's comment #a41371468

for the following reason:

I did this http://adfpractice-fedor.blogspot.ba/2013/01/working-with-plsql-procedures-in-adf-bc.html
girionisCommented:
I gave a solution to the reader which was caused by a null pointer. Further down were more errors to which I also provided a correct answer.
chalie001Author Commented:
thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.