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
  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