ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sugandha Shah" <sugand...@cybage.com>
Subject SQL task for MS SQL server 2000
Date Thu, 08 Nov 2001 16:00:56 GMT
Hi All,

I 'm trying to use sql task for MS SQL server 2000.

But somehow it doesn't seem to work.Though same task works for Oracle.(after changing the
driver string)



<target name="sql" depends ="build,replace,property" description= "creates user">
   <sql
    driver= "weblogic.jdbc.mssqlserver4.Driver"
       url = "jdbc:weblogic:mssqlserver4:${DataBaseServiceName}@${DBServerName}:1433"
    userid = "sa"
    password = "sa"
    onerror = "continue" >
   <transaction  src="${HOME}/DatabaseScripts/createuser.sql" />
   </sql>
        </target>

 <target name="sql1" depends="build,replace,property,sql" description= "creates tables">
      <sql
       driver= "weblogic.jdbc.mssqlserver4.Driver"
       url = "jdbc:weblogic:mssqlserver4:${DataBaseServiceName}@${DBServerName}:1433"
        userid = "rm_user"
        password = "remote"
        onerror = "continue" >  
    <transaction src="${HOME}/DatabaseScripts/ImodeDatamodel.sql" />          
    <transaction src="${HOME}/DatabaseScripts/populatedata.sql" />    
     <transaction src="${HOME}/DatabaseScripts/Image_map.sql" />    
  </sql>   
      </target> 


Any help will be appreciated.

Thanx
-Sugandha

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message