[MarkLogic Dev General] MLSQL 6th step issue

[Arnaud.ROCH]

Hi everybody,

I'm trying to connect a MarkLogic server 4.1 with a SQL server 2008 using 
MLSQL. My purpose it's to be able to update Sql server's data with ML server's 
data.

During the installation I follow the six steps I read at "MLSQL: An XQuery 
Library for Relational Database Access" by Jason Hunter.


When I try the sixth step I catch a sql exception like this :



<sql:result xmlns:sql="http://xqdev.com/sql";>

                    <sql:meta>

                                         <sql:exceptions>

                                                             <sql:exception>

                                                                                
 <sql:reason>SVC-SOCCONN: wait 0.0.0.0:59065 Timeout</sql:reason>

                                                             </sql:exception>

                                         </sql:exceptions>

                    </sql:meta>

</sql:result>

I don't know where is the problem come from, I don't know if it's about the SQL 
server, the MarkLogic server or my web.xml parameters.
Is it about service socket connection ?

For details, my SQL Server auth is SSPI and my web.xml file is :
<?xml version="1.0" encoding="UTF-8"?>

<web-app version="2.4"
         xmlns="http://java.sun.com/xml/ns/j2ee";
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
         xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"; >

<servlet>
    <servlet-name>mlsql</servlet-name>
    <servlet-class>com.xqdev.sql.MLSQL</servlet-class>
                <init-param>
                                <param-name>driver</param-name>
                                
<param-value>com.microsoft.jdbc.sqlserver.SQLServerDriver</param-value>
                                <description>The JDBC driver class to 
use</description>
                </init-param>
                <init-param>
                                <param-name>url</param-name>
                                
<param-value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDB</param-value>
                                <description>The JDBC connect string to 
use</description>
                </init-param>
                <init-param>
                                <param-name>user</param-name>
                                <param-value>MyName</param-value>
                                <description>Username, if not inclued in URL, 
otherwise leave blank</description>
                </init-param>
                <init-param>
                                <param-name>password</param-name>
                                <param-value>MyPass</param-value>
                                <description>Password, if not inclued in URL, 
otherwise leave blank</description>
                </init-param>
  </servlet>
  <servlet-mapping>
                <servlet-name>mlsql</servlet-name>
                <url-pattern>/mlsql</url-pattern>
  </servlet-mapping>

</web-app>

Thank you !

Cheers,
ROCH Arnaud

_______________________________________________
General mailing list
General@developer.marklogic.com
http://developer.marklogic.com/mailman/listinfo/general