[Building Sakai] jobscheduler/quartz question

[Zhen Qian]

Hi, Devs:

I got the following error with QuartzScheduler:

2013-07-26 13:50:33,935 ERROR
QuartzScheduler_QuartzScheduler-m-c02d929rdc7c.local_MisfireHandler
org.quartz.impl.jdbcjobstore.JobStoreTX - MisfireHandler: Error handling
misfires: Failed to obtain DB connection from data source 'myDS':
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not
establish the connection
org.quartz.JobPersistenceException: Failed to obtain DB connection from
data source 'myDS': java.sql.SQLRecoverableException: IO Error: The Network
Adapter could not establish the connection [See nested exception:
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not
establish the connection]
    at
org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:715)
    at
org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:69)
    at
org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3132)
    at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3923)
    at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3943)
Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter
could not establish the connection
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
....

I found the data source 'myDS' was defined inside quartz.properties of
scheduler-component-shared module. But as I understand, quartz should be
configured to use Sakai's datasource as defined inside sakai.properties,
and this "myDS" settings should not be used.

Suggestions?

Thanks,

- Zhen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130726/32a85585/attachment.html