Creating a database login screen using Primefaces and Hibernate

In this tutorial I will be creating a simple JSF login screen based on a database table. The final result will be a login form in which the user enters his username/password and it will redirect him to the home page or will show him a message indicating an invalid username/password or if his status is inactive.

In order to complete this tutorial you will need to complete those two tutorials, note that you will need to create both projects in the same workspace.

• Setup a primefaces dynamic web project.
• Setup a Hibernate JPA project.

Setting up Hibernate with an eclipse JPA project

In this tutorial I will be creating a sample JPA application from scratch in which we will create a single entity representing a user.

We will need to have the following available:

1. Eclipse IDE for Java EE developers, which can be downloaded from eclipse download page , I am using Indigo.
2. hibernate-distribution-3.6.7.Final-dist which can be downloaded from hibernate download page.
3. Oracle or Oracle XE installation. Oracle XE can be downloaded from oracle xe download page.
4. SLF4J can be downloaded from slf4j download page.
5. Create a folder in d:\workspaces and name it hibernate_lib, place the following files inside of it:

• The two jars hibernate3.jar,hibernate-jpa-2.0-api-1.0.1.Final.jar which can be found in the hibernate distribution.
• antlr-2.7.6.jar, commons-collections-3.1.jar,dom4j-1.6.1.jar,javaassist-3.12.0.GA.jar, jta-1.1.jar, and slf4j-api-1.6.1.jar. Those files can be found inside the HIBERNATE_DISTRIBUTION/lib/required
• ojdbc4.jar which can be found in ORACLE_XE_HOME\app\oracle\product\10.2.0\server\jdbc\lib
• slf4j-simple-1.6.2.jar from the SLF4J distribution.