Conversion of string to date

Hi,
i'm trying to develop a module which reads the date from the Web page as inputed by the user and stores the date in the database.

My JSP page is as follows:

and the java file is as follows:

package net.roseindia.project;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.*;
import java.util.Date;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.lang.*;

public  class reservation  extends ActionSupport {

public String execute() throws Exception {

String url="jdbc:mysql://localhost/";
		String dbName="project";
		String driverName="com.mysql.jdbc.Driver";
		String userName="root";
		String password="";
		Connection con=null;
		ResultSet rs=null;
		Statement stmt=null;
		try{
			Class.forName(driverName).newInstance();
			con=DriverManager.getConnection(url+dbName,userName,password);
			stmt=con.createStatement();
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
		SimpleDateFormat df= new SimpleDateFormat("YYYY-MM-DD");
		Date dates=df.parse(getDate());
		String source=getSource();
		String destination=getDestination();
		String query="select * from buses where day=(date_format('"+dates+"','%a'))";
		System.out.println(query);
		rs=stmt.executeQuery(query);
        System.out.println(rs);
		if(!rs.next())
		{
			return ERROR;
		}
		else
		{
		  return SUCCESS;
		}
	}

private Date dates=null;

public Date getDate()
	{
		return dates;
	}

public void setDate(Date value)
	{
        SimpleDateFormat df= new SimpleDateFormat("YYYY-MM-DD");
	    dates=df.parse(value);
	}

private String source=null;

public String getSource()
	{
	 return source;
	}

public void setSource(String value)
	{
		 source=value;
	}
	
	private String destination=null;

public String getDestination()
	{
		return destination;
	}

public void setDestination(String value)
	{
		destination=value;
	}

}

now when i'm trying to compile in the using ANT its giving the follwowing error:

C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\struts2tutorial\W
EB-INF\src>ant
Buildfile: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\struts
2tutorial\WEB-INF\src\build.xml

clean:
   [delete] Deleting directory C:\Program Files\Apache Software Foundation\Tomca
t 6.0\webapps\struts2tutorial\WEB-INF\classes
    [mkdir] Created dir: C:\Program Files\Apache Software Foundation\Tomcat 6.0\
webapps\struts2tutorial\WEB-INF\classes

prepare:

resources:

compile:
    [javac] C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\strut
s2tutorial\WEB-INF\src\build.xml:82: warning: 'includeantruntime' was not set, d
efaulting to build.sysclasspath=last; set to false for repeatable builds
    [javac] Compiling 18 source files to C:\Program Files\Apache Software Founda
tion\Tomcat 6.0\webapps\struts2tutorial\WEB-INF\src\classes
    [javac] C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\strut
s2tutorial\WEB-INF\src\java\net\roseindia\project\reservation.java:33: cannot fi
nd symbol
    [javac] symbol  : method parse(java.util.Date)
    [javac] location: class java.text.SimpleDateFormat
    [javac]             Date dates=df.parse(getDate());
    [javac]                          ^
    [javac] C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\strut
s2tutorial\WEB-INF\src\java\net\roseindia\project\reservation.java:60: cannot fi
nd symbol
    [javac] symbol  : method parse(java.util.Date)
    [javac] location: class java.text.SimpleDateFormat
    [javac]         dates=df.parse(value);
    [javac]                 ^
    [javac] Note: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps
\struts2tutorial\WEB-INF\src\java\net\roseindia\AnnotationAction.java uses or ov
errides a deprecated API.
    [javac] Note: Recompile with -Xlint:deprecation for details.
    [javac] 2 errors

BUILD FAILED
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\struts2tutorial\W
EB-INF\src\build.xml:82: Compile failed; see the compiler error output for detai
ls.

Total time: 0 seconds
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\struts2tutorial\W
EB-INF\src>

please help

parse method has two overloaded forms

parse(String) and parse(String source, ParsePosition pos)

but your code seems to be passing a Date object.

the JSP page is sending the input as String only.

May be. But look at your method call

I made the changes and removed the parser from the statement where the method returns the value but it is still giving the same error for the one parser in the setDate method

i made the changes, now the code is:

package net.roseindia.project;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.*;
import java.util.Date;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.lang.*;

public  class reservation  extends ActionSupport {

public String execute() throws Exception {

String url="jdbc:mysql://localhost/";
		String dbName="project";
		String driverName="com.mysql.jdbc.Driver";
		String userName="root";
		String password="";
		Connection con=null;
		ResultSet rs=null;
		Statement stmt=null;
		try{
			Class.forName(driverName).newInstance();
			con=DriverManager.getConnection(url+dbName,userName,password);
			stmt=con.createStatement();
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
        //SimpleDateFormat df= new SimpleDateFormat("YYYY-MM-DD");
		Date dates=getDate();
		String source=getSource();
		String destination=getDestination();
		String query="select * from buses where day=(date_format('"+dates+"'.'%a'))";
		System.out.println(query);
		rs=stmt.executeQuery(query);
        System.out.println(rs);
		if(!rs.next())
		{
			return ERROR;
		}
		else
		{
		  return SUCCESS;
		}
	}

private Date dates=null;

public Date getDate()
	{
		return dates;
	}

public void setDate(String value)
	{
        SimpleDateFormat df= new SimpleDateFormat("YYYY-MM-DD");
	    dates=df.parse(value);
	}

private String source=null;

public String getSource()
	{
	 return source;
	}

public void setSource(String value)
	{
		 source=value;
	}
	
	private String destination=null;

public String getDestination()
	{
		return destination;
	}

public void setDestination(String value)
	{
		destination=value;
	}

}

and the error during compiling is:

C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\struts2tutorial\
EB-INF\src>ant
Buildfile: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\strut
2tutorial\WEB-INF\src\build.xml

clean:
   [delete] Deleting directory C:\Program Files\Apache Software Foundation\Tomc
t 6.0\webapps\struts2tutorial\WEB-INF\classes
    [mkdir] Created dir: C:\Program Files\Apache Software Foundation\Tomcat 6.0
webapps\struts2tutorial\WEB-INF\classes

prepare:

resources:

compile:
    [javac] C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\stru
s2tutorial\WEB-INF\src\build.xml:82: warning: 'includeantruntime' was not set,
efaulting to build.sysclasspath=last; set to false for repeatable builds
    [javac] Compiling 18 source files to C:\Program Files\Apache Software Found
tion\Tomcat 6.0\webapps\struts2tutorial\WEB-INF\src\classes
    [javac] C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\stru
s2tutorial\WEB-INF\src\java\net\roseindia\project\reservation.java:60: unreport
d exception java.text.ParseException; must be caught or declared to be thrown
    [javac]         dates=df.parse(value);
    [javac]                       ^
    [javac] Note: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapp
\struts2tutorial\WEB-INF\src\java\net\roseindia\AnnotationAction.java uses or o
errides a deprecated API.
    [javac] Note: Recompile with -Xlint:deprecation for details.
    [javac] 1 error

BUILD FAILED
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\struts2tutorial\
EB-INF\src\build.xml:82: Compile failed; see the compiler error output for deta
ls.

Total time: 0 seconds
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\struts2tutorial\
EB-INF\src>

Look at the error

java.text.ParseException; must be caught or declared to be thrown

so you should either throw the exception or catch it

Thanks... now the code gets compiled and is running..
but not according hoe it should..
the code is now..

package net.roseindia.project;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.*;
import java.util.Date;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.lang.*;

public  class reservation  extends ActionSupport {

public String execute() throws Exception {

String url="jdbc:mysql://localhost/";
		String dbName="project";
		String driverName="com.mysql.jdbc.Driver";
		String userName="root";
		String password="";
		Connection con=null;
		ResultSet rs=null;
		Statement stmt=null;
		try{
			Class.forName(driverName).newInstance();
			con=DriverManager.getConnection(url+dbName,userName,password);
			stmt=con.createStatement();
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
        //SimpleDateFormat df= new SimpleDateFormat("YYYY-MM-DD");
		Date dates=getDate();
		String source=getSource();
		String destination=getDestination();
		System.out.println(dates+" "+source+" "+destination);
		String query="select * from buses where day=(date_format('"+dates+"','%a'))";
		System.out.println(query);
		rs=stmt.executeQuery(query);
        System.out.println(rs);
		if(!rs.next())
		{
			return ERROR;
		}
		else
		{
		  return SUCCESS;
		}
	}

private Date dates=null;

public Date getDate()
	{
			return dates;
	}

public void setDate(String value)
	{
     try{
		SimpleDateFormat df= new SimpleDateFormat("YYYY-MM-DD");
	    dates=df.parse(value);
		 }
	  catch(Exception e) {}
	 }

private String source=null;

public String getSource()
	{
	 return source;
	}

public void setSource(String value)
	{
		 source=value;
	}
	
	private String destination=null;

public String getDestination()
	{
		return destination;
	}

public void setDestination(String value)
	{
		destination=value;
	}

}

its sending the date as "null"

I checked the logs and its something like this:

2010-07-30 13:37:26,468  INFO (com.opensymphony.xwork2.util.ResolverUtil:31) - Scanning for classes in [/C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/struts2-showcase-2.1.8.1/WEB-INF/classes/org/apache/struts2/showcase/person/] matching criteria: org.apache.struts2.config.ClasspathPackageProvider$1@13a1778
2010-07-30 13:37:26,468 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - ClasspathPackageProvider: Processing class org.apache.struts2.showcase.person.ListPeopleAction
2010-07-30 13:37:26,468 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - class:class org.apache.struts2.showcase.person.ListPeopleAction parent:null current:org.apache.struts2.showcase.person
2010-07-30 13:37:26,484 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - ClasspathPackageProvider: Processing class org.apache.struts2.showcase.person.NewPersonAction
2010-07-30 13:37:26,484 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - class:class org.apache.struts2.showcase.person.NewPersonAction parent:null current:org.apache.struts2.showcase.person
2010-07-30 13:37:26,484 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - ClasspathPackageProvider: Processing class org.apache.struts2.showcase.person.EditPersonAction
2010-07-30 13:37:26,484 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - class:class org.apache.struts2.showcase.person.EditPersonAction parent:null current:org.apache.struts2.showcase.person
null Kanpur Aligarh
select * from buses where day=(date_format('null','%a'))
com.mysql.jdbc.JDBC4ResultSet@82c23d

What is the use of following line?
private Date dates=null;

Its used for intializing and local declaration of the variable "dates"

try one thing, put two print statements in this method to make sure you are getting the values properly.

and in

I did the additions suggested by you. Now the log is:

2010-07-30 14:57:14,703 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - ClasspathPackageProvider: Processing class org.apache.struts2.showcase.person.EditPersonAction
2010-07-30 14:57:14,703 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - class:class org.apache.struts2.showcase.person.EditPersonAction parent:null current:org.apache.struts2.showcase.person
2010-07-30 14:57:14,703 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - ClasspathPackageProvider: Processing class org.apache.struts2.showcase.person.NewPersonAction
2010-07-30 14:57:14,703 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - class:class org.apache.struts2.showcase.person.NewPersonAction parent:null current:org.apache.struts2.showcase.person
2010-07-30 14:57:14,703 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - ClasspathPackageProvider: Processing class org.apache.struts2.showcase.person.ListPeopleAction
2010-07-30 14:57:14,703 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - class:class org.apache.struts2.showcase.person.ListPeopleAction parent:null current:org.apache.struts2.showcase.person
select password from admin_user where username='admin'
Date value returned from getDate()= null
null Gorakhpur Aligarh
select * from buses where day=(date_format('null','%a'))
com.mysql.jdbc.JDBC4ResultSet@cf7fda

The print statements in the setDate() weren't even executed.. so I think there might be a problem with that.
I even tried changing

public void setDate(String value)

to

void setDate(String value)

but that also gave the same result

try this once
in your execute method

make that dates variable as String

and change the definition of setDate and getDate as follows

Made the changes suggest by you. The code is now

package net.roseindia.project;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.*;
import java.util.Date;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.lang.*;

public  class reservation  extends ActionSupport {

public String execute() throws Exception {

String url="jdbc:mysql://localhost/";
		String dbName="project";
		String driverName="com.mysql.jdbc.Driver";
		String userName="root";
		String password="";
		Connection con=null;
		ResultSet rs=null;
		Statement stmt=null;
		try{
			Class.forName(driverName).newInstance();
			con=DriverManager.getConnection(url+dbName,userName,password);
			stmt=con.createStatement();
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
        SimpleDateFormat df= new SimpleDateFormat("YYYY-MM-DD");
		Date date=null;
		try{
			date=df.format(getDate());
		}
		catch(Exception e)
		{
			 e.printStackTrace();
		}
		System.out.println("after parsing date="+date);
		String source=getSource();
		String destination=getDestination();
		System.out.println(dates+" "+source+" "+destination);
		String query="select * from buses where day=(date_format('"+dates+"','%a'))";
		System.out.println(query);
		rs=stmt.executeQuery(query);
        System.out.println(rs);
		if(!rs.next())
		{
			return ERROR;
		}
		else
		{
		  return SUCCESS;
		}
	}

private String dates;

public Date getDate()
	{ System.out.println("Date value returned from getDate()= "+dates);
			return dates;
	}

public void setDate(String value)
	{
     try{
		System.out.println("Value assigned to dates::"+value);
	    dates=value;
		}
	  catch(Exception e) {}
	 }

private String source=null;

public String getSource()
	{
	 return source;
	}

public void setSource(String value)
	{
		 source=value;
	}
	
	private String destination=null;

public String getDestination()
	{
		return destination;
	}

public void setDestination(String value)
	{
		destination=value;
	}

}

and while compiling its giving an error:

C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\struts2tutorial\W
EB-INF\src>ant
Buildfile: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\struts
2tutorial\WEB-INF\src\build.xml

clean:
   [delete] Deleting directory C:\Program Files\Apache Software Foundation\Tomca
t 6.0\webapps\struts2tutorial\WEB-INF\classes
    [mkdir] Created dir: C:\Program Files\Apache Software Foundation\Tomcat 6.0\
webapps\struts2tutorial\WEB-INF\classes

prepare:

resources:

compile:
    [javac] C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\strut
s2tutorial\WEB-INF\src\build.xml:82: warning: 'includeantruntime' was not set, d
efaulting to build.sysclasspath=last; set to false for repeatable builds
    [javac] Compiling 18 source files to C:\Program Files\Apache Software Founda
tion\Tomcat 6.0\webapps\struts2tutorial\WEB-INF\src\classes
    [javac] C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\strut
s2tutorial\WEB-INF\src\java\net\roseindia\project\reservation.java:35: incompati
ble types
    [javac] found   : java.lang.String
    [javac] required: java.util.Date
    [javac]                     date=df.format(getDate());
    [javac]                                   ^
    [javac] C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\strut
s2tutorial\WEB-INF\src\java\net\roseindia\project\reservation.java:63: incompati
ble types
    [javac] found   : java.lang.String
    [javac] required: java.util.Date
    [javac]                     return dates;
    [javac]                            ^
    [javac] Note: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps
\struts2tutorial\WEB-INF\src\java\net\roseindia\AnnotationAction.java uses or ov
errides a deprecated API.
    [javac] Note: Recompile with -Xlint:deprecation for details.
    [javac] 2 errors

BUILD FAILED
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\struts2tutorial\W
EB-INF\src\build.xml:82: Compile failed; see the compiler error output for detai
ls.

Total time: 0 seconds
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\struts2tutorial\W
EB-INF\src>

should be

its giving an error "incompatible types"

so i made a change and converted

to

it compiled properly but while running struts gave an error:

Struts Problem Report
Struts has detected an unhandled exception:

Messages: Illegal pattern character 'Y' 
 
File: java/text/SimpleDateFormat.java 
Line number: 769

--------------------------------------------------------------------------------

Stacktraces
java.lang.IllegalArgumentException: Illegal pattern character 'Y' 
    java.text.SimpleDateFormat.compile(SimpleDateFormat.java:769)
    java.text.SimpleDateFormat.initialize(SimpleDateFormat.java:576)
    java.text.SimpleDateFormat.(SimpleDateFormat.java:501)
    java.text.SimpleDateFormat.(SimpleDateFormat.java:476)
    net.roseindia.project.reservation.execute(reservation.java:32)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
    com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
    org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
    org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
    org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
    org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
    java.lang.Thread.run(Thread.java:619)

format method takes date datatype as method parameter and returns String...

I changed the code from

to

and it compiled and was able to execute.. but the "null" problem is still there.
the logs are:

2010-07-30 16:19:26,687 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - ClasspathPackageProvider: Processing class org.apache.struts2.showcase.person.NewPersonAction
2010-07-30 16:19:26,687 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - class:class org.apache.struts2.showcase.person.NewPersonAction parent:null current:org.apache.struts2.showcase.person
2010-07-30 16:19:26,703 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - ClasspathPackageProvider: Processing class org.apache.struts2.showcase.person.ListPeopleAction
2010-07-30 16:19:26,703 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - class:class org.apache.struts2.showcase.person.ListPeopleAction parent:null current:org.apache.struts2.showcase.person
2010-07-30 16:19:26,703 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - ClasspathPackageProvider: Processing class org.apache.struts2.showcase.person.EditPersonAction
2010-07-30 16:19:26,703 DEBUG (org.apache.struts2.config.ClasspathPackageProvider:57) - class:class org.apache.struts2.showcase.person.EditPersonAction parent:null current:org.apache.struts2.showcase.person
select password from admin_user where username='deepti'
Date value returned from getDate()= null
java.lang.NullPointerException
	at java.text.SimpleDateFormat.parse(SimpleDateFormat.java:1235)
	at java.text.DateFormat.parse(DateFormat.java:335)
	at net.roseindia.project.reservation.execute(reservation.java:35)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
	at java.lang.Thread.run(Thread.java:619)
after parsing date=null
null Allahabad Lucknow
select * from buses where day=(date_format('null','%a'))
com.mysql.jdbc.JDBC4ResultSet@3d511e

There is small mistake in the code that Mai has pointed out, you need to call parse not format. However this does not seem to be related to the null issue.

I changed format to parse.... Only after making the change the file is able to be executed....

The problem is setter method for date is not getting called.