DO NOT REPLY [Bug 30085] New: - ClassCastException using Oracle BLOB if Oracle JDBC jar is in both /common/lib and [webapp]/lib

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=30085>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=30085

ClassCastException using Oracle BLOB if Oracle JDBC jar is in both /common/lib and [webapp]/lib

           Summary: ClassCastException using Oracle BLOB if Oracle JDBC jar
                    is in both /common/lib and [webapp]/lib
           Product: Tomcat 5
           Version: 5.0.25
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Catalina
        AssignedTo: tomcat-dev@jakarta.apache.org
        ReportedBy: elilevine@gmail.com


Reproduceble on both Windows 2000 and Solaris.

Use either classes12.zip (rename to classes12.jar) or ojdbc.jar from Oracle.

Place either of the jar files into both /common/lib and [webapp]/lib, configure
webapp to use org.apache.commons.dbcp.BasicDataSourceFactory in the context XML
file.

Get blob from Oracle database via ResultSet.getBlob() and cast it to a
oracle.sql.BLOB. --> ClassCastException occures even though the blob in the
ResultSet is an oracle.sql.BLOB, as indicated by debugger.

Solution: remove the Oracle JDBC jar from [webapps]/lib directory and everything
works fine.

Seems to be an issue with Catalina's classloader.

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-dev-help@jakarta.apache.org