configuring Quartz CMT jobStore using Spring datasource -


i'm trying confugre quartz jobstorecmt , use spring's datasource managed datasource. here spring's config file datasource definition:

<bean id="datasource" class="org.apache.commons.dbcp.basicdatasource"     destroy-method="close">     <property name="driverclassname" value="${database.driverclassname}" />     <property name="url" value="${database.url}" />     <property name="username" value="${database.username}" />     <property name="password" value="${database.password}" /> </bean> 

here quartz.properties:

org.quartz.jobstore.class: org.quartz.impl.jdbcjobstore.jobstorecmt org.quartz.jobstore.driverdelegateclass: org.quartz.impl.jdbcjobstore.stdjdbcdelegate org.quartz.jobstore.useproperties: false org.quartz.jobstore.datasource = managedtxds org.quartz.jobstore.nonmanagedtxdatasource = qzds org.quartz.jobstore.tableprefix: qrtz_ org.quartz.jobstore.isclustered: false  #============================================================================ # configure datasources   #============================================================================ org.quartz.datasource.managedtxds.jndiurl=java:comp/env/jdbc/datasource  org.quartz.datasource.qzds.driver: com.mysql.jdbc.driver org.quartz.datasource.qzds.url: jdbc:mysql://localhost:3306/myschema org.quartz.datasource.qzds.user: user org.quartz.datasource.qzds.password: pwd org.quartz.datasource.qzds.maxconnections: 5 org.quartz.datasource.qzds.validationquery=select 0 dual 

when run unit test tries initialize scheduler i'm getting following error:

2011-07-20 21:38:22,477 [main] error org.quartz.utils.jndiconnectionprovider - error  looking datasource: need specify class name in environment or system property, or applet parameter, or in application resource file:  java.naming.factory.initial javax.naming.noinitialcontextexception: need specify class name in environment or  system property, or applet parameter, or in application resource file:  java.naming.factory.initial @ javax.naming.spi.namingmanager.getinitialcontext(unknown source) @ javax.naming.initialcontext.getdefaultinitctx(unknown source) @ javax.naming.initialcontext.geturlordefaultinitctx(unknown source) ... org.quartz.jobpersistenceexception: failed obtain db connection data source 'managedtxds': java.sql.sqlexception: not retrieve datasource via jndi url 'java:comp/env/jdbc/datasource' javax.naming.noinitialcontextexception: need specify class name in environment or system property, or applet parameter, or in application resource file:  java.naming.factory.initial [see nested exception: java.sql.sqlexception: not retrieve datasource via jndi url 'java:comp/env/jdbc/datasource' javax.naming.noinitialcontextexception: need specify class name in environment or system property, or applet parameter, or in application resource file:  java.naming.factory.initial] @ org.quartz.impl.jdbcjobstore.jobstoresupport.getconnection(jobstoresupport.java:726) @ org.quartz.impl.jdbcjobstore.jobstorecmt.executeinlock(jobstorecmt.java:231) 

so, problem specifying org.quartz.datasource.managedtxds.java.naming.factory.initial and/or org.quartz.datasource.managedtxds.jndiurl=java:comp/env/jdbc/datasource ?

if jndi factory setting missing - should value spring?

thanks! marina

please have @

http://static.springsource.org/spring/docs/3.0.x/api/org/springframework/scheduling/quartz/localdatasourcejobstore.html

set

org.quartz.jobstore.class = org.springframework.scheduling.quartz.localdatasourcejobstore 

Comments

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

actionscript 3 - TweenLite does not work with object -

jQuery Ajax Render Fragments OR Whole Page -