How to execute custom sql query using external database service builder ?

[Revathi Vadlamudi, modificado hace 6 años.]

I want to execute custom sql query in external database service builder, where query contains local tables and external database tables as well.

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 hace 6 años.]

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!