最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
当前位置: 首页 - 科技 - 知识百科 - 正文

selectnewTopicfrom'Mysql生成SQL语句异常

来源:动视网 责编:小采 时间:2020-11-09 13:34:43
文档

selectnewTopicfrom'Mysql生成SQL语句异常

selectnewTopicfrom'Mysql生成SQL语句异常:select new Topic from ' Mysql 生成SQL语句错误 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; Hibernate: select topic0_.id
推荐度:
导读selectnewTopicfrom'Mysql生成SQL语句异常:select new Topic from ' Mysql 生成SQL语句错误 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; Hibernate: select topic0_.id


select new Topic from ' Mysql 生成SQL语句错误 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; Hibernate: select topic0_.id as col_0_0_, topic0_.title as col_1_0_, topic0_.keyword a

select new Topic from ' Mysql 生成SQL语句错误
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;


Hibernate:
select
topic0_.id as col_0_0_,
topic0_.title as col_1_0_,
topic0_.keyword as col_2_0_,
topic0_.status as col_3_0_,
topic0_.recommend as col_4_0_,
topic0_.publishName as col_5_0_,
topic0_.publish_date as col_6_0_,
topic0_.channel_name as col_7_0_,
topic0_.author as col_8_0_,
. as col_9_0_
from
t_topic topic0_
inner join
t_attachment attachment1_
on topic0_.id=attachment1_.topic_id
where
1=1
and topic0_.status=1
and topic0_.channel_id=142 limit ?


"select new Topic (t.id, t.title, t.keyword, t.status, t.recommend,t.publishName, t.publishDate, t.channel_name,t.author,t.attachments) ";


本来是使用constructor的方法来设置query。
但是遇到这个onetomany的时候,貌似不能这么做。

Topic里面的Setattachments被hibernate弄到mysql数据库中就变成了错误的sql语句。


只能去掉select new Topic, 直接写成 from Topic。

谁知道怎么解决这个问题请告诉我。

文档

selectnewTopicfrom'Mysql生成SQL语句异常

selectnewTopicfrom'Mysql生成SQL语句异常:select new Topic from ' Mysql 生成SQL语句错误 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; Hibernate: select topic0_.id
推荐度:
标签: 创建 生成 错误
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top