This content has been marked as final. Show 2 replies
I face a problem with a BLOB field in Oracle 8.1.7. Maybe this has been asked a thousand times, but I can't find a solution / question via "search". ;-)
I want to use Entity Beans to access this field via CMP.
I have the same problem with CLOB, CMP entity beans and Oracle 9i for an application we're migrating from Weblogic to JBoss 4.0.3SP1.
I've found this come from the fact that, until Oracle 10g, Oracle doesn't support the standard interfaces java.sql.Clob and java.sql.Blob. If you were not doing it in a CMP entity bean, you would receive an "unsupported feature" exception when you try to access your LOBs from these interfaces. To solve that, you would then have to cast your java.sql.Clob into oracle.sql.CLOB or java.sql.Blob into oracle.sql.BLOB respectively and then you would have to call proprietary Oracle methods to access it.
Weblogic had special tags in the deployment descriptors for OracleClob and OracleBlob in CMP entity beans. I can't manage to find the same in JBoss. If ever I can find it, I'll keep you informed.
I've found a workaround: use the OCI driver. It works then.