To qualify column names use the escaped quotes around the column name.
@Column(name="\"group\"")
--Gordon
Carl Hall wrote:
I get the following warning when tables are created at
startup::
[EL Warning]: 2008.12.18
16:40:40.500--ServerSession(1463310136)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 1.0.1 (Build
20080905)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Syntax error: Encountered
"group" at line 1, column 111.
Error Code: 20000
Call: CREATE TABLE subject_permission (oid BIGINT GENERATED ALWAYS AS
IDENTITY NOT NULL, subjectToken VARCHAR(255), group VARCHAR(255),
permissionToken VARCHAR(255), role VARCHAR(255), PRIMARY KEY (oid))
Query: DataModifyQuery()
This is using Apache Derby (JavaDB). Is there a way to have the
generated SQL qualify the column names with quotes or is there another
fix for this problem?
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
|