Hi,

can any help in this issues when i used '{' character? can we solve this issuse in hibernate?
I am using the native query
manager.createNativeQuery(query,WorkGroupEntity.class);

Caused by: java.lang.IllegalArgumentException: org.hibernate.QueryException: Unmatched braces for alias path [select wk.* from workgroup wk where UPPER(wk.WKG_NAME) = 'W{G' AND wk.BE_ID in (select be.be_id from Business_entity be where be.ORG_ID = 1)]
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:624)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:74)
at com.etrali.dke.administration.dao.WorkGroupDAO.findAll(WorkGroupDAO.java:173)

name.toUpperCase() = w{G
businessEntity.getOrganization().getId() = 1

String query = "select wk.* from workgroup wk where UPPER(wk.WKG_NAME) = '" +
name.toUpperCase() + "' AND wk.BE_ID in " +
"(select be.be_id from Business_entity be where be.ORG_ID = " +
businessEntity.getOrganization().getId() + ")";

I solved this problem by using setparameter for query object.

String query = "select wk.* from workgroup wk where UPPER(wk.WKG_NAME) = ? AND wk.BE_ID in " +
"(select be.be_id from Business_entity be where be.ORG_ID = " +
businessEntity.getOrganization().getId() + ")"

Query q1 = manager.createNativeQuery(query,WorkGroupEntity.class);
q1.setParameter(1, "W{G");

Because while parsing the createNativeQuery it is used to check the opened (or) closed braces so it will throw exception.

Hi there,

I have the same problem, but I can not use the same solution as yours, because in my case I am using native sql query when I am restoring backup archives of my system.
So it is a huge inserts which are generated dynamically based on backup XML file. I am parsing XML-s and further I am creating inserts based on xml data, and then executing those inserts by the native sql query. And when there is a '{' or '}' character - the system is crashing.
So for such a functional using 'setParameter()' solution is not acceptable.

Is there any other way to solve this bug? This is CRITICALLY IMPORTANT for me.
Please share with your ideas.

Thanks,
Harut.