ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Mularien <pmular...@deploy.com>
Subject Re: SQL task for MS SQL server 2000
Date Thu, 08 Nov 2001 16:15:59 GMT
What are the errors you're getting??

Peter

Sugandha Shah wrote:
> 
> 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

--
To unsubscribe, e-mail:   <mailto:ant-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:ant-user-help@jakarta.apache.org>


Mime
View raw message