[ 
http://jira.codehaus.org/browse/MSQL-53?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=212068#action_212068
 ] 

Robert Scholte commented on MSQL-53:
------------------------------------

{quote}
you can specify sourceFiles like this:
<scrFiles>
<srcFile>first</srcFile>
<srcFile>second</srcFile>
<srcFile>third</srcFile>
</srcFiles>

and they are executed in the specified order.
{quote} 
You're joking right?! 'Cause if you add forth, it'll be executed as second. 
It's in alphabetic order ;)
I've got an idea how to solve this, might even be worth contributing to 
plexus-utils.
The documentation is actually kind of right once fixed: not specifying the 
orderFile means the configured order should be used.

> Execution order of sql files
> ----------------------------
>
>                 Key: MSQL-53
>                 URL: http://jira.codehaus.org/browse/MSQL-53
>             Project: Maven 2.x SQL Plugin
>          Issue Type: New Feature
>    Affects Versions: 1.5
>            Reporter: Ludwig Magnusson
>            Priority: Minor
>
> When specefying sql source files for the sql plugin in the pom like this:
> <configuration>
>       <fileset>
>               <basedir>${project.basedir}/sql</basedir>
>               <includes>
>                       <include>create-db.sql</include>
>                       <include>project-structure.sql</include>
>                       <include>project-data.sql</include>
>               </includes>
>       </fileset>
> </configuration>
> the files will not be executed in the specified order, but rather in 
> alphabetical order. In this case that would mean that the data file is 
> executed before the structure file and the insertion will fail.
> A quick fix is to name the files something like
> 1-create-db.sql
> 2-project-structure.sql
> 3-project-data.sql
> But is it possibe/desirable to make it possible to specify the execution 
> order in the pom?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email


Reply via email to