Hi I am using JBuilder I want to use some stored procedures in my EJB project I have a n-tier architecture with JSP as the front layer EJB session layer and EJB entity layer and JS for common layer....... I have to bring dynamic menu from the database (SQL server)according to users(admin and normal) and then connect through EJB and at the end post the value to the JSP page.... I am unable to use the stored procedures as the user table and the menu tables are not directly linked together..... any one with suggestions ???