These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 
Author Message
 Post subject: hibernate.query.substitutions doesn't work for quoted value?
PostPosted: Mon Mar 07, 2011 8:09 pm 
Newbie

Joined: Thu Mar 03, 2011 3:24 pm
Posts: 9
I'm moving an app using hibernate from postgres to oracle, and it has hql queries with

Code:
from Tab t left join fetch t.template where t.id = :tabId and t.deleted = 'false'"


notice the single quotes around the false value. I have the following in my hibernate properties:

Code:
<entry key="hibernate.query.substitutions" value="true 1, false 0, 'true' 1, 'false' 0" />
       


but it will only replace the value if i change the query to remove the quotes around true/false. i'd rather not have to make these changes all over the place, am I missing something?


Top
 Profile  
 
 Post subject: Re: hibernate.query.substitutions doesn't work for quoted value?
PostPosted: Mon Mar 14, 2011 12:49 pm 
Newbie

Joined: Thu Mar 03, 2011 3:24 pm
Posts: 9
bump


Top
 Profile  
 
 Post subject: Re: hibernate.query.substitutions doesn't work for quoted value?
PostPosted: Wed Mar 16, 2011 9:31 am 
Newbie

Joined: Thu Mar 03, 2011 3:24 pm
Posts: 9
I didn't think this was a hard question, am I missing something? Is more information needed?


Top
 Profile  
 
 Post subject: Re: hibernate.query.substitutions doesn't work for quoted value?
PostPosted: Tue May 03, 2011 2:31 pm 
Newbie

Joined: Thu Mar 03, 2011 3:24 pm
Posts: 9
still would like to know if this can work-


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.