tomcat 7、8 jndi 找不到mysql驱动

你要去哪里-无望 2016-05-28 09:16:14
想配置tomcat jndi 可tomcat总是报 找不到mysql驱动com.MySQL.jdbc.Driver

在tomcat lib 中已经放入mysql驱动包
mysql-connector-java-5.1.39.jar
现在是用的最新的版本。 我试过好多个版本都不行。

网上都是说把mysql驱动放tomcat lib下就可以了。 但我这真的不行。。。。我已经想不到办法了。。。

我甚至用压缩软件打开mysql驱动包 包里面的com文件夹复制到了 tomcat-dbcp.jar 内部 还是不行。。。

求大神解释解释 拜托了

配置如下：



// server.xml 配置

<Resource name="jdbc/mybatis"   

			   auth="Container"    

               type="javax.sql.DataSource"  

               driverClassName="com.MySQL.jdbc.Driver"    

               url="jdbc:mysql://127.0.0.1:3306/test"     

               username="root"    

               password="123456"  

               maxIdle="40"   

               maxWait="4000" 

               maxActive="50" 

               removeAbandoned="true" 

               removeAbandonedTimeout="180"

               logAbandoned="true" 

               factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" />







// Context.xml 配置

<ResourceLink global="jdbc/mybatis" name="jdbc/mybatis" type="javax.sql.DataSource"/>







// spring 配置

 <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">

	     <property name="jndiName">

	          <value>java:comp/env/jdbc/mybatis</value>

	     </property>

	</bean>


最后总是报：


五月 20, 2016 9:08:38 下午 org.apache.catalina.core.StandardWrapperValve invoke

严重: Servlet.service() for servlet [springMvc] in context with path [/aohuan-all] threw exception [Request processing failed; nested exception is 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 java.sql.SQLException: Cannot load JDBC driver class 'com.MySQL.jdbc.Driver'

### The error may exist in com/aohuan/basic/dao/ExcodeParamMapper.java (best guess)

### The error may involve com.aohuan.basic.dao.ExcodeParamMapper.select

### The error occurred while executing a query

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot load JDBC driver class 'com.MySQL.jdbc.Driver'] with root cause

java.lang.ClassNotFoundException: com.MySQL.jdbc.Driver

	at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1305)

	at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1139)

	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2129)

	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2032)

	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1532)

	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)

	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)

	at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:81)

	at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)

	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 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.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)

	at com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:404)

	at com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:377)

	at com.github.pagehelper.PageHelper.intercept(PageHelper.java:227)

	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)

	at com.sun.proxy.$Proxy62.query(Unknown Source)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)

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

	at com.sun.proxy.$Proxy22.selectList(Unknown Source)

	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:198)

	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:122)

	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:64)

	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)

	at com.sun.proxy.$Proxy43.select(Unknown Source)

	at com.aohuan.weixin.action.RechargeAction.toRecharge(RechargeAction.java:70)

	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.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)

	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)

	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)

	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)

	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)

	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)

	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)

	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:844)

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

	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)

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

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

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

	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

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

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

	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

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

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

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

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

	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

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

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

	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)

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

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)

	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)

	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)

	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)

	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)

	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

	at java.lang.Thread.run(Unknown Source)



...全文
510 3 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
w410919244 2016-05-29
  • 打赏
  • 举报
 回复
任何人回复结贴
w410919244 2016-05-29
  • 打赏
  • 举报
 回复
我艹，搞了 七八个小时。终于找到问题了。fuck。。。。 网上找的配置com.MySQL.jdbc.Driver 尼玛？真的没有com.MySQL.jdbc.Driver！！！ http://blog.csdn.net/cyong888/article/details/7361466 这个位大神给的配置。哥要日他 fuck。。。 他故意的 正确配置com.mysql.jdbc.Driver
Nnick_s 2016-05-29
  • 打赏
  • 举报
 回复
结吧，包名还有大写字母啊，呵呵。
Tomcat6配置JNDI出错
NULL 博文链接：https://zy19880406.iteye.com/blog/677975
tomcat6中配置JNDI方法
连接数据库有JDBC和JNDI等多种方式，该文件详细的描述了如何在tomcat6下配置JNDI的方法，本人测试多次很有效，绝对正确。
tomcat8设置MySQL数据源
Tomcat8配置数据源的方法有三种，以MySQL数据库为例说明
Tomcat JNDI配置
Tomcat JNDI配置说明
用dbcp连接池，mysql数据库，在tomcat服务器下，通过hibernate配置jndi数据源.doc
用dbcp连接池，mysql数据库，在tomcat服务器下，通过hibernate配置jndi数据源. 我想此标题已经比较明确了。 在此说明一点，hibernate开发小组不推荐在hibernate下使用dbcp，如果一定要的话，请慎重考虑。
Java EE

67,550

社区成员

225,863

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章