Re: How to handle LOB

[Alex Paransky]

If you are using CMT just make sure that your method is executing in a TX using the proper transaction attribute in your ejb-jar.xml.  If you are using BMT use the UserTransaction to start your own TX and commit at the end.

You cannot use Connection.commit() API, but you can use standard EJB methodologies in accomplishing the same thing.

--
-AP_
http://www.myprofiles.com/member/profile/apara_personal
http://www.myprofiles.com/member/profile/apara_business


Xie, Jinpeng wrote:

In Oracle database, if I want to insert or update LOB, I have to use
       Connection.setCommit(false);
       ResultSet resultSet = Statement.executeQuery("select ... for
update");
       Blob blob = resultSet.getBlob();
       InputStream inputStream = blob.getInputStream();
       ...
       Connection.commit();

How do I implement the above code in ejb because I can not run any
setCommit() or commit() in ejb container?
Jim

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".


--
-AP_
http://www.myprofiles.com/member/profile/apara_personal
http://www.myprofiles.com/member/profile/apara_business
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".