0 Replies Latest reply: Nov 2, 2011 3:40 AM by leonardo ginting RSS

expected number got Binary

leonardo ginting Newbie

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.     at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
  3.     at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
  4.     at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)
  5.     at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
  6.     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
  7.     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
  8.     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
  9.     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
  10.     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
  11.     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
  12.     at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
  13.     at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
  14.     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
  15.     at id.co.compnet.api.keu.ctl.DetailPendapatanJpaController.create(DetailPendapatanJpaController.java:42)
  16.     at id.co.compnet.PenerimaanDenda.PenerimaanDendaMBean.simpan(PenerimaanDendaMBean.java:391)
  17.     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