René's URL Explorer Experiment

Title: act-ebean生成的sql语句没有根据数据库方言处理关健字 · Issue #20 · actframework/act-ebean-java7 · GitHub

Open Graph Title: act-ebean生成的sql语句没有根据数据库方言处理关健字 · Issue #20 · actframework/act-ebean-java7

X Title: act-ebean生成的sql语句没有根据数据库方言处理关健字 · Issue #20 · actframework/act-ebean-java7

Description: 最新版本发现一个问题：调用请求处理器 com.mycom.helloworld.UserController.list 时发生错误: Server Error javax.persistence.PersistenceException: Query threw SQLException:关键字 'user' 附近有语法错误。 Bind values:[] Query was: select t0.id c0, t0.name c1, t0.age c2, t0.rol...

Open Graph Description: 最新版本发现一个问题：调用请求处理器 com.mycom.helloworld.UserController.list 时发生错误: Server Error javax.persistence.PersistenceException: Query threw SQLException:关键字 'user' 附近有语法错误。 Bind values:[] Query was: select...

X Description: 最新版本发现一个问题：调用请求处理器 com.mycom.helloworld.UserController.list 时发生错误: Server Error javax.persistence.PersistenceException: Query threw SQLException:关键字 'user' 附近有语法错误。 Bind values:[] Query was...

Opengraph URL: https://github.com/actframework/act-ebean-java7/issues/20

X: @github

direct link

Domain: patch-diff.githubusercontent.com

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"act-ebean生成的sql语句没有根据数据库方言处理关健字","articleBody":"最新版本发现一个问题：调用请求处理器 com.mycom.helloworld.UserController.list 时发生错误: Server Error\r\n\r\njavax.persistence.PersistenceException: Query threw SQLException:关键字 'user' 附近有语法错误。\r\nBind values:[]\r\nQuery was:\r\nselect t0.id c0, t0.name c1, t0.age c2, t0.role_id c3, t0.create_date c4 from user t0\r\n\r\n原因是生成的sql没有根据数据库方言加上关健字的处理。上面的sql语句中，由user是数据库的关健字，正确生成是应该在关健字前后加上[]。如：select t0.id c0, t0.name c1, t0.age c2, t0.role_id c3, t0.create_date c4 from [user] t0\r\n\r\n使用的数据库产品是：sqlserver2014","author":{"url":"https://github.com/liaozi","@type":"Person","name":"liaozi"},"datePublished":"2018-10-30T00:32:52.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/20/act-ebean-java7/issues/20"}

Links:

Viewport: width=device-width