Geek Answers Handbook

Java Spring Framework + Quartz Clustering for N-different Node Networks

I get the following excetion - org.quartz.impl.jdbcjobstore.LockException: Error getting row lock db: ORA-00942: table or view does not exist [See nested exception: java.sql.SQLException: ORA-00942: table or view does not exist].

I already worked with the same code, but the database was Mysql . But suddenly we decided to transfer the database to ORACLE.

And we get above the java Exceptions.

In my opinion, I think that when it initially works, it will enter the following entries in the database table: PREFIX_LOCKS

STATE_ACCESS TRIGGER_ACCESS

Automatically, but here he tries, but crashes due to ORA-00942.

Now the My Quartz Config file looks like this:

#=====================================
# Configure Instance
#=====================================

    org.quartz.scheduler.instanceName = MyClusteredScheduler

    org.quartz.scheduler.instanceId = AUTO

#===================================
# Configure ThreadPool
#===================================

    org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool

    org.quartz.threadPool.threadCount = 25

    org.quartz.threadPool.threadPriority = 5


#===================================
# Configure JobStore
#===================================

    org.quartz.jobStore.misfireThreshold = 60000

    org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX

    org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.oracle.OracleDelegate

    org.quartz.jobStore.useProperties = false

    org.quartz.jobStore.tablePrefix = TABLE_PREFIX_NAME

    org.quartz.jobStore.dataSource = customDataSourceName

    org.quartz.jobStore.isClustered = true

    org.quartz.jobStore.clusterCheckinInterval = 20000

#===================================
# Configure Datasources  
#====================================

    org.quartz.dataSource.customDataSourceName.jndiURL =
    java:comp/env/jdbc/SomeName

    org.quartz.dataSource.customDataSourceName.maxConnections = 5

    org.quartz.dataSource.customDataSourceName.validationQuery = 
    select 0 from dual

#================== END OF FILE ==========

. Oracle , , Schema wise (, ).

- , wrog?

0
1

.

, start() (..). , ,

1. schedule job
2. start method invoke

, try.. catch...

.

0

More articles:


All Articles