wood burning stoves 2.0
The moose likes EJB and other Java EE Technologies and the fly likes EJB, JDBC Realm, Session tracking Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "EJB, JDBC Realm, Session tracking" Watch "EJB, JDBC Realm, Session tracking" New topic

EJB, JDBC Realm, Session tracking

Gaurav Dighe

Joined: Jun 25, 2009
Posts: 21

Hello All,

I am developing shopping cart application with EJB. the application will be web based .ie. servlet jsp will be used with EJB.
i have JavaDB. I have table named "Users". Table has 2 columns 1. user and 2. password.

When the application is started, home.jsp will be displayed.

The Home page(home.jsp) of my application contains:
1. Login form with login Button and Register link.
The user will provide his credentials. His credentials will be checked against the JAVA DB Users table. If correct then a user page will appear to him showing his account details and other things: Products List etc,,,,,
If he is new user and want to register himself then, user will click on register link. Then registration Page will appear in front him and then he will register himself and his data will be saved in database.

2. Products Link: any body clicking on the products will be migrated to the products page. the list will appear. if he wants to purchase some items, he will check the checkboxes and will click on submit button. If the user has not logged in then, the login form with register link will appear. Once he enter his credentials, his credentials will be checked against the JAVA DB Users table. if correct , then his selected products will be viewd to him and session id will be tracked which will be used for further transactions.

This thing have been easily achieved using Servlet,JSp and JDBC.

Now if i want to use JDBC Realm(Security), then how to configure my glassfish server for such things.
Requirements are:
1. Checking Credentials using JDBC Realm
2. Registering new user and data to be stored in Database User table using JDBC Realm
3. if credentials are correct, then mainatin the session and that sessionid will be used for further transactions.

PLease help me with codes or any configuration codes.

Thanks & Regards,
Gaurav Dighe
I agree. Here's the link: http://aspose.com/file-tools
subject: EJB, JDBC Realm, Session tracking
jQuery in Action, 3rd edition