expected number got Binary
onesleo Nov 2, 2011 3:40 AMhi 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
- 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 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