[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6769) invalid Character - problem with aliasing

[bahadir guldiken (JIRA)]

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