Hi mister Hunter,
Thank you, you were right about the answer (a) I put localhost in my XQuery but
MarkLogic is on a server and the servlet is on my workstation .Beginner fail ...
cheers,Arnaud Roch
From: jhun...@marklogic.com
Date: Mon, 5 Jul 2010 22:56:32 -0700
To: general@developer.marklogic.com
Subject: Re: [MarkLogic Dev General] MLSQL 6th step issue
Hi Jakob,
The "SVC-SOCCONN: wait 0.0.0.0:59065 Timeout" error is being reported
MarkLogic. It's reporting a socket connect error (that's what SOCCONN stands
for). The 0.0.0.0 address is an IP address (usually used to indicate a server
should listen on all IP addresses) and 59065 is the port number.
Looking through past emails I find someone had the same error when they tried
to connect to a remote IP through an authenticating proxy without
authenticating.
I don't know what address you're using to connect to your servlet, but you
should make sure (a) that the MarkLogic server system and process can make a
connection to the servlet and (b) the servlet engine can make a connection to
the SQL Server. The error seems to me like it's on the (a) part of the
communication because it's MarkLogic doing the complaint about a socket timeout
while trying to talk to the servlet.
-jh-
On Jul 5, 2010, at 6:07 AM, gundou...@hotmail.com wrote: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
_________________________________________________________________
Messenger arrive enfin sur iPhone ! Venez le télécharger gratuitement !
http://www.messengersurvotremobile.com/?d=iPhone_______________________________________________
General mailing list
General@developer.marklogic.com
http://developer.marklogic.com/mailman/listinfo/general
