Thread:
 Throws ORA-00932 when using composite-element 
 irfanmohammed   10 Jan 2005, 22:10 
 Re: Throws ORA-00932 when using composite-eleme... 
 Lukasz (Qr)   13 Jan 2005, 22:51 

Comment
Prev. thread 
 Next thread
 
Prev. posting 
 Next posting
From: irfanmohammed (10 Jan 2005, 22:10) Replies: 1, Views: 42250
Subject: Throws ORA-00932 when using composite-element
java.sql.BatchUpdateException: ORA-00932: inconsistent datatypes:
expected NUMBER got BLOB

	at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:458)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3907)
	at
net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
	at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
	at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421)
	at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2375)
	at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
	at
net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)

I have a POJO ChangeLog which has the blob and another POJO ChangeSet
which has ChangeLog as composite-element's. When I am creating a new
ChangeSet record with multiple ChangeLog records, I get the above exception.

I am using the copy/paste code in Lukasz's compilation and using Blob
instead of Clob. 

Using hibernate 2.1.6 and Oracle 9.2.0.1.0. 

Any help is greatly appreciated.
Prev. thread 
 Next thread
 
Prev. posting 
 Next posting
© Copyright 2006, Red Hat Middleware, LLC. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc. [Privacy Policy]