Fórum
How to execute custom sql query using external database service builder ?
Revathi Vadlamudi, modificado 6 Anos atrás.
How to execute custom sql query using external database service builder ?
Junior Member Postagens: 82 Data de Entrada: 14/11/14 Postagens Recentes
I want to execute custom sql query in external database service builder, where query contains local tables and external database tables as well.
When I try to call FinderImpl method, db is searching for localtable. Is there any solution for this ?
select * from localtable l
inner join externaltable e on e.localtableId = l.localtableId
When I try to call FinderImpl method, db is searching for localtable. Is there any solution for this ?
David H Nebinger, modificado 6 Anos atrás.
RE: How to execute custom sql query using external database service builder
Liferay Legend Postagens: 14919 Data de Entrada: 02/09/06 Postagens Recentes
Okay, maybe you're not aware of this, but you cannot execute queries that apply across different DB connections. Period. This is a database/SQL thing, it has nothing to do with ServiceBuilder or Liferay or even Java.
Come meet me at Devcon 2017 or 2017 LSNA!
Come meet me at Devcon 2017 or 2017 LSNA!