validation not working

chalie001
chalie001 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2018

Commented:
This is not the error message, but the logs from the operation. Do you get any exception? If yes, can you post it?

Author

Commented:
no i don't get exception at all
Distinguished Expert 2018

Commented:
So when you say it's not working what do you mean?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

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

Distinguished Expert 2018

Commented:
Can you post the SignOnValidation.java file? All of it, and specifically line 81, that's where the error occurs.

Author

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

Author

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

Distinguished Expert 2018

Commented:
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?

Author

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

Distinguished Expert 2018

Commented:
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

Author

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

Author

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();
Distinguished Expert 2018
Commented:
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.

Author

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
Distinguished Expert 2018

Commented:
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.

Author

Commented:
I change the code to above example this is the best way to do it
Distinguished Expert 2018

Commented:
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.

Author

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
Distinguished Expert 2018

Commented:
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.

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial