Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 361510

Summary: OuterJoinOnClauseTest failed on TimesTen with SQL Syntax error
Product: z_Archived Reporter: Praba Vijayaratnam <prabaharan.vijayaratnam>
Component: EclipselinkAssignee: Project Inbox <eclipselink.foundation-inbox>
Status: NEW --- QA Contact:
Severity: normal    
Priority: P3 CC: tom.ware
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Linux   
Whiteboard: timesten

Description Praba Vijayaratnam CLA 2011-10-20 05:23:44 EDT 
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)
Comment 1 Eclipse Webmaster CLA 2022-06-09 10:04:16 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink