Community
Participate
Working Groups
Test Config: ----------- Eclipse Persistence Services - 2.4.0.v20111019-r10249 TimesTen 11.2.1.8.0 Test failed: ----------- org.eclipse.persistence.testing.tests.expressions.ReadAllOuterJoinExpressionTest.OuterJoinOnClauseTest -------- Internal Exception: java.sql.SQLException: [TimesTen][TimesTen 11.2.1.8.0 ODBC Driver][TimesTen]TT1001: Syntax error in SQL statement before or at: ",", character position: 173 -- file "ptSqlY.y", lineno 8161, procedure "reserved_word_or_syntax_error" Error Code: 1001 Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t2.SALARY, t1.START_TIME, t1.END_TIME, t1.END_DATE, t1.START_DATE, t1.ADDR_ID, t1.MANAGER_ID, t1.VERSION FROM , PROJECT t0, SALARY t2, EMPLOYEE t1 WHERE (t2.EMP_ID = t1.EMP_ID) Query: ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t2.SALARY, t1.START_TIME, t1.END_TIME, t1.END_DATE, t1.START_DATE, t1.ADDR_ID, t1.MANAGER_ID, t1.VERSION FROM , PROJECT t0, SALARY t2, EMPLOYEE t1 WHERE (t2.EMP_ID = t1.EMP_ID)") Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20111019-r10249): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: [TimesTen][TimesTen 11.2.1.8.0 ODBC Driver][TimesTen]TT1001: Syntax error in SQL statement before or at: ",", character position: 173 -- file "ptSqlY.y", lineno 8161, procedure "reserved_word_or_syntax_error" Error Code: 1001 Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t2.SALARY, t1.START_TIME, t1.END_TIME, t1.END_DATE, t1.START_DATE, t1.ADDR_ID, t1.MANAGER_ID, t1.VERSION FROM , PROJECT t0, SALARY t2, EMPLOYEE t1 WHERE (t2.EMP_ID = t1.EMP_ID) Query: ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t2.SALARY, t1.START_TIME, t1.END_TIME, t1.END_DATE, t1.START_DATE, t1.ADDR_ID, t1.MANAGER_ID, t1.VERSION FROM , PROJECT t0, SALARY t2, EMPLOYEE t1 WHERE (t2.EMP_ID = t1.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:2621) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2580) at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:420) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1082) 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:152) 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]TT1001: Syntax error in SQL statement before or at: ",", character position: 173 -- file "ptSqlY.y", lineno 8161, 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