Hibernate Community • View topic - Please help! How to use the to

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Please help! How to use the to_char in criteria?

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

sunilks

Post subject: Please help! How to use the to_char in criteria?

Posted: Sat Dec 13, 2008 7:28 pm

Newbie

Joined: Sat Dec 13, 2008 7:16 pm
Posts: 2

Hello All,

How do I represent the following query in Hibernate using criteria? The problem being a.Col1 is a number field in database and cannot be changed and the input value is a string from java.

Code:

select * from TABA a where CHAR(a.Col1) like '6%'

Top

SIau_Tie

Post subject: Re: Please help! How to use the to_char in criteria?

Posted: Mon Dec 15, 2008 3:40 am

Senior

Joined: Wed Sep 19, 2007 9:31 pm
Posts: 191
Location: Khuntien (Indonesia)

sunilks wrote:

Hello All,

How do I represent the following query in Hibernate using criteria? The problem being a.Col1 is a number field in database and cannot be changed and the input value is a string from java.

Code:

select * from TABA a where CHAR(a.Col1) like '6%'

You can use :

Code:

String sql = "CHAR(a.Col1) like '6%';
crit.add(Restrictions.sqlRestriction(sql));

Top

sunilks

Post subject: Thanks!

Posted: Wed Dec 24, 2008 10:50 am

Newbie

Joined: Sat Dec 13, 2008 7:16 pm
Posts: 2

Thanks SIau_Tie, the solution really did help and sorry couldn't reply earlier.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

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