I haven't used BLOBs so I can't comment on a work around, hopefully
someone else has and can comment. As far as other Oracle drivers, I
don't know of any other type 4 drivers. Merant has a type 3 driver that
works well and may solve the problem you have. It is expensive though,
about $4000.00/cpu the last I checked :-(.
Scot.
Jeffrey Wescott wrote:
> Hi, all.
>
> I'm using JBoss-2.0-FINAL and have written several CMP Entity beans of
> the sort where there are nested entity beans and nested collections of
> entity beans, for example:
>
> Consider three entity beans: A, B and C. Entity Bean A has as a
> CMP-managed field a Collection of Entity bean C objects. Entity Bean
> B has as a CMP-managed field an Entity bean A object.
>
> As far as I can tell, JAWS handles this correctly. However, with the
> Oracle 8i driver (classes12.zip), there is one issue. In the
> ejbCreate() method for your beans, you have to make sure that any
> fields on the bean that map to the Oracle type "BLOB" are non-null.
> That means that in the example above, the ejbCreate() method for A
> would have to create an empty ArrayList or Vector for its collection
> field and the ejbCreate() method for B would have to create a non-null
> "dummy" A object. The reason is that the Oracle "thin" driver doesn't
> support passing null arguments for BLOB parameters in PreparedStatements.
>
> My questions are:
>
> 1- Has anyone come up with a good workaround for this aside from
> creating the dummy objects and empty Collections as I described
> above? If so, can I get some sample code?
>
> 2- Does anyone know of a type IV driver for Oracle that doesn't have
> this limitation?
>
> Please don't tell me to use the OCI driver for Oracle, because it's
> not an option for us.
>
> Thanks.
>
> ++Jeff
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
>
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
