Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Warning from SQL

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

Back to the top