Page 1 of 1

XQuery on MarkLogic server

Posted: Thu Mar 05, 2009 6:24 pm
by DALDEI
I'm trying to run an XQuery against a marklogic server.
I've setup the connection, can browse the DB with DatabaseExplorer (WebDav),
I stored a trivial xquery file and tried to execute it.
No matter what I do I get errors from the marklogic server.
I think I need to put something magic in the "XQuery URL" field but I have no idea what. If I use

${currentFileURL}

I get the error from the server:

SystemID: http://DLEE@localhost:8004/xquery/dxtest1.xquery
Engine name: MarkLogic
Severity: error
Description: Query evaluation request rejected (404, Not Found). Is this an XDBC server?

So I think that MarkLogic doesnt want to use the WebDav connection for its URL to the query.

I've tried explictly usin the "browse remote" path or what I think is the path

http://DLEE:******@localhost:8004/xquery/dxtest1.xquery

Same error
I changed the path to be port 8002 which the XDBC driver runs on

SystemID: http://DLEE@localhost:8004/xquery/dxtest1.xquery
Engine name: MarkLogic
Severity: error
Description: 404 Not Found for: http://localhost:8002/xquery/dxtest1.xquery


There must be something URI related to get this to work,
any suggestions appreciated !

-David Lee

Re: XQuery on MarkLogic server

Posted: Thu Mar 05, 2009 6:25 pm
by DALDEI
I mis-typed the second error.
It is

SystemID: http://DLEE@localhost:8004/xquery/dxtest1.xquery
Engine name: MarkLogic
Severity: error
Description: 404 Not Found for: http://localhost:8002/xquery/dxtest1.xquery

Re: XQuery on MarkLogic server

Posted: Thu Mar 05, 2009 7:22 pm
by stefan
The string you set to "WebDAV URL" field from Connection Dialog is only used by the Database Explorer in order to browse the documents from the database.

If you like to execute XQuery statements you also need to properly configure the other above 4 fields from the same connection dialog.

I guess your proper settings shall be:
XDBC Host = localhost
Port = 8002
User = your_user
Password = your_password
WebDAV URL = http://localhost:8004

Please find more details on this page:
http://www.oxygenxml.com/MarkLogic_support.html

The only change you are required to make in the "Scenario Dialog" is to set the Transformer to your predefined MarkLogic connection.

Re: XQuery on MarkLogic server

Posted: Thu Mar 05, 2009 7:34 pm
by DALDEI
That is exactly what I am doing.
I recreated the connection and I'm still getting these errors.
Any suggestions ?

Re: XQuery on MarkLogic server

Posted: Fri Mar 06, 2009 4:52 pm
by DALDEI
Thanks to the mailing list, I got this fixed.
The problem was I was not using the right port.
I had to create an XDBC "App Server" on MarkLogic and use its port.
I was using the port for the "HTTP" App Server instead.
Once I had an XDBC server setup for MarkLogic and used the right port in the Connection configuration dialog it works.