[ 
http://jira.codehaus.org/browse/MSQL-62?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dieter König closed MSQL-62.
----------------------------

    Resolution: Not A Bug

Ok, the problem was not in the orderFile parameter. It's just using fileset is 
a problem if you want to access some files lying prior to defined basedirectory.
<fileset>
   <basedir>some directory</basedir>
       <includes>
           <include>../../myFolder/myFile.sql</include>

Using srcFiles solved the problem.

But all that problems arised from the fact that you cant combine all the ways 
together in a different ways. At the beginning i was trying to do following (as 
the documenatation confused me):
<configuration>
  <sqlCommand>DROP SCHEMA PUBLIC CASCADE</sqlCommand>
  <fileset>
    ...
  </fileset>
  <srcFiles>
     <srcFile>myFile.sql</srcFile>
  </srcFiles>
  <sqlCommand>SHUTDOWN COMPACT</sqlCommand>
</configuration>

This is something that DOESNT work. Especially multiple sqlCommand's seems to 
fail. So i had to put that single commands into own sql files.

> orderFile fails for other values
> --------------------------------
>
>                 Key: MSQL-62
>                 URL: http://jira.codehaus.org/browse/MSQL-62
>             Project: Maven 2.x SQL Plugin
>          Issue Type: Bug
>    Affects Versions: 1.4
>            Reporter: Dieter König
>
> As documentation of orderFile parameter says it should accept all other 
> values and use them in the sense of 'none'. I just did it that way and then 
> the build fails with:
> Failed to configure plugin parameters for: 
> org.codehaus.mojo:sql-maven-plugin:1.4
> Cause: Setter org.codehaus.mojo.sql.SqlExecMojo.setOrderFile( java.lang.Class 
> ) threw exception when called with parameter 'none': none is not a valid 
> value for orderFile, only 'ascending' or 'descending'.
> Well, the problem is that if i dont specify 'orderFile' then my files are 
> also ordered. If you can give me a hint how to prevent ordering it would very 
> appreciated.
> Here is a snippet of configuration:
> <configuration>
>               <orderFile>none</orderFile>
> ...
> </configuration>

-- 
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