JDBC Derby JPA Persistence testing issue "Internal Exception: java.sql.SQLSyntaxErrorException: Syntax error: Encountered 'USER'"

Question

I have an entity class called User and when I do persistence testing with Arquillian I have always have an error...

Internal Exception: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "USER" at line 1, column 13.

...because of the class name "User". I assume User is the reserved keyword. When I change my entity name to User_ it works fine.

Do I have to change my entity name? Is there anything else I can do to fix this issue?

score 6 · Accepted Answer · answered Apr 23 '13 at 08:11

6

Yes, USER is a built-in function in Derby. You'd have to specify a different table name for the JPA entity (usually done via the @Table annotation).

answered Apr 23 '13 at 08:11

Vineet Reynolds

76,006
17
150
174

JDBC Derby JPA Persistence testing issue "Internal Exception: java.sql.SQLSyntaxErrorException: Syntax error: Encountered 'USER'"

1 Answers1