JDBC驱动程序无法加载。为什么？ （春，休眠） [英] JDBC driver cannot be loaded. Why? (Spring,Hibernate)
本文介绍了JDBC驱动程序无法加载。为什么？ （春，休眠）的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我通过 Maven SPRING + HIBERNATE ） c $ c>>两个星期前，现在加载JDBC驱动程序时出现问题（直到现在才发生）。所以，我的 pom.xml 文件看起来像这样：
< project xmlns =http://maven.apache.org/POM/4.0.0xmlns：xsi =http://www.w3.org/2001/XMLSchema-instance
xsi：schemaLocation = http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd\">
< modelVersion> 4.0.0< / modelVersion>
< groupId> com.spring.hib< / groupId>
< artifactId> HibPav< / artifactId>
< version> 1.0-SNAPSHOT< / version>
<依赖关系>
< dependency>
< groupId> org.springframework< / groupId>
< artifactId> spring< / artifactId>
< version> 2.5.6< / version>
< /依赖关系>
< dependency>
< groupId> mysql< / groupId>
< artifactId> mysql-connector-java< / artifactId>
< version> 5.1.27< / version>
< /依赖关系>
< dependency>
< groupId> org.springframework< / groupId>
< artifactId> spring-hibernate3< / artifactId>
< version> 2.0.5< / version>
< /依赖关系>
< dependency>
< groupId> dom4j< / groupId>
< artifactId> dom4j< / artifactId>
< version> 1.6.1< / version>
< /依赖关系>
< dependency>
< groupId> javax.transaction< / groupId>
< artifactId> jta< / artifactId>
< version> 1.1< / version>
< /依赖关系>
< dependency>
< groupId> org.springframework< / groupId>
< artifactId> spring-jdbc< / artifactId>
< version> 3.2.5.RELEASE< / version>
< /依赖关系>
< dependency>
< groupId> org.hibernate< / groupId>
< artifactId> hibernate-core< / artifactId>
< version> 4.2.7.Final< / version>
< /依赖关系>
< / dependencies>
< / project>
看起来这个文件很清晰。但是，当我尝试创建 dataSource bean时，JDBC驱动程序无法加载的主要问题是什么。
其他文件：
数据源文件
<？xml version =1.0encoding =UTF-8？>
< beans xmlns =http://www.springframework.org/schema/beans
xmlns：xsi =http://www.w3.org/2001/XMLSchema-instance
xsi：schemaLocation =http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.1.xsd\">
< bean
class =org.springframework.beans.factory.config.PropertyPlaceholderConfigurer>
< property name =location>
< value> properties / database.properties< / value>
< / property>
< / bean>
< bean id =dataSource
class =org.springframework.jdbc.datasource.DriverManagerDataSource>
< property name =driverClassNamevalue =$ {jdbc.driverClassName}/>
< property name =urlvalue =$ {jdbc.url}/>
< property name =usernamevalue =$ {jdbc.username}/>
< property name =passwordvalue =$ {jdbc.password}/>
< / bean>
< / beans>
属性文件
jdbc.driverClassName = com.mysql.jdbc.Driver;
jdbc.url = jdbc：mysql：// localhost / mydb
jdbc.username = myinfuser
jdbc.password = myinfuserpw
$ b 错误：
mainorg.springframework.beans.factory.BeanCreationException：在类路径资源[spring / database / datasource.xml]中定义名称为'dataSource'的bean时出错：设置属性值时出错;嵌套异常是org.springframework.beans.PropertyBatchUpdateException;嵌套PropertyAccessExceptions（1）：
PropertyAccessException 1：org.springframework.beans.MethodInvocationException：属性'driverClassName'引发异常;嵌套异常是java.lang.IllegalStateException：无法在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues（AbstractAutowireCapableBeanFactory.java:1279）上加载JDBC驱动程序类[com.mysql.jdbc.Driver;]
;在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean（AbstractAutowireCapableBeanFactory.java:1010）
在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:472）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory $ 1.run（AbstractAutowireCapableBeanFactory.java:409）
at java.security.AccessController.doPrivileged（Native Method）$ b $ org.springframework .beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:380）
at org.springframework.beans.factory.support.AbstractBeanFactory $ 1.getObje ct（AbstractBeanFactory.java:264）
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:222）
at org.springframework.beans.factory.support.AbstractBeanFactory。 doGetBean（AbstractBeanFactory.java:261）
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:185）
at org.springframework.beans.factory.support.AbstractBeanFactory。 getBean（AbstractBeanFactory.java:164）
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons（DefaultListableBeanFactory.java:429）
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization（ AbstractApplicationContext.java:728）
at org.springframework.context.support.AbstractApplicationContext.refresh（AbstractApplicationContext.java:380）
at org.springframework.context.support.ClassPathXmlApplicationContext。< init >（ClassPathXmlApplicationContext.java:139）
at org.springframework.context.support.ClassPathXmlApplicationContext。< init>（ClassPathXmlApplicationContext.java:83）
at com.spring.dirba.Main.main Main.java:11）
导致：org.springframework.beans.PropertyBatchUpdateException;嵌套PropertyAccessExceptions（1）：
PropertyAccessException 1：org.springframework.beans.MethodInvocationException：属性'driverClassName'引发异常;嵌套异常是java.lang.IllegalStateException：无法在org.springframework.beans.AbstractPropertyAccessor.setPropertyValues（AbstractPropertyAccessor.java:104）
中加载JDBC驱动程序类[com.mysql.jdbc.Driver;]
在org.springframework.beans.AbstractPropertyAccessor.setPropertyValues（AbstractPropertyAccessor.java:59）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues（AbstractAutowireCapableBeanFactory.java:1276）
... 16更多
任何人？
/ p>
jdbc.driverClassName = com.mysql.jdbc.Driver;
Spring使用反射和该属性的值来加载 Class code>实例按完全限定的类名称。没有称为 com.mysql.jdbc.Driver; 的类。有一个名为 com.mysql.jdbc.Driver 的类，所以使用它。
jdbc.driverClassName = com.mysql.jdbc.Driver
I have created a program (SPRING+HIBERNATE) through Maven two weeks ago and now it is having a problem with loading JDBC driver (which wasn't occur until now). So, my pom.xml file looks like this:
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.spring.hib</groupId>
<artifactId>HibPav</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring</artifactId>
<version>2.5.6</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.27</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-hibernate3</artifactId>
<version>2.0.5</version>
</dependency>
<dependency>
<groupId>dom4j</groupId>
<artifactId>dom4j</artifactId>
<version>1.6.1</version>
</dependency>
<dependency>
<groupId>javax.transaction</groupId>
<artifactId>jta</artifactId>
<version>1.1</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>3.2.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>4.2.7.Final </version>
</dependency>
</dependencies>
</project>
It seems that this file is clear. But what is the main problem that JDBC driver cannot be loaded while I am trying to create a dataSource bean.
Other files:
datasource file
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.1.xsd">
<bean
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>properties/database.properties</value>
</property>
</bean>
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
</beans>
properties file
jdbc.driverClassName=com.mysql.jdbc.Driver;
jdbc.url=jdbc:mysql://localhost/mydb
jdbc.username=myinfuser
jdbc.password=myinfuserpw
Error:
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [spring/database/datasource.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [com.mysql.jdbc.Driver;]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1279)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
at com.spring.dirba.Main.main(Main.java:11)
Caused by: org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [com.mysql.jdbc.Driver;]
at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:104)
at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:59)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1276)
... 16 more
Anyone?
Thanks in advance
解决方案
Get rid of the ; at the end of your property
jdbc.driverClassName=com.mysql.jdbc.Driver;
Spring uses reflection and the value of that property to load a Class instance by fully qualified class name. There is no class called com.mysql.jdbc.Driver;. There is a class called com.mysql.jdbc.Driver, so use that.
jdbc.driverClassName=com.mysql.jdbc.Driver
这篇关于JDBC驱动程序无法加载。为什么？ （春，休眠）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
