Getting exception in connectiong to mysql

[manish250]

Hi all

I have just started learning spring and trying to create a login application.But when i tried to run the application in eclipse i am getting following exception

org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledN onSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:160)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:81)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1472)
at com.UserDao.saveUser(UserDao.java:16)
at com.UserController.onSubmit(UserController.java:44 )
at org.springframework.web.servlet.mvc.SimpleFormCont roller.processFormSubmission(SimpleFormController. java:272)
at org.springframework.web.servlet.mvc.AbstractFormCo ntroller.handleRequestInternal(AbstractFormControl ler.java:268)
at org.springframework.web.servlet.mvc.AbstractContro ller.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter.handle(SimpleControllerHandlerAda pter.java:48)
at org.springframework.web.servlet.DispatcherServlet. doDispatch(DispatcherServlet.java:863)
at org.springframework.web.servlet.DispatcherServlet. doService(DispatcherServlet.java:792)
at org.springframework.web.servlet.FrameworkServlet.p rocessRequest(FrameworkServlet.java:851)
at org.springframework.web.servlet.FrameworkServlet.d oPost(FrameworkServlet.java:767)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBas e.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java:928)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.p rocess(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnect ionHandler.process(AbstractProtocol.java:539)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProce ssor.run(JIoEndpoint.java:300)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.driver'
at org.apache.commons.dbcp.BasicDataSource.createData Source(BasicDataSource.java:766)
at org.apache.commons.dbcp.BasicDataSource.getConnect ion(BasicDataSource.java:540)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.getConnection(LocalDataSourceCo nnectionProvider.java:82)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:446)
... 32 more
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.driver
at org.apache.catalina.loader.WebappClassLoader.loadC lass(WebappClassLoader.java:1688)
at org.apache.catalina.loader.WebappClassLoader.loadC lass(WebappClassLoader.java:1533)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.createData Source(BasicDataSource.java:760)
... 35 more


while there is mysql-connector file available in /WEB-INF/lib directory of eclipse project.Please help

[dc3]

How are you building? (Maven or Ant)

If maven, what are the contents of the .classpath file?

[manish250]

I am using eclipse simply running the application.Not using maven or ant

[Marten Deinum]

Have you actually read the stack trace?!

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.driver'

It is Driver not driver...

Please next time when posting code/xml/stacktraces use [ code][/code ] tags that way it remains readable.

[manish250]

Thanks Marten.You solved my problem.I'll take care of this from the next time.