Message Boards

Custom Sql Split into multiple files

Jean Park, modified 3 Years ago.

Custom Sql Split into multiple files

New Member Posts: 7 Join Date: 10/9/19 Recent Posts
Hey all, 
I want to split the default.xml into multiple files but I get a null pointer exception
location of default xml: src/main/resources/META-INF/custom.sqldefault.xml:
<!--?xml version="1.0"?-->
<custom-sql>
&nbsp;&nbsp;&nbsp; <sql file="custom-sql/example.xml" />
</custom-sql>
example.xml
<!--?xml version="1.0"?-->
<custom-sql></custom-sql>

<sql id="methodToCall">

   SELECT * FROM myDataTable;
</sql> 
[code]


portal-ext.properties
custom.sql.configs=custom-sql/default.xml, META-INF/custom-sql/default.xml, custom-sql/projects.xml