Hibernate version:
3.0.5
The generated SQL (show_sql=true):
Hibernate: select hibernatep0_.iddb as iddb, hibernatep0_.name as name6_, hibernatep0_.packageid as packageid6_, hibernatep0_.processdefinitionid as processd4_6_, hibernatep0_.processdefinitionversion as processd5_6_, hibernatep0_.processdefinitioncreated as processd6_6_, hibernatep0_.state as state6_ from processdefinitions hibernatep0_ where PackageId='test_bs' order by ProcessDefinitionCreated ASC

code:
session.createQuery("from HibernateProcessMgr where "+sqlWhere).list(); //sqlWhere="PackageId='test_bs' order by ProcessDefinitionCreated ASC"


Is it possible to have hsql do a insensitive check on property name. I get a 'sqlwhere' statement where properties are in a upper/lower case mix. I need to have hibernate do a query based on this statement. Unfortunately, i have no control on the generation of this sqlWhere statement, i have to manage with it. Is it possible to have hsql perform a case insensitive comparaison of property names or do i have to write code (and lots of such code) to convert propertynames to their correct value (like PackageId -> packageId)?

Help greatly appreciated.

SQL isn't case sensitive, there should be no problem doing what you want (so long as there are no joins causing one of your sqlWhere column names to be duplicated involved). Are you currently getting an error? What is it?

BTW I presume that you meant HQL when you wrote hsql. HSQL is the dialect of SQL used by HSQLDB, which is not related to Hibernate (though it is fully supported by Hibernate).

Yes i meant hql. Sorry for mistake.

my problem is, it's the names of object properties, not names of corresponding db field.

For example, some classe have properties that are mapped to bd fields with different name. My methods receives a "PackageId='test_bs' order by ProcessDefinitionCreated ASC" sql where clause, this aim the object properties names, not at the sql table.

So i need hql to do the propertyname -> fieldname mapping while not taking care of case in propertyname

btw, doesn't SQL request the alias of table be used inside where clause? (That is hql should generate 'where hibernatep0_.PackageId='test_bs' for query to work)

Errors during my attempt varied from sql grammar errror to empty result.

Was just hoping such case insensitiveness option existed.

you can do your own incasesensitive lookup for property names in the Configuration/ClassMetaData api if you really want this...

I suppose you mean going in class metadata, get list of properties, for each property, check if they are present in my where String, do the replacement and then only do issue the session.createQuery() :s
Was hoping to not have to code a query parser for the transformation.

well, its you who want random string matching, so it will cost you.