[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6769) invalid Character - problem with aliasing
bahadir guldiken (JIRA)
noreply at atlassian.com
Tue Oct 25 08:57:20 EDT 2011
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
More information about the hibernate-issues
mailing list