Re: How to create a LIKE Statement???

[Alexander Prozor]

It works well with non number fields.
I think that you have to look at generated SQL and trying to build right 
criteria.
(you can see all generated SQL queries by setting 
driver="com.p6spy.engine.spy.P6SpyDriver" in datavase_repository.xml file)
sorry, if it will not help you, but I've never used like criteria with 
NUMBER fields.

Hi,
I�m trying to make a 

SELECT * FROM Table WHERE Field LIKE 'XY%'

I thought a 

Criteria theCriteria = new Criteria();
theCriteria.addLike("myAttributeName", anAttributeValue);
// where the Attribute Type is BigDecimal
should do the Job.

But I�m getting a ClassCastException (I think because of the String-Cast 
at the "addLike(...)" method of Criteria.

But even a:
theCriteria.addLike("myAttributeName", anAttributeValue+"*");
leads to a ClassCastException because of the DatabaseType BigDeciamal or 
NUMERIC.

Any help would be appreciated!

Greetings,
Mit freundlichen Gr��en,
Ralf Baron-Riege



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]