Community
Participate
Working Groups
Bug seems similar to Bug 278978 Following tests failed from foundation tests on TimesTen 11.2.1.8.0 (using both OracleMode and TimesTenMode): org.eclipse.persistence.testing.tests.expressions.ReadAllExpressionTest.SubSelectSelectClauseTest org.eclipse.persistence.testing.tests.expressions.ReadAllExpressionTest.SubSelectSelectClauseTest2 ------------ Internal Exception: java.sql.SQLException: [TimesTen][TimesTen 11.2.1.8.0 ODBC Driver][TimesTen]TT7025: Illegal use of reserved keyword "SELECT", character position: 31 -- file "ptSqlY.y", lineno 8158, procedure "reserved_word_or_syntax_error" Error Code: 7025 Call: SELECT t0.EMP_ID, t0.F_NAME, (SELECT COUNT(t2.PROJ_ID) FROM PROJ_EMP t3, PROJECT t2 WHERE ((t3.EMP_ID = t0.EMP_ID) AND (t2.PROJ_ID = t3.PROJ_ID))) FROM EMPLOYEE t0, SALARY t1 WHERE (t1.EMP_ID = t0.EMP_ID) Query: ReportQuery(referenceClass=Employee sql="SELECT t0.EMP_ID, t0.F_NAME, (SELECT COUNT(t2.PROJ_ID) FROM PROJ_EMP t3, PROJECT t2 WHERE ((t3.EMP_ID = t0.EMP_ID) AND (t2.PROJ_ID = t3.PROJ_ID))) FROM EMPLOYEE t0, SALARY t1 WHERE (t1.EMP_ID = t0.EMP_ID)") Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20111116-r10398): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: [TimesTen][TimesTen 11.2.1.8.0 ODBC Driver][TimesTen]TT7025: Illegal use of reserved keyword "SELECT", character position: 31 -- file "ptSqlY.y", lineno 8158, procedure "reserved_word_or_syntax_error" Error Code: 7025 Call: SELECT t0.EMP_ID, t0.F_NAME, (SELECT COUNT(t2.PROJ_ID) FROM PROJ_EMP t3, PROJECT t2 WHERE ((t3.EMP_ID = t0.EMP_ID) AND (t2.PROJ_ID = t3.PROJ_ID))) FROM EMPLOYEE t0, SALARY t1 WHERE (t1.EMP_ID = t0.EMP_ID) Query: ReportQuery(referenceClass=Employee sql="SELECT t0.EMP_ID, t0.F_NAME, (SELECT COUNT(t2.PROJ_ID) FROM PROJ_EMP t3, PROJECT t2 WHERE ((t3.EMP_ID = t0.EMP_ID) AND (t2.PROJ_ID = t3.PROJ_ID))) FROM EMPLOYEE t0, SALARY t1 WHERE (t1.EMP_ID = t0.EMP_ID)") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1716) at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:1195) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:646) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2672) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2615) at org.eclipse.persistence.queries.ReportQuery.executeDatabaseQuery(ReportQuery.java:851) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844) at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1041) at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:392) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2830) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1515) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1497) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1448) at org.eclipse.persistence.testing.framework.ReadAllTest.test(ReadAllTest.java:116) at org.eclipse.persistence.testing.tests.expressions.ReadAllExpressionTest.test(ReadAllExpressionTest.java:153) at org.eclipse.persistence.testing.framework.TestCase.executeTest(TestCase.java:545) at org.eclipse.persistence.testing.framework.TestCase.execute(TestCase.java:156) at org.eclipse.persistence.testing.framework.TestCase.runBare(TestCase.java:265) at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:248) at org.eclipse.persistence.testing.framework.TestSuite.execute(TestSuite.java:75) at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313) at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:248) at org.eclipse.persistence.testing.framework.TestModel.execute(TestModel.java:211) at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313) at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:248) at org.eclipse.persistence.testing.framework.TestModel.execute(TestModel.java:211) at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313) Caused by: java.sql.SQLException: [TimesTen][TimesTen 11.2.1.8.0 ODBC Driver][TimesTen]TT7025: Illegal use of reserved keyword "SELECT", character position: 31 -- file "ptSqlY.y", lineno 8158, procedure "reserved_word_or_syntax_error" at com.timesten.jdbc.JdbcOdbc.createSQLException(JdbcOdbc.java:3242) at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:3391) at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:3356) at com.timesten.jdbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:881) at com.timesten.jdbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:361) at com.timesten.jdbc.JdbcOdbcPreparedStatement.executeQuery(JdbcOdbcPreparedStatement.java:265) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:931) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:607)
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink
