@Stateless(name = "LoginFacade")
 public   class  LoginFacadeBean  implements  LoginFacade, LoginFacadeLocal {

    @PersistenceContext(unitName = "Model")
     private  EntityManager em;

    @Resource(name = "jdbc/oracleDS")
     private  DataSource ds;

     public  LoginFacadeBean() {
    }

    
     public  String getUser(String UserLogin, String UserPassword)  throws  ModelException {
        Connection conn =  null ;
        OracleCallableStatement cstmt =  null ;

        String user =  null ;

         try  {
            conn = ds.getConnection();

            cstmt = (OracleCallableStatement)conn.prepareCall("{ call ? := clb_get_user(?,?) }");


            cstmt.registerOutParameter( 1 , Types.VARCHAR); 
            cstmt.setString( 2 , UserLogin);
            cstmt.setString( 3 , UserPassword);
            cstmt.executeUpdate();
            user = cstmt.getString( 1 );

        }  catch  (SQLException e) {
             throw   new  ModelException(e.toString());
        }  finally  {
             try  {
                 if  (cstmt !=  null )
                    cstmt.close();
                 if  (conn !=  null )
                    conn.close();
            }  catch  (SQLException e) {
                 throw   new  ModelException(e.toString());
            }
        }
         return  user;
    }

@Stateless(name="BooksSearchFacade")
 public   class  BooksSearchFacadeBean  implements  BooksSearchFacade, BooksSearchFacadeLocal {
    @PersistenceContext(unitName="Model")
     private  EntityManager em;

     public  BooksSearchFacadeBean() {
    }

    /** <code>select o from BooksSearch o</code> */
     public  List<BooksSearch> queryBooksSearchFindAll() {
         return  em.createNamedQuery("BooksSearch.findAll").getResultList();
    }


}