java – 错误：org.hibernate.util.JDBCExceptionReporter – 无法加载JDBC驱动程序类’com.mysql.jdbcDriver’

Spring 前端之家
前端之家收集整理的这篇文章主要介绍了java – 错误：org.hibernate.util.JDBCExceptionReporter – 无法加载JDBC驱动程序类’com.mysql.jdbcDriver’，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。

我正在尝试使用Spring和Hibernate以及MySQL数据库配置Java MVC webapp,但是当我运行服务器时出现此错误,我不知道是什么问题.

  1. WARN : org.hibernate.util.JDBCExceptionReporter - sql Error: 0,sqlState: null
  2. ERROR: org.hibernate.util.JDBCExceptionReporter - Cannot load JDBC driver class 'com.MysqL.jdbcDriver'
  3. WARN : org.hibernate.cfg.SettingsFactory - Could not obtain connection to query Metadata
  4. org.apache.commons.dbcp.sqlNestedException: Cannot load JDBC driver class 'com.MysqL.jdbcDriver'
  5.     at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
  6.     at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
  7.     at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
  8.     at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:114)
  9.     at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163)
  10.     at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159)
  11.     at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383)
  12.     at org.springframework.orm.hibernate3.LocalSessionfactorybean.newSessionFactory(LocalSessionfactorybean.java:860)
  13.     at org.springframework.orm.hibernate3.LocalSessionfactorybean.buildSessionFactory(LocalSessionfactorybean.java:779)
  14.     at org.springframework.orm.hibernate3.AbstractSessionfactorybean.afterPropertiesSet(AbstractSessionfactorybean.java:211)
  15.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.invokeInitMethods(AbstractAutowireCapablebeanfactory.java:1469)
  16.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.initializeBean(AbstractAutowireCapablebeanfactory.java:1409)
  17.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:519)
  18.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.createBean(AbstractAutowireCapablebeanfactory.java:456)
  19.     at org.springframework.beans.factory.support.Abstractbeanfactory$1.getObject(Abstractbeanfactory.java:291)
  20.     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
  21.     at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:288)
  22.     at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:190)
  23.     at org.springframework.beans.factory.support.DefaultListablebeanfactory.preInstantiateSingletons(DefaultListablebeanfactory.java:546)
  24.     at org.springframework.context.support.AbstractApplicationContext.finishbeanfactoryInitialization(AbstractApplicationContext.java:872)
  25.     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423)
  26.     at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
  27.     at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
  28.     at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
  29.     at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)
  30.     at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291)
  31.     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  32.     at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
  33.     at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
  34.     at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
  35.     at java.util.concurrent.FutureTask.run(Unknown Source)
  36.     at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  37.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  38.     at java.lang.Thread.run(Unknown Source)
  39. Caused by: java.lang.ClassNotFoundException: com.MysqL.jdbcDriver
  40.     at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1713)
  41.     at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1558)
  42.     at java.lang.Class.forName0(Native Method)
  43.     at java.lang.Class.forName(Unknown Source)
  44.     at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130)
  45.     ... 33 more
  46. ERROR: org.springframework.web.context.ContextLoader - Context initialization Failed
  47. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/spring/applicationContext.xml]: Invocation of init method Failed; nested exception is org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection available
  48.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.initializeBean(AbstractAutowireCapablebeanfactory.java:1412)
  49.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:519)
  50.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.createBean(AbstractAutowireCapablebeanfactory.java:456)
  51.     at org.springframework.beans.factory.support.Abstractbeanfactory$1.getObject(Abstractbeanfactory.java:291)
  52.     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
  53.     at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:288)
  54.     at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:190)
  55.     at org.springframework.beans.factory.support.DefaultListablebeanfactory.preInstantiateSingletons(DefaultListablebeanfactory.java:546)
  56.     at org.springframework.context.support.AbstractApplicationContext.finishbeanfactoryInitialization(AbstractApplicationContext.java:872)
  57.     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423)
  58.     at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
  59.     at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
  60.     at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
  61.     at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)
  62.     at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291)
  63.     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  64.     at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
  65.     at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
  66.     at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
  67.     at java.util.concurrent.FutureTask.run(Unknown Source)
  68.     at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  69.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  70.     at java.lang.Thread.run(Unknown Source)
  71. Caused by: org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection available
  72.     at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:107)
  73.     at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:138)
  74.     at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163)
  75.     at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159)
  76.     at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383)
  77.     at org.springframework.orm.hibernate3.LocalSessionfactorybean.newSessionFactory(LocalSessionfactorybean.java:860)
  78.     at org.springframework.orm.hibernate3.LocalSessionfactorybean.buildSessionFactory(LocalSessionfactorybean.java:779)
  79.     at org.springframework.orm.hibernate3.AbstractSessionfactorybean.afterPropertiesSet(AbstractSessionfactorybean.java:211)
  80.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.invokeInitMethods(AbstractAutowireCapablebeanfactory.java:1469)
  81.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.initializeBean(AbstractAutowireCapablebeanfactory.java:1409)
  82.     ... 22 more
  83. jul 28,2013 12:26:19 PM org.apache.catalina.core.StandardContext listenerStart
  84. SEVERE: Excepción enviando evento inicializado de contexto a instancia de escuchador de clase org.springframework.web.context.ContextLoaderListener
  85. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/spring/applicationContext.xml]: Invocation of init method Failed; nested exception is org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection available
  86.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.initializeBean(AbstractAutowireCapablebeanfactory.java:1412)
  87.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:519)
  88.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.createBean(AbstractAutowireCapablebeanfactory.java:456)
  89.     at org.springframework.beans.factory.support.Abstractbeanfactory$1.getObject(Abstractbeanfactory.java:291)
  90.     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
  91.     at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:288)
  92.     at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:190)
  93.     at org.springframework.beans.factory.support.DefaultListablebeanfactory.preInstantiateSingletons(DefaultListablebeanfactory.java:546)
  94.     at org.springframework.context.support.AbstractApplicationContext.finishbeanfactoryInitialization(AbstractApplicationContext.java:872)
  95.     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423)
  96.     at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
  97.     at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
  98.     at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
  99.     at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)
  100.     at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291)
  101.     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  102.     at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
  103.     at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
  104.     at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
  105.     at java.util.concurrent.FutureTask.run(Unknown Source)
  106.     at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  107.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  108.     at java.lang.Thread.run(Unknown Source)
  109. Caused by: org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection available
  110.     at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:107)
  111.     at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:138)
  112.     at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163)
  113.     at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159)
  114.     at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383)
  115.     at org.springframework.orm.hibernate3.LocalSessionfactorybean.newSessionFactory(LocalSessionfactorybean.java:860)
  116.     at org.springframework.orm.hibernate3.LocalSessionfactorybean.buildSessionFactory(LocalSessionfactorybean.java:779)
  117.     at org.springframework.orm.hibernate3.AbstractSessionfactorybean.afterPropertiesSet(AbstractSessionfactorybean.java:211)
  118.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.invokeInitMethods(AbstractAutowireCapablebeanfactory.java:1469)
  119.     at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.initializeBean(AbstractAutowireCapablebeanfactory.java:1409)
  120.     ... 22 more

我不知道错误在哪里.这是我的applicationContext.xml.错误似乎在dataSource bean中.

  1. factorybean">
  2.

这是我的jdbc.properties

  1. hibernate.generate_statistics = true
  2. hibernate.show_sql = true
  4. jdbc.driverClassName=com.MysqL.jdbcDriver
  5. jdbc.url=jdbc:MysqL://localhost:3306/baseDeDatos
  6. jdbc.username=miUsuario
  7. jdbc.password=miContrasena
  8. hibernate.dialect=org.hibernate.dialect.MysqLDialect

我有这个jar来加载类.它们中的某些东西(比如jpa-api.jar)我认为它不是必要的而且其他的都是重复的,但我在其他项目中已经开始制作它,我还没有删除它：

  1. activation-1.1.jar
  2. antlr-2.7.7.jar
  3. aopalliance-1.0.jar
  4. c3p0-0.9.1.jar
  5. commons-logging-1.1.1.jar
  6. commons-pool-1.6.jar
  7. dom4j-1.6.1.jar
  8. hibernate-commons-annotations-3.2.0.Final.jar
  9. hibernate-commons-annotations-4.0.1.Final.jar
  10. hibernate-core-3.5.3-Final.jar
  11. hibernate-core-4.1.8.Final.jar
  12. hibernate-entitymanager-4.1.8.Final.jar
  13. hibernate-jpa-2.0-api-1.0.1.Final.jar
  14. hibernate-validator-4.0.2.GA.jar
  15. hibernate3.jar
  16. javassist-3.15.0-GA.jar
  17. javax.mail.jar
  18. jaxb-api-2.1.jar
  19. jaxb-impl-2.1.3.jar
  20. jboss-logging-3.1.0.GA.jar
  21. jboss-transaction-api_1.1_spec-1.0.0.Final.jar
  22. jpa-api-2.0-cr-1.jar
  23. jstl-1.2.jar
  24. junit-4.8.1.jar
  25. log4j-1.2.14.jar
  26. MysqL-connector-java-5.1.25.jar
  27. MysqL-connector-java-5.1.6.jar
  28. org.apache.commons.dbcp.jar
  29. org.springframework.orm.jar
  30. postgresql-8.4-701.jdbc4.jar
  31. servlet-api-2.5.jar
  32. slf4j-api-1.5.11.jar
  33. slf4j-api-1.6.1.jar
  34. slf4j-log4j12-1.5.11.jar
  35. spring-aop-3.0.2.RELEASE.jar
  36. spring-asm-3.0.2.RELEASE.jar
  37. spring-beans-3.0.2.RELEASE.jar
  38. spring-context-3.0.2.RELEASE.jar
  39. spring-context-support-3.0.2.RELEASE.jar
  40. spring-core-3.0.2.RELEASE.jar
  41. spring-expression-3.0.2.RELEASE.jar
  42. spring-jdbc-3.0.2.RELEASE.jar
  43. spring-orm-3.0.2.RELEASE.jar
  44. spring-tx-3.0.2.RELEASE.jar
  45. spring-web-3.0.2.RELEASE.jar
  46. spring-webmvc-3.0.2.RELEASE.jar
  47. stax-api-1.0-2.jar
  48. validation-api-1.0.0.GA.jar

有人可以帮我解决这个问题吗？我使用Tomcat 7在Eclipse中运行它.

谢谢！

最佳答案
你在这里得到了错误的驱动程序名称：

  1. jdbc.driverClassName=com.MysqL.jdbcDriver

它应该是：

  1. jdbc.driverClassName=com.MysqL.jdbc.Driver

请注意.在jdbc和Driver之间.

诊断类似事物的方法是查看它找不到的类：

  1. Cannot load JDBC driver class 'com.MysqL.jdbcDriver'

这已经看起来很可疑,因为名称jdbcDriver不遵循Java命名约定.那么在那时你再仔细检查它应该是什么 – 例如通过查看jar文件 – 并修复配置.

正如评论中所指出的那样,我认为在类路径上拥有同一个jar文件的多个版本并不是一个好主意 – 我看不出结果很好.

hibernate

猜你在找的Spring相关文章

Spring Cloud 学习笔记（二）——Netflix
Spring Cloud为Spring Boot应用程序提供Netflix OSS集成。 提供的功能模块包括服务发现（E...
Spring Cloud 学习笔记（一）——入门、特征、配置
Spring Cloud 学习笔记；maven配置；入门学习；基于Spring Boot 实现；服务端配置，客户端...
Spring/SpringBoot常用注解总结
可以毫不夸张地说，这篇文章介绍的 Spring/SpringBoot 常用注解基本已经涵盖你工作中遇到的...
Spring 日期时间处理
Spring中各种方式进行日期时间处理，有作用于单个实体的，也有作用于全局的，有作用于请求...
Spring 5.0.0.RC1 - CORS Support 【译文】
跨域资源共享（Cross-origin resource sharing）（CORS）是W3C的标准，大部分的浏览器都实...
Spring Boot 整合 MyBatis
前言 现在业界比较流行的数据操作层框架 MyBatis，下面就讲解下 Springboot 如何整合 MyBa...
Spring Cloud系列：不重启eureka，清除down掉的服务
场景描述 做项目的时候，我的服务改了个ip，然后重新启动后，原ip的服务down掉了，但是没有...
SpringCloud中Feign的适配器的实现方案
前言 最近在做微服务的项目，各个系统之间需要进行调用，然后用一个适配器来实现服务之间的...
你不知道的事---SringCloud的feign的继承特性
前言 说起SpringChoud的feign大家用过的都说好。Feign是Netflix开发的声明式、模板化的HTT...
阿里nacos安装及使用指南
背景 最近去现场服务器搭建环境，正好借此机会将配置nacos的步骤在此进行总结，方便大家日...
PHPJavaJava SEPythonC#C&C++RubyVBasp.NetGoPerlnettyDjangoDelphiJsp.NET CoreSpringFlaskSpringbootSpringMVCLuaLaravelMybatisAspGroovyThinkPHPYiiswoole
文件时间pythonm相等性PHP Warning时间问题问题解决pcntl_signal采样点wav模块动态文本调用频率限制对外暴露多个访问请求更新数据表模型结构type()方法比较速度手写体sobel算子保存模型Image类nn.Conv2dpytorch1.0kaggleDCGAN交并比range()用法打印模型反卷积卷积