MySQL Deposit Data Error Summary

Source: Internet
Author: User

elect T0.accusation_des, T0.submit_time, T0.result, T0.handle_time, T1.content, t4.nick_name,t5.content , T6.ask_title, T7.state_name,t8.item_name,t9.school_name,t10.school_name,t12.school_name,t14.school_name FR OM wxcommunity.t_accusation t0 left join wxcommunity.t_comment t1 on T1.commentid=T0.commentid left JOIN wxcommunity.t_ask T2 on T2.askid=T1.askid left JOIN wxcommunity.t_school T9 on T9.schoolid=T2.schoolid left JOIN wxcommunity.t_answer T3 on t1.answer_id=t3.answer_id left JOIN wxcommunity.t_ask t11 on T11.askid=T3.askid left JOIN wxcommunity.t_school t12 on T12.schoolid=T11.schoolid left JOIN wxcommunity.t_member T4 on T4.userid=T0.userid left Join Wxcommunity.t_answer T5 on t5.answer_id=t0.answer_id left JOIN wxcommunity.t_ask t13 on T13.askid=T5.askid left JOIN wxcommunity.t_school t14 on T14.schoolid=T13.schoolid left JOIN wxcommunity.t_ask T6 on T6.askid=T0.askid left JOIN wxcommunity.t_school T10 on T10.schoolid=T6.schoolid left JOIN wxcommunity.t_handle_state T7 on T7.stateid=T0.stateid left JOIN wxcommunity.t_accusation_item T8 on t8.accusation_item_id=t0.accusation_item_id WHERE (T0.askid> 0 or t0.answer_id > 0 or t1.askid > 0 or t1.answer_id > 0)

Summary: 1, the SQL statement with or logical relationship JPA query error, initially determine the JPA itself bug.

2, the above statement in the database directly query (NAVICAT Execute SQL statement) is not a problem, but in Java code to execute Executenativesql () error, the beginning of Mysql-connector-java query error to find out the data, Change a mysql-connector-java5.1.30 can detect the data but still wrong (the query record is always one less). The Mysql-connector-java driver itself is initially judged to be defective in Java code.

MySQL Deposit Data Error Summary

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.