invalid Character - problem with aliasing ----------------------------------------- Key: HHH-6769 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6769 Project: Hibernate Core Issue Type: Bug Components: core, query-hql Affects Versions: 3.2.6 Environment: oracle 10g, glassfish2.1, solarıs 10, Hibernate3.2.6GA Reporter: bahadir guldiken We have a system running for months without any problem. But somewhat it started to get intermittently: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query ORA-00911 illegal character When we enabled "show_sql" from persistence.xml, we get the following query: Hibernate: select party?dent0_.identity_id as identity1_36_, party?dent0_.description as descript2_36_, party?dent0_.identification_type_id as identifi9_36_, party?dent0_.identity_no as identity3_36_, party?dent0_.issue_date as issue4_36_, party?dent0_.lang_id as lang10_36_, party?dent0_.name as name36_, party?dent0_.party_id as party11_36_, party?dent0_.scan_image as scan6_36_, party?dent0_.validFor_end_date as validFor7_36_, party?dent0_.validFor_start_date as validFor8_36_ from party_identification party?dent0_ where party?dent0_.identity_no=?|#] It seems the aliasing "from party_identification party?dent0_" causing the problem by putting '?'. We suspected from locale or other things but turned away since restarting application was solving the problem for a random period. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira