Home > Database > Mysql Tutorial > body text

select new Topic from ' Mysql 生成SQL语句异常

WBOY
Release: 2016-06-07 16:25:07
Original
1088 people have browsed it

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。

谁知道怎么解决这个问题请告诉我。
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template