Bug 906500 - quartz throwing NoClassDefFoundError: oracle/sql/BLOB
quartz throwing NoClassDefFoundError: oracle/sql/BLOB
Product: RHQ Project
Classification: Other
Component: Core Server (Show other bugs)
All All
urgent Severity high (vote)
: ---
: RHQ 4.6
Assigned To: Jay Shaughnessy
Mike Foley
: 911385 (view as bug list)
Depends On:
  Show dependency treegraph
Reported: 2013-01-31 12:52 EST by John Mazzitelli
Modified: 2013-09-03 10:46 EDT (History)
3 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2013-09-03 10:46:23 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description John Mazzitelli 2013-01-31 12:52:39 EST
Using Oracle (and 11.x JDBC driver), you get this in the RHQ Server and you can't do things like invoke operations:

Caused by: java.lang.NoClassDefFoundError: oracle/sql/BLOB
        at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.writeDataToBlob(OracleDelegate.java:645) [quartz-oracle-1.6.5.jar:1.6.5]
        at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.insertJobDetail(OracleDelegate.java:210) [quartz-oracle-1.6.5.jar:1.6.5]
Comment 1 Kosch 2013-01-31 13:05:20 EST
According to:


the source there in line 622+ should be changed e.g.
try {
Class blobClass = Class.forName("oracle.sql.BLOB");
 // then use reflection to put/trim

this avoids dependecy to legacy oracle.sql.BLOB import.
Of course additional implementation for current ojdbc driver is needed also.
Comment 2 Jay Shaughnessy 2013-02-01 10:50:01 EST
master commit bdcd5f13b9943fae99c35749bec4710c8c08f16a
Author: Jay Shaughnessy <jshaughn@redhat.com>
Date:   Fri Feb 1 10:48:06 2013 -0500

    I believe this is fixed.  I added an optional module dependency on the
    Oracle driver, for the server jar.  Our datasources had no problem, they
    are defined correctly to find/use the oracle driver, but since Quartz
    wants to perform a test directly against a driver class, we had to ensure
    the driver jar was accessible to the classloader.
Comment 3 John Mazzitelli 2013-03-11 14:45:36 EDT
*** Bug 911385 has been marked as a duplicate of this bug. ***
Comment 4 Heiko W. Rupp 2013-09-03 10:46:23 EDT
Bulk closing of issues in old RHQ releases that are in production for a while now.

Please open a new issue when running into an issue.

Note You need to log in before you can comment on or make changes to this bug.