This is more likely to be to do with isolation level than transactionality
(although the two are closely related). You might try setting:
<entity-deployment name="YourBean" isolation="repeatable_read">
...
</entity-deployment>
in your orion-ejb-jar.xml.
Disclaimer: I could well be wrong, I often am!
Regards,
Dan/tastapod
At 15:48 11/04/2001 +0100, you wrote:
>Hi,
>
>I have a BMP entity bean that maps to an Oracle table with a CLOB field. I
>can read the CLOB in OK but when trying to write to it I get an 'ORA-01002:
>fetch out of sequence' error.
>
>This error can be caused by a commit being called between retrieving the
>CLOB locator with a SELECT... FOR UPDATE and trying to write to the CLOB's
>output stream.
>
>I solved this for ejbCreate() by setting the create() method's transaction
>attribute to 'Required'. However, I can't give the ejbStore() method a
>transaction attribute as it can only be called by the container.
>
>I have got around this like so:
>
>By default, ejbStore() is called by the container after every call to any
>method in the bean instance, whether or not the bean's state is changed.
>Implementing the public boolean isModified() method stops ejbStore() being
>called every time as the container first checks that true is returned by
>this method. Setting a 'Required', 'Requires New' or 'Mandatory' transaction
>attribute for all methods that set the 'modified' boolean to true seems to
>ensure that ejbStore() is now only called inside a transaction.
>
>This seems to solve the problem but I'd like to be sure that my assumptions
>are correct and that this WILL prevent ejbStore() from ever being called
>outside a transaction. Also, is it possible to set a
>transaction attribute for ejbStore()?
>
>Thanks,
>
>Paul
>
>
>
>http://www.iii.co.uk
>Interactive Investor International is a leading UK Internet personal
>finance service that provides individuals with the capability to identify,
>compare, monitor and buy online a number of financial products and services.
>
>Interactive Investor Trading Limited, a subsidiary of Interactive Investor
>International plc, is regulated by the SFA.
--
Dan North
VP Development - Cadrion Software Ltd - +44 (0)20 7440 9550
CONFIDENTIALITY
This e-mail and any attachments are confidential
and may also be privileged. If you are not the named recipient,
please notify the sender immediately and do not disclose the
contents to another person, use it for any purpose, or store
or copy the information in any medium
