Session Scope With Bind Variable

[Hamza Wael]

السلام عليكم

ممكن حضراتكم تساعدونى لحل هذه المشكله

عندى table اسمه users عايز لما اعمل لوجين اخد اسم ال user عن طريق ال session واروح الى view object اللى اسمها UserView اعمل هناك bind Variable ياخد قيمته من Session ويعمل Execute view object عن طريق ال Bind Variable

 

1- ده الكود اللى فى Login Action

 

 

    public String Loginaction() throws Exception {
        // Add event code here...
        FacesMessage message;
        FacesContext context = FacesContext.getCurrentInstance();
       String amDef = "model.AppModule";
       String config = "AppModuleLocal";
        ApplicationModule ami = Configuration.createRootApplicationModule(amDef, config);
        AppModuleImpl am = (AppModuleImpl)ami;
        UserData user = am.findUser(UserName, Password);
        if(user == null){
            message = new FacesMessage(FacesMessage.SEVERITY_ERROR,"User Not Found","");
            }else
        {
           
            FacesContext.getCurrentInstance().getExternalContext().getSessionMap().put("userKey",user.getUserName());
           return ("MainPage");
    
                       
            
        }

 

2 - ده اللى بكتبه فى ال bind variable

 

adf.context.current.sessionScope.get("userKey")

 

مع ان لو كتبت نفس الكلام فى Groovy Expression هيجيب قيمه ال user عادى

[sd4it]

وما المشكلة التي تحدث؟

[Hamza Wael]

وما المشكلة التي تحدث؟

javax.faces.el.EvaluationException: //C:/Users/Development/AppData/Roaming/JDeveloper/system11.1.2.3.39.62.76.1/o.j2ee/drs/AdfLogin2/ViewControllerWebApp.war/login.jsf @22,111 action="#{backingBeanScope.backing_login.Loginaction}": oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT TbsUsers.USER_ID,        TbsUsers.ACCESS_NAME,        TbsUsers.USER_NAME,        TbsUsers.ACCESS_LEVEL,        TbsUsers.PASSWORD,        TbsUsers.BRAN_IDFROM TBS_USERS TbsUsersWHERE USER_NAME = :BUSER) QRSLT  WHERE ( ( (USER_NAME LIKE :vc_temp_1 ) AND (PASSWORD LIKE :vc_temp_2 ) ) )

[Hamza Wael]

 

وما المشكلة التي تحدث؟

javax.faces.el.EvaluationException: //C:/Users/Development/AppData/Roaming/JDeveloper/system11.1.2.3.39.62.76.1/o.j2ee/drs/AdfLogin2/ViewControllerWebApp.war/login.jsf @22,111 action="#{backingBeanScope.backing_login.Loginaction}": oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT TbsUsers.USER_ID,        TbsUsers.ACCESS_NAME,        TbsUsers.USER_NAME,        TbsUsers.ACCESS_LEVEL,        TbsUsers.PASSWORD,        TbsUsers.BRAN_IDFROM TBS_USERS TbsUsersWHERE USER_NAME = :BUSER) QRSLT  WHERE ( ( (USER_NAME LIKE :vc_temp_1 ) AND (PASSWORD LIKE :vc_temp_2 ) ) )

[sd4it]

قم بإنشاء view object منفصل بحيث يتم فصل المستخدمين (للتحقق من الدخول) عن الفلترة التي تريدها