login page in struts - please help

[bhavit pant]

folowing is my directory structure in eclipse:
com.action
loginFormAction.java
com.Form
loginForm.java
com.Dao
test.java// just for quick jdbc testing working fine
loginDao.java
this is the struts-config.xml
<?xml version="1.0" encoding="ISO-8859-1" ?> <!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.3//EN" "http://struts.apache.org/dtds/struts-config_1_3.dtd"> <struts-config> <form-beans> <form-bean name= "checklogin" type="com.form.LoginForm"/> </form-beans> <global-forwards> <!-- <forward name="helloWorld" path="/helloWorld.do"/> --> <forward name="checklogin" path="/checklogin.do"></forward> </global-forwards> <action-mappings> <action path="/checklogin" type="com.action.LoginFormAction" name ="checklogin"> <forward name="success" path= "/loginSuccess.jsp"/> <forward name="failure" path= "/loginFailed.jsp"/> </action> </action-mappings> </struts-config>
login form

package com.form;
import org.apache.struts.action.*;

import javax.servlet.http.HttpServletRequest;


public class LoginForm extends ActionForm {

	private static final long serialVersionUID = -473562596852452021L;
	



	private String username=null;
    private String password=null;
    public void reset(ActionMapping mapping,HttpServletRequest request){


    	 this.username=null;
    	 this.password=null;


    	 }

    public ActionErrors validate( 

    		 ActionMapping mapping, HttpServletRequest request ) {
    		 ActionErrors errors = new ActionErrors();

    		 if( getUsername() == null || getUsername().length() < 1 ) {
    		 errors.add("username",new ActionMessage("error.username.required"));
    		 }
    		 if( getpassword() == null || getpassword().length() < 1 ) {
    		 errors.add("password",new ActionMessage("error.password.required"));
    	
    		 }
    		 return errors;
    }


	public String getUsername() {
		return username;
	}

	public void setUsername( String name) {
		this.username = name;
	}	
	
public void setpassword(String pass) {
		this.password = pass;
	}	
public String getpassword() {
	return password ;
	}	
}

login action

package com.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.form.LoginForm;
;

public class LoginFormAction  extends Action {
	@Override
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		System.out.println(form);
		
	
		LoginForm tForm = (LoginForm) form;
		com.Dao.loginDao  loginDAO =  new com.Dao.loginDao();
		if(loginDAO.createConnection(tForm.getUsername(),tForm.getpassword()))
			return mapping.findForward("success");
		else
			return mapping.findForward("failure");
				
	}
		  
}
	

login dao

package com.Dao;
import java.sql.*;


public class loginDao {
	boolean valid;
	   @SuppressWarnings("unused")
	public boolean createConnection(String strUserName,String strPassword) throws SQLException
	   {
		     Connection conn = null;
			 Statement smt = null;
			 ResultSet rs=null;
		   
//		 boolean valid = false;
		
	 try
	   {  
		 Class.forName("oracle.jdbc.driver.OracleDriver"); 
		 String conURL= "jdbc:oracle:thin:@XXX.XX.XX.XXX:1521:catyu";
		String username="catyu";
		 String password= "CATYu";
		 
		   
	         conn = DriverManager.getConnection (conURL,username,password); 
		    //select query for checking password 
	         smt = conn.createStatement();
		    String query="select id from LOGIN where loginid='"+strUserName+"' and password='"+strPassword+"'";
		    rs=smt.executeQuery(query);

		    if(rs.next()== true)
		    {
		    valid=true;}
		    else{
		         valid=false;
		        }
	   }
		    
	 catch (SQLException e) { 
		        e.printStackTrace(); 
		    } 
   catch (Exception e) 
          { 
		        e.printStackTrace(); 
		    } 
    finally { 
		        // Close the connection 
		        conn.close(); 
		        rs.close();
		        smt.close();
		    } 

		 return valid;

}
}

running test. java which prints somthing from database is working fine but running thi sproject give the following error
com.form.LoginForm@47108e
11 Jun, 2012 3:09:03 PM org.apache.struts.chain.commands.servlet.CreateAction createAction
INFO: Initialize action of type: com.action.LoginFormAction
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1678)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1523)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.Dao.loginDao.createConnection(loginDao.java:18)
at com.action.LoginFormAction.execute(LoginFormAction.java:24)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
11 Jun, 2012 3:09:03 PM org.apache.struts.chain.commands.AbstractExceptionHandler execute
WARNING: Unhandled exception
java.lang.NullPointerException
at com.Dao.loginDao.createConnection(loginDao.java:47)
at com.action.LoginFormAction.execute(LoginFormAction.java:24)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
11 Jun, 2012 3:09:03 PM org.apache.struts.chain.commands.ExceptionCatcher postprocess
WARNING: Exception from exceptionCommand 'servlet-exception'
java.lang.NullPointerException
at com.Dao.loginDao.createConnection(loginDao.java:47)
at com.action.LoginFormAction.execute(LoginFormAction.java:24)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
11 Jun, 2012 3:09:03 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [action] in context with path [/StrutsExample1] threw exception [java.lang.NullPointerException] with root cause
java.lang.NullPointerException
at com.Dao.loginDao.createConnection(loginDao.java:47)
at com.action.LoginFormAction.execute(LoginFormAction.java:24)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
i do'nt know how to fix this just started studing struts, since morning i am scratching my head, please help if i am wrong, quite possible that have made some blunder

[Sumit Patil]

You have to add jar file containing your database driver to your classpath.

[bhavit pant]

i have done all that, that is why i have shown test.java, which working fine ,

[Myyron Murray Latorilla]

Are you including ojdbc*.jar on your war package? If not make sure such jar is in your web/app server lib folder.

[bhavit pant]

yes i am including .. see this file in same project which i made to check jdbc problems is working fine

package com.form;
import java.sql.*;
public class test {
	public static void main(String[] args) throws ClassNotFoundException , SQLException
	{
	 Connection conn = null;
			 Statement smt = null;

		   
//		 boolean valid = false;
		
	 try
	   {  
		 Class.forName("oracle.jdbc.driver.OracleDriver"); 
		 String conURL= "jdbc:oracle:thin:@XXX:1521:catyu";
		String username="catyu";
		 String password= "CATYu";
		   
	         conn = DriverManager.getConnection (conURL,username,password); 
	    
	         smt = conn.createStatement();
	        
			    String query="select * from tmp_bhavit ";
			    ResultSet    rs=smt.executeQuery(query);
			    while(rs.next())
			    System.out.println(rs.getString("USERNAME"));// this is giving correct output
		    //select query for checking password 
	   }  
	 catch (SQLException e) { 
		        e.printStackTrace(); 
		    } 
catch (Exception e) 
       { 
		        e.printStackTrace(); 
		    } 
 finally { 
		        // Close the connection 
		        conn.close(); 
		        smt.close();
		    } 

}
}

  

i am confuseed why i am getting class not found error. if this is working

[Myyron Murray Latorilla]

Seems to be that the test program is just a java application and not a webapp, the war package might not be containing the ojdbc as you expected, try to put the jar file on your server lib folder.

[bhavit pant]

@myyron latorilla : thanks man it works fine now.. thanks a lot