[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Java Persistence CLOB exception

[sbattarusetty]

Hi,

I am getting the exception (java.sql.SQLException: operation not allowed: streams type cannot be used in batching) while persistent Clob column under JBoss 4.2.3 and Java 6 environment. Does anyone know how fix this exception?

	@Lob
	@Basic(fetch=FetchType.LAZY)
	@Column(name="source_xml")
	public String getSourceXml() {
		return sourceXml;
	}
	public void setSourceXml(String sourceXml) {
		this.sourceXml = sourceXml;
	}

2008-11-06 18:53:35,741 (WorkManager(2)-21:) DEBUG JDBCExceptionReporter.logExceptions - could not insert: [com.ghx.ci.purchaseorder.ejb.entity.CIPurchaseOrderEntityBean] [insert into ci_purchase_order (releasenumber, buyer_id, supplier_id, source_xml, id) values (?, ?, ?, ?, ?)]
java.sql.SQLException: operation not allowed: streams type cannot be used in batching
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:4073)
	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.addBatch(WrappedPreparedStatement.java:386)
	at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:31)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
	at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:515)
	at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:114)
	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:247)
	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:86)
	at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
	at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1389)
	at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
	at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
	at org.jboss.resource.adapter.jms.inflow.JmsServerSession$XATransactionDemarcationStrategy.end(JmsServerSession.java:494)
	at org.jboss.resource.adapter.jms.inflow.JmsServerSession.run(JmsServerSession.java:248)
	at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:204)
	at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:275)
	at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:756)
	at java.lang.Thread.run(Unknown Source)

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4187574#4187574

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4187574