Foren
CustomSQL in Liferay 7
lokesh gorrela, geändert vor 7 Jahren.
CustomSQL in Liferay 7
Regular Member Beiträge: 173 Beitrittsdatum: 09.03.16 Neueste Beiträge
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.
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, geändert vor 7 Jahren.
RE: CustomSQL in Liferay 7
Regular Member Beiträge: 195 Beitrittsdatum: 05.05.15 Neueste Beiträge
Hey @Jamie Sammons , do you know anything about this ? I am unfamiliar with this.
lokesh gorrela, geändert vor 7 Jahren.
RE: CustomSQL in Liferay 7
Regular Member Beiträge: 173 Beitrittsdatum: 09.03.16 Neueste Beiträge
Hi Andy Wu,
any solution.?
please take me out from this prob.
regards,
Lokesh.
any solution.?
please take me out from this prob.
regards,
Lokesh.
Jamie Sammons, geändert vor 7 Jahren.
RE: CustomSQL in Liferay 7
Expert Beiträge: 297 Beitrittsdatum: 05.09.14 Neueste Beiträge
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
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, geändert vor 7 Jahren.
RE: CustomSQL in Liferay 7
Regular Member Beiträge: 173 Beitrittsdatum: 09.03.16 Neueste Beiträge
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.
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, geändert vor 7 Jahren.
RE: CustomSQL in Liferay 7
Regular Member Beiträge: 195 Beitrittsdatum: 05.05.15 Neueste Beiträge
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, geändert vor 7 Jahren.
moving to portal dev
Liferay Legend Beiträge: 1123 Beitrittsdatum: 16.02.10 Neueste Beiträge
Moving to Liferay Portal development category.