Question regarding Jetspeed2.2 build process - sql schema

[Arun Wagle]

Hi,

I am using Jetspeed2.2 and trying to do a build.

The problem which I am facing right now is that I have some custom database
scripts which I want to execute as a part of the build process, wherein the
FORMAT of sql has to be maintained.
I want to know how do we do that in the current Jetspeed 2.2 where it is
using "execute-sql" plugin.
Is there something in the "script" tag below that we can specify to retain
the format of the sql ?

In the prior release where it was using ant scripts, I could specify a
parameter called "keepformat" for the sql task.

 <configuration>
              <sql>
                <scripts>
                  *<script>
                    *<!--
path>${project.build.directory}/ddl/@database.type@
/${org.apache.jetspe...@database.type@.database.default.name
}/drop-schema.sql</path-->
                    <path>${project.build.directory}/ddl/${
org.apache.jetspeed.production.database.default.name}/${
org.apache.jetspeed.production.database.default.name}/drop-schema.sql</path>
                    <ignoreErrors>true</ignoreErrors>*
                  </script>*
                  <script>
                  <!-- path>${project.build.directory}/ddl/@database.type@
/${org.apache.jetspe...@database.type@.database.default.name
}/create-schema.sql</path-->
                   <path>${project.build.directory}/ddl/${
org.apache.jetspeed.production.database.default.name}/${
org.apache.jetspeed.production.database.default.name
}/create-schema.sql</path>
                  </script>
                  <script>
                   <path>${project.build.directory}/dbAppData/${
org.apache.jetspeed.production.database.default.name}/${
org.apache.jetspeed.production.database.default.name}/insert-data.sql</path>

                  </script>
                </scripts>
              </sql>
</configuration>

Please advice.



Regards,
Arun Wagle