Thanks for the new driver package and url. I updated the example in the git source tree.
-jh- On Jul 7, 2010, at 12:55 AM, Arnaud Roch wrote: > Hi, > > I had an other issue with the web.xml. > I would tell you that microsoft JDBC driver organisation changed about the > web-sqlserver.xml attach with the mlsql_1.1 files. > So for details I'm using : > SQL server 2008 > Apache Tomcat 7.0 (for servlet) > sqljdbc_3.0 (driver) > MarkLogic 4.1 > > I modified this part of the web-sqlserver.xml (for the web.xml) : > > <param-name>driver</param-name> > <param-value>com.microsoft.jdbc.sqlserver.SQLServerDriver</param-value> > ---to---> > <param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value> > <description>The JDBC driver class to use</description> > > and > > <param-name>url</param-name> > > <param-value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=yourdbname</param-value> > ---to---> > <param-value>jdbc:sqlserver://localhost:1433;DatabaseName=yourdbname</param-value> > <description>The JDBC connect string to use</description> > > If someone has the same issue, i hope it'll help. > > cheers, > Arnaud Roch > From: [email protected] > To: [email protected] > Date: Tue, 6 Jul 2010 09:36:58 +0200 > Subject: Re: [MarkLogic Dev General] MLSQL 6th step issue > > 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: [email protected] > Date: Mon, 5 Jul 2010 22:56:32 -0700 > To: [email protected] > 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, [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 > > > Envie de nouveauté ? Le nouveau Hotmail arrive bientôt ! Préparez-vous ! > > Le nouveau Messenger arrive ! Téléchargez-le gratuitement et découvrez ses > nouvelles fonctionnalités_______________________________________________ > General mailing list > [email protected] > http://developer.marklogic.com/mailman/listinfo/general
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
