[jboss-jira] [JBoss JIRA] Commented: (EJBTHREE-517) multiple blob update operations hung up JBoss

multiple blob update operations hung up JBoss --------------------------------------------- Key: EJBTHREE-517 URL: http://jira.jboss.com/jira/browse/EJBTHREE-517 Project: EJB 3.0 Issue Type: Bug Affects Versions: EJB 3.0 RC5 - PFD Environment: oracle 10.1.0.2.0 Java 1.5.0_06 Windows XP. Reporter: Quande Ren Assigned To: Emmanuel Bernard I posted this in the forum, nobody post any reply, But I believe it is a bug, so I copied it here. The blob code works fine when there is only one blob operation within one transaction, however, if the transaction includes several blob update operation, then the JBoss hungs up there. Here is the entity code package test; import java.io.ByteArrayOutputStream; import java.io.InputStream; import java.sql.Blob; import javax.persistence.Basic; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.Lob; import javax.persistence.Table; import javax.persistence.Transient; import org.hibernate.Hibernate; @Entity @Table(name = "LongValue") public class LongValue { private Integer id; public LongValue() { } @Id public Integer getId() { return this.id; } public void setId(Integer id) { this.id = id; } private Blob theValue; @Lob @Basic(fetch=FetchType.LAZY) protected Blob getTheValue() { return theValue; } protected void setTheValue(Blob theValue) { this.theValue = theValue; } @Transient public void setValue(String aValue) throws Exception{ this.theValue=Hibernate.createBlob(aValue.getBytes()); } @Transient public String getValue() throws Exception{ Blob blob=this.getTheValue(); if(blob==null){ return null; } int length=(int)blob.length(); InputStream in=blob.getBinaryStream(); ByteArrayOutputStream bout=new ByteArrayOutputStream(length); byte[] b=new byte[1000]; while(true){ length=in.read(b); if(length<0){ break; } bout.write(b, 0, length); } in.close(); bout.close(); return new String(bout.toByteArray()); } } This code will success because there is only one blob update: LongValue lv=manager.find(LongValue.class,id1 ); lv.setValue(bigValue); This code will cause the jboss hung up there for unlimited time because there are several blob updates: LongValue lv=manager.find(LongValue.class,id1 ); lv.setValue(bigValue+"1"); lv=manager.find(LongValue.class,id2 ); lv.setValue(bigValue+"2"); lv=manager.find(LongValue.class,id3 ); lv.setValue(bigValue+"3"); lv=manager.find(LongValue.class,id4 ); lv.setValue(bigValue+"4"); the oracle table structure is like this: SQL> desc longvalue Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER(10) THEVALUE BLOB I checked that seems inserting several new records seems working. just updating several records does not work.