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

Dan Tran commented on MSQL-27:
------------------------------

unless you have a reproduce test case, please try the user list.

All indication that you send the content of dump.sql file to sql server in one 
short and no result set 

> sql-maven-plugin seems to  ignore the <execution></execution> tags
> ------------------------------------------------------------------
>
>                 Key: MSQL-27
>                 URL: http://jira.codehaus.org/browse/MSQL-27
>             Project: Maven 2.x SQL Plugin
>          Issue Type: Bug
>    Affects Versions: 1.2
>         Environment: Windows XP sp2 professional, eclipse 3.3.2  europa, 
> oracle 10g, maven 2
>            Reporter: Udo Fholl
>
> Maven2 plugin sql cant find the <execution></execution> I don't know why, I 
> have read and followed every manual/doc:
> maven2 outputs from a mvn sql:execute -e  -X:
> [DEBUG] Configuring mojo 'org.codehaus.mojo:sql-maven-plugin:1.2:execute' -->
> [DEBUG]   (f) autocommit = true
> [DEBUG]   (s) delimiter = ;
> [DEBUG]   (s) delimiterType = normal
> [DEBUG]   (s) driver = oracle.jdbc.OracleDriver
> [DEBUG]   (s) keepFormat = false
> [DEBUG]   (s) onError = abort
> [DEBUG]   (s) password = JSAMPEDRO_PSOC
> [DEBUG]   (f) settings = [EMAIL PROTECTED]
> [DEBUG]   (f) skip = false
> [DEBUG]   (f) skipOnConnectionError = false
> [DEBUG]   (s) url = jdbc:oracle:thin:@172.20.1.13:1521:bdj2ee
> [DEBUG]   (s) username = JSAMPEDRO_PSOC
> [DEBUG] -- end configuration --
> [INFO] [sql:execute]
> [DEBUG] connecting to jdbc:oracle:thin:@172.20.1.13:1521:bdj2ee
> [INFO] 0 of 0 SQL statements executed successfully
> [INFO] 
> ------------------------------------------------------------------------
> [INFO] BUILD SUCCESSFUL
> [INFO] 
> ------------------------------------------------------------------------
> [INFO] Total time: < 1 second
> --------------------------------------------------------------------
> My pom.xml:  (appropiate section  )
> .........
>                           <plugin>
>                               <groupId>org.codehaus.mojo</groupId>
>                               <artifactId>sql-maven-plugin</artifactId>
>                               <version>1.2</version>
>                               <dependencies>
>                                       <dependency>
>                                               <groupId>oracle</groupId>
>                                               
> <artifactId>ojdbc14_g</artifactId>
>                                               <version>10.2.0.1.0</version>
>                                       </dependency>
>                               </dependencies>
>                               <configuration>
>                                       
> <driver>oracle.jdbc.OracleDriver</driver>
>                                       
> <url>jdbc:oracle:thin:@${ip}:${port}:bdj2ee</url>
>                                       <username>user</username>
>                                       <password>password</password>
>                                       <autocommit>true</autocommit>
>                               </configuration>
>                               <executions>
>                                       <execution>
>                                               <id>dumbdb</id>
>                                               <phase>pruebas-dummy</phase>
>                                               <goals>
>                                                       <goal>execute</goal>
>                                               </goals>
>                                               <configuration>
>                                               <autocommit>true</autocommit>
>                                               
> <enableBlockMode>true</enableBlockMode>
>                                                 <keepFormat>true</keepFormat> 
>                                               <srcFiles>
>                                                        
> <srcFile>main/sql/dumb.sql</srcFile>
>                                                       </srcFiles>
>                                               </configuration>
>                                       </execution>
>                               </executions>
>                       </plugin>
>                     .....

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