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, [email protected] 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 > [email protected] > http://developer.marklogic.com/mailman/listinfo/general
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
