Using hibarnate: java.sql.sqlexception:ora-00911: Invalid character, solving ideas

Source: Internet
Author: User

1. See: Hibernat automatically generated SQL query statements

Hibernate:Select *  from(Selectmodule0_. module_id asModule_id1_1_, module0_. Create_by asCreate_by2_1_, module0_. Create_dept asCreate_dept3_1_, module0_. Create_time asCreate_time4_1_, module0_. Update_by asUpdate_by5_1_, module0_. Update_time asUpdate_time6_1_, module0_. BELONG asBelong7_1_, module0_. Cpermission asCpermission8_1_, module0_. CTYPE asCtype9_1_, module0_. CURL asCurl10_1_, module0_. Cwhich asCwhich11_1_, module0_. ICO; asIco12_1_, Module0_.is_leaf asIs_leaf13_1_, module0_. Layer_num asLayer_num14_1_, asName15_1_, module0_. Order_no asOrder_no16_1_, module0_. parent_id asParent_id17_1_, module0_. Parent_name asParent_name18_1_, module0_. Quote_num asQuote_num19_1_, module0_. REMARK asRemark20_1_, module0_. State asState21_1_ fromModule_p module0_)whereRowNum<=?

2. Put the SQL statement in the Plsql software to execute, you can find the statement error place

Using hibarnate: java.sql.sqlexception:ora-00911: Invalid character, solving ideas

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: 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.