springMVC 配置jdbcTemplate连接Oracle数据库出错_jdbctemplate oracle语句总是出错-优快云博客

本文链接：https://blog.youkuaiyun.com/u013147600/article/details/47757029

本文记录了在使用springMVC项目中，配置jdbcTemplate连接Oracle数据库遇到的问题及解决过程。错误源于缺少必要的jar包，通过检查和对比正确项目中的jar包，发现仍有缺失，并且存在不适用的jar包。虽然尝试复制了所有jar包，但问题仍未解决。文中还提及，对于连接MySQL数据库，需要引入特定的mysql-connector-java-5.0.8-bin.jar包。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

springMVC 配置jdbcTemplate连接Oracle数据库出错
错误信息：

log4j:WARN No appenders could be found for logger (org.springframework.core.env.StandardEnvironment).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" java.lang.ExceptionInInitializerError
at com.test.Test.main(Test.java:15)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [springmvc-servlet.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 [oracle.jdbc.driver.OracleDriver]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1427)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1132)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:522)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:607)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
at com.utils.SpringUtil.<clinit>(SpringUtil.java:16)
... 1 more
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 [oracle.jdbc.driver.OracleDriver]
at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:101)
at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:57)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1424)
... 14 more

猜想：
1.SpringMVC xml配置文件配置错误，把多余的配置信息注释掉，问题依然存在
2.dataSource bean中的url、driverClassName、username、password 配置出错

3.缺少jar包，把正确项目的jar包全部拷贝过来，问题未解决（后来发现还是缺少需要的jar包而多了一个不需要的jar包）

4.最后终于发现还是jar包的问题，原来是少了ojdbc14.jar这个jar包，我以为有了spring.jdbc-3.0.5.jar就不需要ojdbc.jar包了。

如果是连接MySql数据库需要导入mysql-connector-java-5.0.8-bin.jar包

项目的jar包：http://download.youkuaiyun.com/detail/u013147600/9020459