com.solarmetric.jdbc.ReportingSQLException: ERROR: syntax error at or near "WHERE" {prepstmnt 16398807 SELECT AVG(t0.lengthinminutes) FROM WHERE t1.jdoclass = ? [reused=0]} [code=0, state=42601]

Oracle Community | 3004 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Query: Missing tablename in generated SQL for vertical mapped classes

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ERROR: syntax error at or near "WHERE" {prepstmnt 16398807 SELECT AVG(t0.lengthinminutes) FROM WHERE t1.jdoclass = ? [reused=0]} [code=0, state=42601]

    Root Cause Analysis

    1. com.solarmetric.jdbc.ReportingSQLException

      ERROR: syntax error at or near "WHERE" {prepstmnt 16398807 SELECT AVG(t0.lengthinminutes) FROM WHERE t1.jdoclass = ? [reused=0]} [code=0, state=42601]

      at kodo.query.AbstractQuery.executeWithMap()
    2. kodo.query
      AbstractQuery.execute
      1. kodo.query.AbstractQuery.executeWithMap(AbstractQuery.java:865)
      2. kodo.query.AbstractQuery.execute(AbstractQuery.java:728)
      2 frames