Loading ...
Sorry, an error occurred while loading the content.
 

Bls: [netbeans-indonesia] inconsistent datatypes: expected NUMBER got BINARY

Expand Messages
  • Leonardo Ardo
    oya mas thnks sudh reply oya kurang lebih errornya gini mas javax.faces.el.EvaluationException: javax.persistence.RollbackException: Error while commiting the
    Message 1 of 5 , Nov 1, 2011
      oya mas thnks sudh reply oya kurang lebih errornya gini mas
      javax.faces.el.EvaluationException: javax.persistence.RollbackException: Error while commiting the transaction
      javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
      com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
      javax.faces.component.UICommand.broadcast(UICommand.java:387)
      org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)
      org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)
      org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)
      org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)
      com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
      com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
      com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
      javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
      org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
      org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:295)
      org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:393)
      org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:520)
      org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)


      java.sql.BatchUpdateException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY

      oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
      oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
      org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)
      org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
      org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
      org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
      org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
      org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
      org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
      org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
      org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
      org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
      org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
      id.co.compnet.api.keu.ctl.DetailPendapatanJpaController.create(DetailPendapatanJpaController.java:42)
      id.co.compnet.PenerimaanDenda.PenerimaanDendaMBean.simpan(PenerimaanDendaMBean.java:416)
      sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


      oya klo yang di method create nya itu seperti ini
      public void create(DetailPendapatan detailPendapatan) throws PreexistingEntityException, Exception {
      EntityManager em = null;
      try {
      em = getEntityManager();
      em.getTransaction().begin();
      em.persist(detailPendapatan);
      em.getTransaction().commit();
      } catch (Exception ex) {
      if (findDetailPendapatan(detailPendapatan.getDetailpendapatanid()) != null) {
      throw new PreexistingEntityException("DetailPendapatan " + detailPendapatan + " already exists.", ex);
      }
      throw ex;
      } finally {
      if (em != null) {
      em.close();
      }
      }
      }




      Dari: Ifnu bima <ifnubima@...>
      Kepada: netbeans-indonesia@yahoogroups.com
      Dikirim: Selasa, 1 November 2011 7:11
      Judul: Re: [netbeans-indonesia] inconsistent datatypes: expected NUMBER got BINARY

       
      > ada yang bisa kasi solusi nga ya kenapa hal ini terjadi
      > jadi ketika pas mau proses simpan itu langsung dapet error
      > expected NUMBER got BINARY

      error lengkapnya gimana ya?

      > dcont.create(detail);

      kode ini isinya apa yah?

      sepertinya kode yang kamu copy-paste di sini belum lengkap.

      --
      http://ifnubima.org/indo-java-podcast/
      http://tanyajava.com/download/javadesktop
      http://tanyajava.com/download/scrum
      @ifnubima

      regards


    • Ifnu bima
      ... sepertinya ada masalah dengan tipe data antara table dan Entity-nya. hmm mungkin masalahnya dengan ini : detail.setBiayaid(null); biaya id ini gak boleh
      Message 2 of 5 , Nov 1, 2011
        > java.sql.BatchUpdateException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY

        sepertinya ada masalah dengan tipe data antara table dan Entity-nya.

        hmm mungkin masalahnya dengan ini :

        detail.setBiayaid(null);

        biaya id ini gak boleh diset null? cek table kamu apakah ini nullable
        apa nggak.

        --
        http://ifnubima.org/indo-java-podcast/
        http://tanyajava.com/download/javadesktop
        http://tanyajava.com/download/scrum
        @ifnubima

        regards
      • Leonardo Ardo
        oya mas ifnu thanks for reply tapi setelah saya coba hapusĀ  ... juga tidak memberi dampak apa2 ... gmn ya? soale ud stuck berhari2 nihh
        Message 3 of 5 , Nov 1, 2011
          oya mas ifnu thanks for reply
          tapi setelah saya coba hapus 
          >detail.setBiayaid(null);
          juga tidak memberi dampak apa2
          :(
          gmn ya? soale ud stuck berhari2 nihh


          Dari: Ifnu bima <ifnubima@...>
          Kepada: netbeans-indonesia@yahoogroups.com
          Dikirim: Selasa, 1 November 2011 19:06
          Judul: Re: [netbeans-indonesia] inconsistent datatypes: expected NUMBER got BINARY

           
          > java.sql.BatchUpdateException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY

          sepertinya ada masalah dengan tipe data antara table dan Entity-nya.

          hmm mungkin masalahnya dengan ini :

          detail.setBiayaid(null);

          biaya id ini gak boleh diset null? cek table kamu apakah ini nullable
          apa nggak.

          --
          http://ifnubima.org/indo-java-podcast/
          http://tanyajava.com/download/javadesktop
          http://tanyajava.com/download/scrum
          @ifnubima

          regards


        Your message has been successfully submitted and would be delivered to recipients shortly.