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]
