java.sql.SQLException: Cannot be in ORDER BY clause in statement \[SELECT x."resfrom", x.SIZE,y.GROWTH FROM (SELECT "resfrom", SUM("size"\*"amountThousands") AS SIZE FROM "Factory2Base" AS a JOIN "BaseStatus" AS b ON a."baseID"=b."baseID" JOIN "ResUsageNoResearch" as r ON a."factorytype"=r."resto" WHERE  "doProduce"=true AND  (b."natID"=1 OR b."natID"=2) AND r."turnsTillAvail"=0 AND ( r."needsPort"=false OR b."portCurrent">0) GROUP BY "resfrom" ORDER BY "resfrom")\]

hsqldb | mabap | 9 years ago
  1. 0

    New restriction on ORDER BY in 1.8.0.8?

    hsqldb | 9 years ago | mabap
    java.sql.SQLException: Cannot be in ORDER BY clause in statement \[SELECT x."resfrom", x.SIZE,y.GROWTH FROM (SELECT "resfrom", SUM("size"\*"amountThousands") AS SIZE FROM "Factory2Base" AS a JOIN "BaseStatus" AS b ON a."baseID"=b."baseID" JOIN "ResUsageNoResearch" as r ON a."factorytype"=r."resto" WHERE  "doProduce"=true AND  (b."natID"=1 OR b."natID"=2) AND r."turnsTillAvail"=0 AND ( r."needsPort"=false OR b."portCurrent">0) GROUP BY "resfrom" ORDER BY "resfrom")\]
  2. 0

    how to resolve java.sql.SQLException: Table not found in statement

    Stack Overflow | 4 years ago | user1551750
    java.sql.SQLException: Table not found in statement [select * from "PUBLIC"."xxx"]
  3. 0

    Connect to Open Office odb file using jdbc program

    Stack Overflow | 5 years ago | Harshavardhan Konakanchi
    java.sql.SQLException: Table not found in statement [SELECT * FROM Emp]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    HSQLDB issue: Using HSQL as backend for the existing MVC application using JDBC template

    Stack Overflow | 5 years ago | AbdulAziz
    java.sql.SQLException: Table not found in statement [select id, description, price from products]

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Cannot be in ORDER BY clause in statement \[SELECT x."resfrom", x.SIZE,y.GROWTH FROM (SELECT "resfrom", SUM("size"\*"amountThousands") AS SIZE FROM "Factory2Base" AS a JOIN "BaseStatus" AS b ON a."baseID"=b."baseID" JOIN "ResUsageNoResearch" as r ON a."factorytype"=r."resto" WHERE  "doProduce"=true AND  (b."natID"=1 OR b."natID"=2) AND r."turnsTillAvail"=0 AND ( r."needsPort"=false OR b."portCurrent">0) GROUP BY "resfrom" ORDER BY "resfrom")\]

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcStatement.executeQuery
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
      3 frames