strut problem

i am developing Strut project using mysql server,Hibernate and Spring

this is the code, it's give error, what its means and where is problem

Strut-Config.xml

<?xml version="1.0" encoding="ISO-8859-1" ?>

<!DOCTYPE struts-config PUBLIC

"-//Apache Software Foundation//DTD Struts Configuration 1.2//EN"

"http://jakarta.apache.org/struts/dtds/struts-config_1_2.dtd">

<!--

This is a blank Struts configuration file with an example

welcome action/page and other commented sample elements.

Tiles and the Struts Validator are configured using the factory defaults

and are ready-to-use.

NOTE: If you have a generator tool to create the corresponding Java classes

for you, you could include the details in the "form-bean" declarations.

Otherwise, you would only define the "form-bean" element itself, with the

corresponding "name" and "type" attributes, as shown here.

-->

<struts-config>

<!--

<data-sources>

<data-source type="org.apache.commons.dbcp.BasicDataSource">

<set-property

property="driverClassName"

value="com.mysql.jdbc.Driver" />

<set-property

property="url"

value="jdbc:mysql://localhost/mydatabase" />

<set-property

property="username"

value="root" />

<set-property

property="password"

value="282737" />

<set-property

property="maxActive"

value="10" />

<set-property

property="maxWait"

value="5000" />

<set-property

property="defaultAutoCommit"

value="false" />

<set-property

property="defaultReadOnly"

value="false" />

<set-property

property="validationQuery"

value="SELECT COUNT(*) FROM market" />

</data-source>

</data-sources>

-->

<form-beans>

<!-- sample form bean descriptor for an ActionForm

<form-bean

name="inputForm"

type="app.InputForm"/>

end sample -->

<!-- sample form bean descriptor for a DynaActionForm

<form-bean

name="logonForm"

type="org.apache.struts.action.DynaActionForm">

<form-property

name="username"

type="java.lang.String"/>

<form-property

name="password"

type="java.lang.String"/>

</form-bean>

end sample -->

<form-bean name="UserLoginForm"

type="roseindia.web.struts.form.UserLoginForm">

</form-bean>

<form-bean name="UserRegisterForm"

type="roseindia.web.struts.form.UserRegisterForm">

</form-bean>

<form-bean name="UserForgetPasswordForm"

type="roseindia.web.struts.form.UserForgetPasswordForm">

</form-bean>

</form-beans>

<global-exceptions>

<!-- sample exception handler

<exception

key="expired.password"

type="app.ExpiredPasswordException"

path="/changePassword.jsp"/>

end sample -->

</global-exceptions>

<global-forwards>

<forward

name="welcome"

path="/Welcome.do"/>

</global-forwards>

<action-mappings>

<action

path="/Welcome"

forward="/pages/Welcome.jsp"/>

<!-- sample input and input submit actions

<action

path="/Input"

type="org.apache.struts.actions.ForwardAction"

parameter="/pages/Input.jsp"/>

<action

path="/InputSubmit"

type="app.InputAction"

name="inputForm"

scope="request"

validate="true"

input="/pages/Input.jsp"/>

<action

path="/edit*"

type="app.Edit{1}Action"

name="inputForm"

scope="request"

validate="true"

input="/pages/Edit{1}.jsp"/>

end samples -->

<!--

<action

path="/showlist"

type="roseindia.web.struts.action.">

forward="/pages/user/showuserlist.jsp"/>

-->

<action

path="/logout"

type="roseindia.web.struts.action.Logout">

</action>

<action

path="/userlogin"

name="UserLoginForm"

scope="request"

validate="true"

input="/pages/user/userlogin.jsp"

type="roseindia.web.struts.action.UserLoginAction">

</action>

<action

path="/userregister"

name="UserRegisterForm"

scope="request"

validate="true"

input="/pages/user/userRegister.jsp"

type="roseindia.web.struts.action.UserRegisterAction">

</action>

<action

path="/userforgetpassword"

name="UserForgetPasswordForm"

scope="request"

validate="true"

input="/pages/user/forgetpassword.jsp"

type="roseindia.web.struts.action.UserForgetPasswordAction">

</action>

</action-mappings>

<controller

processorClass="org.apache.struts.tiles.TilesRequestProcessor"/>

<message-resources parameter="MessageResources" />

<!--

This plugin initialize Tiles definition factory. This later can takes some

parameters explained here after. The plugin first read parameters from

web.xml, thenoverload them with parameters defined here. All parameters

are optional.

The plugin should be declared in each struts-config file.

- definitions-config: (optional)

Specify configuration file names. There can be several comma

separated file names (default: ? )

- moduleAware: (optional - struts1.1)

Specify if the Tiles definition factory is module aware. If true

(default), there will be one factory for each Struts module.

If false, there will be one common factory for all module. In this

later case, it is still needed to declare one plugin per module.

The factory will be initialized with parameters found in the first

initialized plugin (generally the one associated with the default

module).

true : One factory per module. (default)

false : one single shared factory for all modules

- definitions-parser-validate: (optional)

Specify if xml parser should validate the Tiles configuration file.

true : validate. DTD should be specified in file header (default)

false : no validation

Paths found in Tiles definitions are relative to the main context.

-->

<plug-in className="org.apache.struts.tiles.TilesPlugin" >

<set-property property="definitions-config"

value="/WEB-INF/tiles-defs.xml" />

<set-property property="moduleAware" value="true" />

</plug-in>

<plug-in className="org.apache.struts.validator.ValidatorPlugIn">

<set-property

property="pathnames"

value="/WEB-INF/validator-rules.xml,/WEB-INF/validation.xml"/>

</plug-in>

</struts-config>

package roseindia.web.struts.action;

import roseindia.web.struts.form.UserLoginForm;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

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 org.apache.struts.action.ActionMessage;

import org.apache.struts.action.ActionMessages;

import roseindia.services.ServiceFinder;

//import roseindia.services.ServiceFinder;

public class UserLoginAction extends Action{

public ActionForward execute(

ActionMapping mapping,

ActionForm form,

HttpServletRequest request,

HttpServletResponse response) throws Exception{

//Retrieve the DAO Reference

roseindia.dao.SpringHibernateDAO springHibernateDAO = (roseindia.dao.SpringHibernateDAO) ServiceFinder.getContext(request)

.getBean("SpringHibernateDao");

// Create object of ActionMesssages

ActionMessages errors = new ActionMessages();

UserLoginForm objForm = (UserLoginForm) form;

String strUserid=objForm.getUserid();

String strPassword=objForm.getPassword();

boolean loginStatus = springHibernateDAO.checkUserLogin(strUserid,strPassword);

if(loginStatus==true){

HttpSession session = request.getSession();

session.setAttribute("userID", strUserid);

//int id =springHibernateDAO.getUserId(strUserid);

String id=String.valueOf(springHibernateDAO.getUserId(strUserid));

//Integer idvalue=new Integer(id);

session.setAttribute("ID", id);

System.out.println("Session value:"+session.getAttribute("userID"));

return mapping.findForward("success");

} else {

// not allowed

errors.add("login",new ActionMessage("error.login.invalid"));

saveErrors(request,errors);

return mapping.findForward("failure");

}

javax.servlet.ServletException: Cannot open connection

at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:523)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:716)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:198)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:138)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2459)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:132)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)

at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:126)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)

at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

at java.lang.Thread.run(Thread.java:595)

root cause

org.hibernate.exception.JDBCConnectionException: Cannot open connection

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:72)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:327)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:118)

at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:127)

at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)

at $Proxy6.createStatement(Unknown Source)

at roseindia.dao.SpringHibernateDAOImpl.checkUserLogin(Unknown Source)

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:585)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)

at $Proxy5.checkUserLogin(Unknown Source)

at roseindia.web.struts.action.UserLoginAction.execute(Unknown Source)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)