leonardo ginting [
http://community.jboss.org/people/onesleo] created the discussion
"expected number got Binary"
To view the discussion, visit:
http://community.jboss.org/message/634541#634541
--------------------------------------------------------------
hi guys i had an issue about expected number got binary does anybody knows what i should
to do to solve this problem
this is the stack trace
1. java.sql.BatchUpdateException: ORA-00932: inconsistent datatypes: expected NUMBER got
BINARY
2.
3. at
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
4. at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
5. at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)
6. at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
7. at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
8. at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
9. at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
10. at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
11. at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
12. at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
13. at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
14. at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
15. at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
16. at
id.co.compnet.api.keu.ctl.DetailPendapatanJpaController.create(DetailPendapatanJpaController.java:42)
17. at
id.co.compnet.PenerimaanDenda.PenerimaanDendaMBean.simpan(PenerimaanDendaMBean.java:391)
18. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
and this is on my bean at line 391
for (DetailPendapatan detail : listPenerimaanDenda) {
System.out.println("MASUK SIMPAN DETAIL PENDAPATAN");
detail.setMataUang("IDR");
detail.setPenerimaanid(pendapatan);
detail.setBiayaid(biaya);
detail.setBiaya(new BigDecimal(getNilai()));
detail.setSubtotal(new BigDecimal(getSubtotal()));
detail.setVariabel(new BigInteger(getJumlah().toString()));
detailPendapatan = detail;
// System.out.println("PRINT DETAIL PENERIMAAN PENDAPTAN
ID"+pendapatan +"BIAYA ID = "+biaya +" BIAYA = "+getNilai()
+"SUBTOTAL ="+getSubtotal()+"VARIABEL = "+getJumlah());
LINE 391 => dcont.create(detailPendapatan);
System.out.print("DETAIL ID
="+detailPendapatan.getDetailpendapatanid());
}
ive printed all the value and i got all the value but why im still getting this error?
any solution guys?
thanks in advance
--------------------------------------------------------------
Reply to this message by going to Community
[
http://community.jboss.org/message/634541#634541]
Start a new discussion in JBoss Web Development at Community
[
http://community.jboss.org/choose-container!input.jspa?contentType=1&...]