Forums Register Login

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

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
Sounds like you are setting the wrong type.

Perhaps include more info, and the full stack trace.
+Pie Number of slices to send: Send
Maybe you column database type is wrong? As James Sutherland said, could you post more details about the error?
+Pie Number of slices to send: Send
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
Beauty is in the eye of the tiny ad.
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 10669 times.
Similar Threads
er for Oracle][Oracle]ORA-00932: inconsistent datatypes: expecte NUMBER got BINARY
ORA-00932: inconsistent datatypes exception using WSAD 4.0.3 and oracle 8
Number to big decimal mapping problem in CMP
how to convert gregoriancalendar obj to sqldate?
hibernate mapping files for enumerated strings.
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 02:06:53.