Eclipse Community Forums: EclipseLink » quoted name and constraint

Help

Home

Home » Eclipse Projects » EclipseLink » quoted name and constraint

Show: Today's Messages :: Show Polls :: Message Navigator

quoted name and constraint [message #861457]

Sat, 28 April 2012 15:23

atao Missing name

Messages: 13
Registered: July 2009

Junior Member

Hello,

I'm using "delimited-identifiers" to get all the table and column names quoted. It works. But the quotes are still there inside the constraint name, e.g.:

Quote:

[EL Warning]: 2012-04-28 11:10:24.479--ServerSession(252116116)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Wrong data type: _7 in statement [ALTER TABLE "ABSTRACTTYPE" ADD CONSTRAINT UNQ_"ABSTRACTTYPE"_7]
Error Code: -16
Call: ALTER TABLE "ABSTRACTTYPE" ADD CONSTRAINT UNQ_"ABSTRACTTYPE"_7 UNIQUE ("NAME")
Query: DataModifyQuery(sql="ALTER TABLE "ABSTRACTTYPE" ADD CONSTRAINT UNQ_"ABSTRACTTYPE"_7 UNIQUE ("NAME")")

Did I miss something?

Regards
Pierre

Report message to a moderator