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

[leonardo ginting]

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&containerType=14&container=2112]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-dev-forums/attachments/20111102/cf9720a5/attachment.html