CustomSQL in Liferay 7

[lokesh gorrela, modificado hace 7 años.]

Hi All,
I followed this custom-sql link, to implement Custom-sql in liferay 7.
but, I am unable import CustomSQl("com.liferay.util.dao.orm.CustomSQLUtil")
in XXXFinderImpl class while implementing custom-sql methods.
for this i have seen this post
based on Jamie Sammons replay, i added ( compile ‘com.liferay:com.liferay.portal.dao.orm.custom.sql:1.0.3’ ) this property in build.gradle file, and i called get method like this,
String sql = CustomSQLUtil.get(XXX.class, FIND_BY_ENTRYNAME_ENTRYMESSAGE_GUESBOOKNAME);
after this i did build service and gradle refresh then it generated XXXFinder interface.
but XXXFinderUtil is not generating so that i am unable call the method in XXXLocalServiceImpl.

Is this process is correct in Liferay 7 module based custom sql implementaion.?
if yes, why XXXFinderUtil class is not generating.?
if Not, please give me steps to implement Custom sql in Liferay 7 module based plugin.
here XXX: Entity.
please give me quick replay.
thanks in advance..
regards,
Lokesh.

[Andy Wu, modificado hace 7 años.]

Hey @Jamie Sammons , do you know anything about this ? I am unfamiliar with this.

[lokesh gorrela, modificado hace 7 años.]

Hi Andy Wu,
any solution.?
please take me out from this prob.

regards,
Lokesh.

[Jamie Sammons, modificado hace 7 años.]

Hi Lokesh,

Take a look at the post you mentioned again. I attached a sample project that shows a working example of using CustomSQL.

-Jamie

[lokesh gorrela, modificado hace 7 años.]

Hi Andy Wu,
i am migrating 6.2 ext's into liferay 7 modules.
and i am migrating 6.2 portlets into 7 as legacy(not modules)
but i need portlet services in modules(ext's.)
how can i acheive this.?

regards,
Lokesh.

[Andy Wu, modificado hace 7 años.]

maybe you can use osgi service injection. for more information , please see https://dev.liferay.com/develop/tutorials/-/knowledge_base/7-0/introduction

[Gregory Amerson, modificado hace 7 años.]

Moving to Liferay Portal development category.