Hi everybody.
I'm currently working on a J2SE application and i'm using JPA as persistence framework, it works very fine, but when I try to do a query with a function CONCAT it came with an error:
+
Caused by: Exception [TOPLINK-8025] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.EJBQLException
Exception Description: Syntax error parsing the query [SELECT CONCAT(CONCAT(d.nombre, ' ', CONCAT(d.apellidoPaterno, ' ') d.apellidoMaterno)) FROM Datospersonales as d, Personaljuzgado as p WHERE p.idDatosPersonales = d.idDatosPersonales ], line 1, column 8: unexpected token [CONCAT].
Internal Exception: line 1:8: unexpected token: CONCAT
+
The statement in MySQL that I'm trying to do is :
+
SELECT CONCAT(datospersonales.nombre, ' ', datospersonales.apellidoPaterno, ' ', datospersonales.apellidoMaterno )
FROM datospersonales, personaljuzgado
WHERE personaljuzgado.idDatosPersonales = datospersonales.idDatosPersonales;
+
Any help will be grateful, thanx a lot :D