| EclipseLink Test suite and Ingres [message #381667] |
Mon, 29 September 2008 20:33  |
 Usha Rajsekar
Messages: 8
Registered: July 2009 |
Junior Member |
|
|
Hi,
Running eclipselink foundation SRG tests against Ingres results in the
following syntax error. I was wondering how to tell the EclipseLink
framework that keywords such as CASCADE or RESTRICT must be followed by
the ALTER TABLE statement for Ingres. i.e for example:
ALTER TABLE SALARY DROP CONSTRAINT FK_SALARY_EMP_ID CASCADE
Which DatabasePlatform interface method need to be implemented in
IngresPlatform.java so that EclipseLink framework knows that these
keywords need to be used with Ingres for the ALTER TABLE DML statement? OR
is there any other configuration that I am missing?
Eclipselink foundation core tests (ant test-core) seems to have run
succesfully.
Any pointers appreciated.
Regards,
Usha
snippet from test-results.xml:
Call: ALTER TABLE SALARY DROP CONSTRAINT FK_SALARY_EMP_ID
Query: DataModifyQuery()
[EL Warning]: 2008.09.29
19:35:04.143--DatabaseSessionImpl(1377187)--Exception [EclipseLink-4002]
(Eclipse Persistence Services - 1.0 (Build SNAPSHOT-20080929)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.ingres.gcf.util.SqlEx: line 1, Syntax error on
'EOF'. The correct syntax is:
ALTER TABLE tablename
ADD [CONSTRAINT constraint_name] constraint_clause
| DROP CONSTRAINT constraint_name RESTRICT | CASCADE
| ADD [COLUMN] columnname format [default_clause] [null_clause]
[column_constraint]
| DROP [COLUMN] column_name RESTRICT | CASCADE
| ALTER [COLUMN] columnname format [default_clause] [null_clause]
Error Code: 3850
|
|
|
] 
Search
Help
Register
Login
Home
