ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Guther <andr...@netfuel.com>
Subject Re: <sql> using driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
Date Thu, 19 Sep 2002 12:24:19 GMT
I recently tried to use the Microsoft jdbc driver together with dbUnit 
and had lots
of strange error messages. I finally gave up and switched to another 
driver purchased
in the company I am working for, which had no problems at all.

Despite of the driver problems I would suggest to rather use dbUnit that the
sql task mentioned below.

Andreas

Lou Fox wrote:

>Does anyone have any suggestions as to how I can get the sql task to work
>with the SQLServerDriver?
>
>Here's what my step looks like:
><sql
>   driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
>   url="jdbc:microsoft:sqlserver://JRREPORTDATA:1433"
>   userid="XX"
>   password="XXXX"
>  >
>   <![CDATA[
>    insert into XXX..Table    (field1,field2,field3)
>    select field1,field2,field3 from XXX..Table_In;
>   ]]>
>  </sql>
>The error message is:
>java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error
>establishing socket.
>
>
>
>
>--
>To unsubscribe, e-mail:   <mailto:ant-user-unsubscribe@jakarta.apache.org>
>For additional commands, e-mail: <mailto:ant-user-help@jakarta.apache.org>
>
>  
>



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