[jboss-dev-forums] [JBoss Web Development] - expected number got Binary

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&...]