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