mysqljdbc
org.mybatis.spring.mybatissystemexception: nested exception is org.apache.ibatis.exceptions.persistenceexception:
error querying database. cause: org.springframework.jdbc.cannotgetjdbcconnectionexception: could not get jdbc connection; nested exception is org.apache.commons.dbcp.sqlnestedexception: cannot load jdbc driver class 'com.mysql.jdbc.driver 'the error may exist in file [d:\workspace\mygraduationdesign\target\classes\com\cyq\bookstore\mapping\usersmapper.xml]the error may involve com.cyq.bookstore.dao.usersdao.selectbyprimarykeythe error occurred while executing a querycause: org.springframework.jdbc.cannotgetjdbcconnectionexception: could not get jdbc connection; nested exception is org.apache.commons.dbcp.sqlnestedexception: cannot load jdbc driver class 'com.mysql.jdbc.driver 'at org.mybatis.spring.mybatisexceptiontranslator.translateexceptionifpossible(mybatisexceptiontranslator.java:76)at org.mybatis.spring.sqlsessiontemplate$sqlsessioninterceptor.invoke(sqlsessiontemplate.java:399)at com.sun.proxy.$proxy16.selectone(unknown source)at org.mybatis.spring.sqlsessiontemplate.selectone(sqlsessiontemplate.java:165)at org.apache.ibatis.binding.mappermethod.execute(mappermethod.java:69)at org.apache.ibatis.binding.mapperproxy.invoke(mapperproxy.java:53)at com.sun.proxy.$proxy17.selectbyprimarykey(unknown source)at com.cyq.bookstore.serviceimpl.usersserviceimpl.getuserbyid(usersserviceimpl.java:19)at testmybatis.test1(testmybatis.java:30)at sun.reflect.nativemethodaccessorimpl.invoke0(native method)at sun.reflect.nativemethodaccessorimpl.invoke(unknown source)at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source)at java.lang.reflect.method.invoke(unknown source)at org.junit.runners.model.frameworkmethod$1.runreflectivecall(frameworkmethod.java:47)at org.junit.internal.runners.model.reflectivecallable.run(reflectivecallable.java:12)at org.junit.runners.model.frameworkmethod.invokeexplosively(frameworkmethod.java:44)at org.junit.internal.runners.statements.invokemethod.evaluate(invokemethod.java:17)at org.springframework.test.context.junit4.statements.runbeforetestmethodcallbacks.evaluate(runbeforetestmethodcallbacks.java:74)at org.springframework.test.context.junit4.statements.runaftertestmethodcallbacks.evaluate(runaftertestmethodcallbacks.java:85)at org.springframework.test.context.junit4.statements.springrepeat.evaluate(springrepeat.java:86)at org.junit.runners.parentrunner.runleaf(parentrunner.java:271)at org.springframework.test.context.junit4.springjunit4classrunner.runchild(springjunit4classrunner.java:241)at org.springframework.test.context.junit4.springjunit4classrunner.runchild(springjunit4classrunner.java:87)at org.junit.runners.parentrunner$3.run(parentrunner.java:238)at org.junit.runners.parentrunner$1.schedule(parentrunner.java:63)at org.junit.runners.parentrunner.runchildren(parentrunner.java:236)at org.junit.runners.parentrunner.access$000(parentrunner.java:53)at org.junit.runners.parentrunner$2.evaluate(parentrunner.java:229)at org.springframework.test.context.junit4.statements.runbeforetestclasscallbacks.evaluate(runbeforetestclasscallbacks.java:61)at org.springframework.test.context.junit4.statements.runaftertestclasscallbacks.evaluate(runaftertestclasscallbacks.java:70)at org.junit.runners.parentrunner.run(parentrunner.java:309)at org.springframework.test.context.junit4.springjunit4classrunner.run(springjunit4classrunner.java:180)at org.eclipse.jdt.internal.junit4.runner.junit4testreference.run(junit4testreference.java:50)at org.eclipse.jdt.internal.junit.runner.testexecution.run(testexecution.java:38)at org.eclipse.jdt.internal.junit.runner.remotetestrunner.runtests(remotetestrunner.java:459)at org.eclipse.jdt.internal.junit.runner.remotetestrunner.runtests(remotetestrunner.java:675)at org.eclipse.jdt.internal.junit.runner.remotetestrunner.run(remotetestrunner.java:382)at org.eclipse.jdt.internal.junit.runner.remotetestrunner.main(remotetestrunner.java:192)
caused by: org.apache.ibatis.exceptions.persistenceexception:
error querying database. cause: org.springframework.jdbc.cannotgetjdbcconnectionexception: could not get jdbc connection; nested exception is org.apache.commons.dbcp.sqlnestedexception: cannot load jdbc driver class 'com.mysql.jdbc.driver 'the error may exist in file [d:\workspace\mygraduationdesign\target\classes\com\cyq\bookstore\mapping\usersmapper.xml]the error may involve com.cyq.bookstore.dao.usersdao.selectbyprimarykeythe error occurred while executing a querycause: org.springframework.jdbc.cannotgetjdbcconnectionexception: could not get jdbc connection; nested exception is org.apache.commons.dbcp.sqlnestedexception: cannot load jdbc driver class 'com.mysql.jdbc.driver 'at org.apache.ibatis.exceptions.exceptionfactory.wrapexception(exceptionfactory.java:30)at org.apache.ibatis.session.defaults.defaultsqlsession.selectlist(defaultsqlsession.java:122)at org.apache.ibatis.session.defaults.defaultsqlsession.selectlist(defaultsqlsession.java:113)at org.apache.ibatis.session.defaults.defaultsqlsession.selectone(defaultsqlsession.java:73)at sun.reflect.nativemethodaccessorimpl.invoke0(native method)at sun.reflect.nativemethodaccessorimpl.invoke(unknown source)at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source)at java.lang.reflect.method.invoke(unknown source)at org.mybatis.spring.sqlsessiontemplate$sqlsessioninterceptor.invoke(sqlsessiontemplate.java:386)... 36 more
caused by: org.springframework.jdbc.cannotgetjdbcconnectionexception: could not get jdbc connection; nested exception is org.apache.commons.dbcp.sqlnestedexception: cannot load jdbc driver class 'com.mysql.jdbc.driver '
at org.springframework.jdbc.datasource.datasourceutils.getconnection(datasourceutils.java:80)
at org.mybatis.spring.transaction.springmanagedtransaction.openconnection(springmanagedtransaction.java:82)
at org.mybatis.spring.transaction.springmanagedtransaction.getconnection(springmanagedtransaction.java:68)
at org.apache.ibatis.executor.baseexecutor.getconnection(baseexecutor.java:315)
at org.apache.ibatis.executor.simpleexecutor.preparestatement(simpleexecutor.java:75)
at org.apache.ibatis.executor.simpleexecutor.doquery(simpleexecutor.java:61)
at org.apache.ibatis.executor.baseexecutor.queryfromdatabase(baseexecutor.java:303)
at org.apache.ibatis.executor.baseexecutor.query(baseexecutor.java:154)
at org.apache.ibatis.executor.cachingexecutor.query(cachingexecutor.java:102)
at org.apache.ibatis.executor.cachingexecutor.query(cachingexecutor.java:82)
at org.apache.ibatis.session.defaults.defaultsqlsession.selectlist(defaultsqlsession.java:120)
... 43 more
caused by: org.apache.commons.dbcp.sqlnestedexception: cannot load jdbc driver class 'com.mysql.jdbc.driver '
at org.apache.commons.dbcp.basicdatasource.createconnectionfactory(basicdatasource.java:1429)
at org.apache.commons.dbcp.basicdatasource.createdatasource(basicdatasource.java:1371)
at org.apache.commons.dbcp.basicdatasource.getconnection(basicdatasource.java:1044)
at org.springframework.jdbc.datasource.datasourceutils.dogetconnection(datasourceutils.java:111)
at org.springframework.jdbc.datasource.datasourceutils.getconnection(datasourceutils.java:77)
... 53 more
caused by: java.lang.classnotfoundexception: com.mysql.jdbc.driver
at java.net.urlclassloader.findclass(unknown source)
at java.lang.classloader.loadclass(unknown source)
at sun.misc.launcher$appclassloader.loadclass(unknown source)
at java.lang.classloader.loadclass(unknown source)
at org.apache.commons.dbcp.basicdatasource.createconnectionfactory(basicdatasource.java:1420)
... 57 more