nraveen
neo
Joined: 08/07/2014 15:27:10
Messages: 1
Offline
|
While trying to schedule jobs, quartz is throwing this exception.
Couldn't store job: ORA-22990: LOB locators cannot span transactions
Two quartz schedulers are running in two boxes in a clustered fashion pointing to the same DB. The quartz version used is 2.1.7.
I suspect the error is coming from
ps = conn.prepareStatement(rtp(UPDATE_ORACLE_JOB_DETAIL_BLOB));
ps.setBlob(1, dbBlob);
ps.setString(2, job.getKey().getName());
ps.setString(3, job.getKey().getGroup());
in OracleDelegate
Web search doesn't indicate any others have encountered the issue. Any help is greatly appreciated.
|