Forums de discussion
How to execute custom sql query using external database service builder ?
Revathi Vadlamudi, modifié il y a 6 années.
How to execute custom sql query using external database service builder ?
Junior Member Publications: 82 Date d'inscription: 14/11/14 Publications récentes
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, modifié il y a 6 années.
RE: How to execute custom sql query using external database service builder
Liferay Legend Publications: 14919 Date d'inscription: 02/09/06 Publications récentes
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!