Bolt, Dave wrote:
> Could you use the LOB locators function empty_blob() as a parameter?
Hmmmmmmmm. I'm not familiar with this. Is this something I can do in
the entity-bean code, or would I have to modify the JAWS code? I doubt
the JAWS authors would put an Oracle-specific patch (and I don't blame
them) into JAWS.
++Jeff
>
>
> -----Original Message-----
> From: Jeffrey Wescott [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 26, 2001 2:45 PM
> To: jBoss
> Subject: [jBoss-User] CMP (JAWS), Oracle and BLOBs
>
>
> 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]
