net.sourceforge.jtds.jdbc.TdsException: Unprocessed data in input buffer. {prepstmnt 32433685 SELECT DISTINCT t0.id_i, t1.id_i, t1.rowversion_i, t1.budgeteddollars_f, t1.budgetedminutes_i, t1.closedate_dt, t1.defaultbillable_b, t1.default_billingcode_id_i, t1.duedate_dt, t1.modifiedby_person_id_i, t1.percentcomplete_f, t1.priority_id_i, t1.projectedstartdate_dt, t1.snapshotdate_dt, t1.status_id_i, t1.task_id_i FROM cor.t_task t0 INNER JOIN cor.t_tasksnapshot t1 ON t0.id_i = t1.task_id_i WHERE t0.project_id_i = ? [reused=2]} [code=0, state=HY000]

Oracle Community | 3004 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    statements with multiple updates/inserts

    Oracle Community | 1 decade ago | 3004
    net.sourceforge.jtds.jdbc.TdsException: Unprocessed data in input buffer. {prepstmnt 32433685 SELECT DISTINCT t0.id_i, t1.id_i, t1.rowversion_i, t1.budgeteddollars_f, t1.budgetedminutes_i, t1.closedate_dt, t1.defaultbillable_b, t1.default_billingcode_id_i, t1.duedate_dt, t1.modifiedby_person_id_i, t1.percentcomplete_f, t1.priority_id_i, t1.projectedstartdate_dt, t1.snapshotdate_dt, t1.status_id_i, t1.task_id_i FROM cor.t_task t0 INNER JOIN cor.t_tasksnapshot t1 ON t0.id_i = t1.task_id_i WHERE t0.project_id_i = ? [reused=2]} [code=0, state=HY000]

    Root Cause Analysis

    1. net.sourceforge.jtds.jdbc.TdsException

      Unprocessed data in input buffer. {prepstmnt 32433685 SELECT DISTINCT t0.id_i, t1.id_i, t1.rowversion_i, t1.budgeteddollars_f, t1.budgetedminutes_i, t1.closedate_dt, t1.defaultbillable_b, t1.default_billingcode_id_i, t1.duedate_dt, t1.modifiedby_person_id_i, t1.percentcomplete_f, t1.priority_id_i, t1.projectedstartdate_dt, t1.snapshotdate_dt, t1.status_id_i, t1.task_id_i FROM cor.t_task t0 INNER JOIN cor.t_tasksnapshot t1 ON t0.id_i = t1.task_id_i WHERE t0.project_id_i = ? [reused=2]} [code=0, state=HY000]

      at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap()
    2. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:124)
      2. com.solarmetric.jdbc.LoggingConnectionDecorator.access$600(LoggingConnectionDecorator.java:19)
      3. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:708)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:351)
      4 frames
    3. kodo.jdbc.runtime
      JDBCStoreManager$CancelPreparedStatement.executeQuery
      1. kodo.jdbc.runtime.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1701)
      1 frame
    4. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:338)
      1 frame
    5. kodo.jdbc.runtime
      JDBCStoreManager.getResult
      1. kodo.jdbc.runtime.JDBCStoreManager.getResultInternal(JDBCStoreManager.java:1005)
      2. kodo.jdbc.runtime.JDBCStoreManager.getResult(JDBCStoreManager.java:980)
      3. kodo.jdbc.runtime.JDBCStoreManager.getResultInternal(JDBCStoreManager.java:1036)
      4. kodo.jdbc.runtime.JDBCStoreManager.getResult(JDBCStoreManager.java:980)
      5. kodo.jdbc.runtime.JDBCStoreManager.getResult(JDBCStoreManager.java:966)
      5 frames
    6. kodo.jdbc.meta
      AbstractCollectionFieldMapping.load
      1. kodo.jdbc.meta.OneToManyFieldMapping.getResult(OneToManyFieldMapping.java:269)
      2. kodo.jdbc.meta.AbstractCollectionFieldMapping.load(AbstractCollectionFieldMapping.java:233)
      2 frames
    7. kodo.jdbc.runtime
      JDBCStoreManager.load
      1. kodo.jdbc.runtime.JDBCStoreManager.load(JDBCStoreManager.java:510)
      1 frame