oracle的job锁定,Oracle application server使用Quartz JobStoreCMT遇到程序被锁问题

# re: Oracle application server使用Quartz JobStoreCMT遇到程序被锁问题

2009-06-25 17:00

Tenny

楼主：

我因为项目需要也是将quartz的jobstore从JobStoreTx更新为JobStoreCMT，我在servlet启动时没错，但是当我调度执行一个job时，在持久化存储job的Blob信息时出错：

配置环境:weblogic9.22 + oracle 10g + quartz1.6

org.quartz.JobPersistenceException: Couldn't store job: Driver's Blob representation is of an unsupported type: weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB [See nested exception: java.sql.SQLException: Driver's Blob representation is of an unsupported type: weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB]

．．．．

Caused by: java.sql.SQLException: Driver's Blob representation is of an unsupported type: weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB

．．．

我更新了oracle10g的最新jdbc驱动亦于事无补．我也不确信我的quartz配置是否正确，请帮我检查一下：

org.quartz.scheduler.instanceName = OnlineTaskQuartzScheduler

#org.quartz.scheduler.rmi.export = true

#org.quartz.scheduler.rmi.registryHost = localhost

#org.quartz.scheduler.rmi.registryPort = 1101

#org.quartz.scheduler.rmi.createRegistry = as_needed

org.quartz.scheduler.wrapJobExecutionInUserTransaction = true

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

org.quartz.threadPool.threadCount = 5

org.quartz.threadPool.threadPriority = 5

org.quartz.jobStore.misfireThreshold = 2592000000

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

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

org.quartz.jobStore.useProperties = false

org.quartz.jobStore.dataSource = myXADS

org.quartz.jobStore.nonManagedTXDataSource = myDS

org.quartz.jobStore.tablePrefix = QRTZ_

org.quartz.jobStore.isClustered = false

org.quartz.jobStore.dontSetAutoCommitFalse = true

org.quartz.jobStore.selectWithLockSQL =

org.quartz.dataSource.myXADS.jndiURL = ReportDataSource

org.quartz.dataSource.myXADS.jndiAlwaysLookup = DB_JNDI_ALWAYS_LOOKUP

org.quartz.dataSource.myXADS.java.naming.factory.initial = weblogic.jndi.WLInitialContextFactory

org.quartz.dataSource.myXADS.java.naming.provider.url = t3://localhost:7001

org.quartz.dataSource.myXADS.java.naming.security.principal = weblogic

org.quartz.dataSource.myXADS.java.naming.security.credentials = weblogic

org.quartz.dataSource.myDS.driver = oracle.jdbc.OracleDriver

org.quartz.dataSource.myDS.URL = jdbc:oracle:thin:@XXXXXXX:1521:dhcs

org.quartz.dataSource.myDS.user = XXXXX

org.quartz.dataSource.myDS.password = XXXXX

org.quartz.dataSource.myDS.maxConnections = 5

org.quartz.dataSource.myDS.validationQuery = select table_name from user_tables   回复  更多评论