JPA concat operator

java jpa jpa-2.0 concatenation jpql
Udo Held picture Udo Held · Dec 14, 2011 · Viewed 49.2k times · Source

Is there a JPA concat operator for string concatenation?

I know there is a JPA CONCAT function, however its ugly to use for concatenating multiple strings.

CONCAT(CONCAT(CONCAT(cola,colb),colc),cold)

Vendors like Oracle offer || some other like Microsoft offer +. Is there a standard JPA concatenation operator so that I could create a query like

cola || colb || colc || cold

I tried + using openjpa with SQL Server, however it seems to be invalid JPQL. I couldn't find anything regarding such an operator in an oracle reference.

Answer

Jörn Horstmann picture Jörn Horstmann · Dec 14, 2011

The CONCAT function was extended in JPA 2.0 to allow passing more than 2 parameters, from section 4.6.17.2.1 (String Functions) of the specification:

CONCAT(string_primary, string_primary {, string_primary}* )

In JPA 1 this was restricted to exactly two parameters.

Related questions

JPA CascadeType.ALL does not delete orphans

I am having trouble deleting orphan nodes using JPA with the following mapping @OneToMany (cascade = CascadeType.ALL, fetch = FetchType.EAGER, mappedBy = "owner") private List<Bikes> bikes; I am having the issue of the orphaned roles hanging around the …

Read More
JPA Query selecting only specific columns without using Criteria Query?

Is it possible to select, say, only properties A and B from an object using a JPA query without using criteria queries? To select all properties I'd just do something like: SELECT i FROM ObjectName i WHERE i.id = 10 But …

Read More
How to define unidirectional OneToMany relationship in JPA

I have a following problem with entity mapping in JPA. I have two entities, first one is Lookup and the second is Text which represents translations for entities. Now I need to bound Lookup to the Text but I don't …

Read More