Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.BatchUpdateException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY

 
leonardo ginting
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi guys i got this error does anybody know what caused this error
and this is my Bean

and my error always pointing at "create" method,,

need your solution guys
thanks in advance
 
James Sutherland
Ranch Hand
Posts: 553
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sounds like you are setting the wrong type.

Perhaps include more info, and the full stack trace.
 
Hebert Coelho
Ranch Hand
Posts: 754
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Maybe you column database type is wrong? As James Sutherland said, could you post more details about the error?
 
leonardo ginting
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
this is the stack trace
java.sql.BatchUpdateException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
at id.co.compnet.api.keu.ctl.DetailPendapatanJpaController.create(DetailPendapatanJpaController.java:42)
at id.co.compnet.PenerimaanDenda.PenerimaanDendaMBean.simpan(PenerimaanDendaMBean.java:391)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


and this is in my Bean at line 391



i've printed the all the value that i want to insert to DB on the LOG and all the value is got
but why still i got that error?
thanks guys need your solutions
gb
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic