Bug 906500 - quartz throwing NoClassDefFoundError: oracle/sql/BLOB
Summary: quartz throwing NoClassDefFoundError: oracle/sql/BLOB
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: RHQ Project
Classification: Other
Component: Core Server
Version: 4.5
Hardware: All
OS: All
urgent
high
Target Milestone: ---
: RHQ 4.6
Assignee: Jay Shaughnessy
QA Contact: Mike Foley
URL:
Whiteboard:
: 911385 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-01-31 17:52 UTC by John Mazzitelli
Modified: 2013-09-03 14:46 UTC (History)
3 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2013-09-03 14:46:23 UTC
Embargoed:

Attachments (Terms of Use)

Description John Mazzitelli 2013-01-31 17:52:39 UTC 
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 18:05:20 UTC 
According to:

svn.terracotta.org/svn/quartz/trunk/quartz-oracle/src/main/java/org/quartz/impl/jdbcjobstore/oracle/OracleDelegate.java

the source there in line 622+ should be changed e.g.
try {
Class blobClass = Class.forName("oracle.sql.BLOB");
if(blobClass.isInstance(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 15:50:01 UTC 
master commit bdcd5f13b9943fae99c35749bec4710c8c08f16a
Author: Jay Shaughnessy <jshaughn>
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 18:45:36 UTC 
*** Bug 911385 has been marked as a duplicate of this bug. ***
Comment 4 Heiko W. Rupp 2013-09-03 14:46:23 UTC 
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.