java.sql.SQLSyntaxErrorException: Column reference 'THIS.ID' is invalid, or is part of an invalid expression. For a SELECT list with a GROUP BY, the columns and expressions being selected may only contain valid grouping expressions and valid aggregate expressions.

db-derby-dev | Chris Wilson (JIRA) | 6 years ago
  1. 0

    [jira] Created: (DERBY-4955) Prepared statement fails when GROUP BY and SELECT clause contain the same expression based on a parameter

    db-derby-dev | 6 years ago | Chris Wilson (JIRA)
    java.sql.SQLSyntaxErrorException: Column reference 'THIS.ID' is invalid, or is part of an invalid expression. For a SELECT list with a GROUP BY, the columns and expressions being selected may only contain valid grouping expressions and valid aggregate expressions.
  2. 0

    DB/Schemifier Problem

    Google Groups | 8 years ago | Daniel Koller
    java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist.
  3. 0

    Spark+Hive的example运行问题 - SegmentFault

    segmentfault.com | 1 year ago
    java.sql.SQLSyntaxErrorException: Table/View 'VERSION' does not exist.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Auto-creating a database schema with hibernate /derby

    programask.com | 1 year ago
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
  6. 0

    [SQOOP-1841] Sqoop2: Upgrade from 1.99.1 to 1.99.4 onwards is broken - ASF JIRA

    apache.org | 1 year ago
    org.apache.sqoop.common.SqoopException: DERBYREPO_0003:Unable to run specified query - ALTER TABLE SQOOP.SQ_JOB DROP CONSTRAINT SQOOP.FK_SQB_SQN

  1. davidvanlaatum 4 times, last 2 days ago
  2. davidvanlaatum 1 times, last 1 month ago
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

    Column reference 'THIS.ID' is invalid, or is part of an invalid expression. For a SELECT list with a GROUP BY, the columns and expressions being selected may only contain valid grouping expressions and valid aggregate expressions.

    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException()
  2. Derby
    EmbedConnection.prepareStatement
    1. org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    2. org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
    3. org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
    4. org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    5. org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
    6. org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
    7. org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
    8. org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
    9. org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
    10. org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
    11. org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
    12. org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
    13. org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
    14. org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
    15. org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
    15 frames
  3. org.wfp.rita
    DerbyCrashTest.testPrepareQueryWithGroupByParameterFails
    1. org.wfp.rita.test.derby.DerbyCrashTest.testPrepareQueryWithGroupByParameterFails(DerbyCrashTest.java:82)
    1 frame
  4. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  5. JUnit
    TestSuite.run
    1. junit.framework.TestCase.runTest(TestCase.java:164)
    2. junit.framework.TestCase.runBare(TestCase.java:130)
    3. junit.framework.TestResult$1.protect(TestResult.java:106)
    4. junit.framework.TestResult.runProtected(TestResult.java:124)
    5. junit.framework.TestResult.run(TestResult.java:109)
    6. junit.framework.TestCase.run(TestCase.java:120)
    7. junit.framework.TestSuite.runTest(TestSuite.java:230)
    8. junit.framework.TestSuite.run(TestSuite.java:225)
    8 frames
  6. JUnit3 Runner
    RemoteTestRunner.main
    1. org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
    2. org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
    4. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
    5. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
    6. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
    6 frames