spring集成quartz报数据库链接问题

最新推荐文章于 2022-08-02 09:08:57 发布

todobugs

最新推荐文章于 2022-08-02 09:08:57 发布

阅读量462

点赞数

分类专栏： spring 文章标签： spring quartz

本文链接：https://blog.csdn.net/iteye_7068/article/details/82674584

版权

spring 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

本文档描述了在Spring中集成Quartz定时任务时遇到的数据库连接异常，异常信息提示无法打开JDBC连接进行事务处理。问题根源在于自动装配导致的PropertyPlaceholderConfigurer失效，使得${jdbc.driverClassName}等属性无法从properties文件中获取。解决方案是将SchedulerFactoryBean的autowire属性设置为"no"，避免自动装配，确保属性配置正确读取。

摘要由CSDN通过智能技术生成

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd"
default-autowire="byName">

<bean id="quartzJob" class="com.study.spring.quartz.QuartzJob" />

<bean id="jobDetail" class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
<property name="targetObject" ref="quartzJob" />
<property name="targetMethod" value="myJob" />
<property name="concurrent" value="false"/>

</bean>

<bean id="myTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
<property name="jobDetail" ref="jobDetail"/>
<property name="cronExpression" value="*/1 * * * * ?" />
</bean>

<bean id="batchQuartz" class="org.springframework.scheduling.quartz.SchedulerFactoryBean">

<property name="triggers">
<list>
<ref bean="myTrigger"/>
</list>
</property>
</bean>
</beans>

=========================================================================
以上中定义batchQuartz的bean,启动服务时，一直报org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'batchQuartz' defined in class path resource [conf/spring/spring-quartz.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class '${jdbc.driverClassName}'

解决方式：
在定义batchQuartz时，配置 autowire="no"，不让自动装配，否则PropertyPlaceholderConfigurer失效，也就是用${jdbc.username}这样之类的表达式，将无法获取到properties文件里的内容