Where should custom sql go in a maven build?

[12年前 に Marcus Svensson によって更新されました。]

Hi

I'm wondering if anyone have used custom sql when using build-service in a maven build?

When using ant the custom-sql/default.xml should go under /src/, but I haven't been able to find where to put it when using maven.
I've tried moving the folder around in most folders with no luck. So any tips on how to achieve this would be apprecieated.

Thanks!

[10年前 に Michael Rohleder によって更新されました。]

put it in the service-impl folder in src/main/webapp/custom-sql/default.xml so that maven packages it under /
I just came to this issue and after putting it there CustomSQLUtil.get() was able to find it.

[8年前 に Shalinee Tawar によって更新されました。]

For maven build we have to put custom-sql folder in project/src/main/resources/custom-sql folder. Which will create custom-sql folder in classes folder of project in tomcat at runtime.

[7年前 に Raja M によって更新されました。]

Michael Rohleder:

put it in the service-impl folder in src/main/webapp/custom-sql/default.xml so that maven packages it under /
I just came to this issue and after putting it there CustomSQLUtil.get() was able to find it.

This is not correct way of doing it,it should be under src/main/resources/custom-sql/default.xml because custom-sql/default.xml will come under web-inf/classes folder of project

[8年前 に Rahul Panchivala によって更新されました。]

hi marcus,

It should be in src\main\resources\resource-actions

[8年前 に Andrew Jardine によって更新されました。]

Rahul,

You should not put custom sql definitions in the resource-actions folder. The best practice is, as was previously suggested, to put them in a custom-sql folder. Putting them in the resource-actions would be confusing as people typically look in there for resource permissions, not custom sql.

The answer to the original question boils down to ... all resource files (properties, xml configs, etc) in maven projects should go in teh resources project folder.

[8年前 に Rahul Panchivala によって更新されました。]

Hi Andrew,

Thanks for correcting me...

[8年前 に Andrew Jardine によって更新されました。]

No problem. As I said, you can technically put them anywhere but, I personally recommend, it is best to just have a look at the Liferay source code and follow their pattern. If nothing else, it makes it really easy to move between your own source code and Liferay's.