chalie001

asked on 11/29/2015

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

Oracle DatabaseJavaJava EEProgrammingSoftware

Last Comment

chalie001

8/22/2022 - Mon

girionis

12/1/2015

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

chalie001

12/1/2015

ASKER

no i don't get exception at all

girionis

12/1/2015

So when you say it's not working what do you mean?

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!

James Murphy

chalie001

12/2/2015

ASKER

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

girionis

12/3/2015

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

chalie001

12/3/2015

ASKER

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

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

chalie001

12/3/2015

ASKER

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

girionis

12/3/2015

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?

chalie001

12/3/2015

ASKER

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

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck

girionis

12/3/2015

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

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

Open in new window

chalie001

12/3/2015

ASKER

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

chalie001

12/3/2015

ASKER

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();

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

ASKER CERTIFIED SOLUTION

girionis

12/3/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

chalie001

12/4/2015

ASKER

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

chalie001

12/5/2015

ASKER

i what to do something like this
http://adfpractice-fedor.blogspot.ba/2013/01/working-with-plsql-procedures-in-adf-bc.html

girionis

12/7/2015

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.

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

William Peck

chalie001

12/8/2015

ASKER

I change the code to above example this is the best way to do it

girionis

12/8/2015

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.

chalie001

12/15/2015

ASKER

http://adfpractice-fedor.blogspot.ba/2013/01/working-with-plsql-procedures-in-adf-bc.html

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

chalie001

12/15/2015

ASKER

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

girionis

12/15/2015

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.

chalie001

12/16/2015

ASKER

thanks

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

rwheeler23