Logic to create common Serverlet3 Login
- by user3696143
I am using Servlet3 Login to Authenticate User in website I have these Login
Website Normal Login(Fill the Sigup form)
Facebook Login (From Facebook Id)
Twitter Login (From Twitter)
And I am already authenticate user by below code
HttpServletRequest request = (HttpServletRequest) FacesContext.getCurrentInstance().getExternalContext().getRequest();
request.login(username, password);
And it is working fine for Website Login as user gave his/her EMailId and password and it store in DB.
Now I modified table and added more columns to save Facebookid in same user table and also password for Facebook login FacebookId work as a Password as well. Same I will do for Twitter But I want the same Servlet3 to authenticate user. How can I achieve it?
And also added context.xml file inside META-INF folder
<Realm localDataSource="true" debug="99"
className="org.apache.catalina.realm.JDBCRealm" connectionName="user"
connectionPassword="password" connectionURL="jdbc:mysql://localhost:3306/ ccc"
digest="md5" driverName="com.mysql.jdbc.Driver" roleNameCol="role_name"
userCredCol="password" userNameCol="email_id"
userRoleTable="users_list" userTable="user_list_view" />
Also it is possible to check which query fired by realm entry?