jsf - Getting an error "Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'User'." -
so connected "microsoft sql server 2008 r2 " through netbeans , loaded entities.i followed "https://netbeans.org/kb/docs/web/jsf20-crud.html#createdb" tutorial create basic jsf's. working fine entities.but 1 of entity name "user" when try "show user items" gives me error.
"internal exception: com.microsoft.sqlserver.jdbc.sqlserverexception: incorrect syntax near keyword 'user'."
i tried google error , read in 1 of posts since "user" keywork need escape name in jpa.entities , make @table("\"user\"").i tired , did not work.
i new using jsf's , working netbeans , databases.could let me know causing issue.thanks.
user reserved word of sqlserver database, can't name table it. group or role... try use "users" work fine!
Comments
Post a Comment