Eclipse Community Forums: EclipseLink » Criteria API: How-to cast an entity attribute?

Home

Home » Eclipse Projects » EclipseLink » Criteria API: How-to cast an entity attribute?

Criteria API: How-to cast an entity attribute? [message #540710]

Thu, 17 June 2010 03:01

Eclipse User

How do I build a Criteria API query to get a SQL statement like this:

select customer_no from customers where customer_no::varchar like '100%'

I tried to use the "like" Operator from CriteriaBuilder, but I have no idea how-to cast the numeric cutomer_no to a string (varchar)?

Kind regards,

André

Re: Criteria API: How-to cast an entity attribute? [message #540890 is a reply to message #540710]

Thu, 17 June 2010 10:45

Eclipse User

What database are you using?

On Oracle and many other databases LIKE will just work with numeric fields.
Otherwise you will need to call some database specific function to convert the numeric to a varchar, you can access the appropriate function for your database using the CriteriaBuilder function() API.

Previous Topic:	NullPointerException using mapped-superclass
Next Topic:	support for MaxDB 7.6.x?

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 19:05:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter