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

Popular posts from this blog

assembly - 8086 TASM: Illegal Indexing Mode -

Java, LWJGL, OpenGL 1.1, decoding BufferedImage to Bytebuffer and binding to OpenGL across classes -

javascript - addthis share facebook and google+ url -