ant-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From naresh123 <naresh.ku...@sigmainfo.net>
Subject Problem when Executing ant Target for running Triggers on MYSQL5.1 Tables
Date Tue, 08 Dec 2009 09:28:01 GMT

Hi All,


       I am Writing automated Build script for running DBScript using ant .I
am Using ant apache-ant-1.7.1 and  MYSQL5.1 .I  wrote a target for running
the Triggers on the tables like this

    <target name="db-Insert" depends="db-init-dmp">
        <echo message=" Creating the tables for DMP it will fail if the
table already exist" />
        <sql driver="${db.driver}"
             url="${db.url}"
             userid="${db.username}"
             password="${db.password}" >
	
	        <transaction src="XXX.sql" />
        </sql>
    </target> 

XXX.sql is the Script for creating the  Triggers

My sql Triggers looks like this


 DELIMITER |

  CREATE TRIGGER inserttree AFTER INSERT ON XXXXX

  FOR EACH ROW
  BEGIN

   DECLARE s INTEGER;
    DECLARE t INTEGER;
       DECLARE ParentPath varchar(30);

   SET s=NEW.REPORTS_TO;
   SET t = NEW.ID;

  if s is NULL then
 insert into hierarchy_path values (t,t);
    else
     select PATH INTO  ParentPath from hierarchy_path where ID = s;
  insert into hierarchy_path values (t,CONCAT(ParentPath,',',t));

    end if;
    END;
 |
    DELIMITER

when ant executing this code its giving error at line 1 like 

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near '; | DELIMITER' at line 1

Can any body Pls help me

-- 
View this message in context: http://old.nabble.com/Problem-when-Executing-ant-Target-for-running-Triggers-on-MYSQL5.1-Tables-tp26690964p26690964.html
Sent from the Ant - Dev mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org


Mime
View raw message