November 2014 - BaseX-Talk - mailman.uni-konstanz.de

Query database paths using REST
by Florent Gallaire 24 Nov '14

24 Nov '14

Same question: http://stackoverflow.com/questions/22676574/why-cant-you-query-database-pat… /rest/xml/path/test.xml returns the content of the XML file, but if you try a query like: /rest/xml/path/test.xml?query=//element you have the error: [BXDB0005] Query must yield database nodes. What's wrong here ? Best regards Florent -- FLOSS Engineer & Lawyer

2 2

Reg : Database size increment
by Chandrasekhar 24 Nov '14

24 Nov '14

Dear Chirstian I am opening the database and replacing the existing xml file with new xml file to the database .It is adding successfully,but after that my database size is increasing every replacing operation.Can you please suggest me how to stop the size increment. I am using below code to replacing XML file to database. Context context = new Context(); LocalSession localSess = new LocalSession(context); localSess .execute("OPEN "+"DBANME"); localSess .replace("FILENAME", new FileInputStream("FILEPATH")); Thanks&Regards Chandra Sekhar The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited.

2 1

Experiencing unexpected fallback to Xalan with xslt:transform
by Marc van Grootel 23 Nov '14

23 Nov '14

Hi, I was using an XSLT 2 stylesheet to transform xqdoc XML to Markdown. I already had a stylesheet that did the same with HTML. This stylesheet is XSLT 2 and uses Saxon HE which is located inside the BaseX lib directory. Saxon HE is picked up just fine with xslt:transform and xslt:transform-text. I used this as basis for the conversion to markdown. Then I added an xsl:function called i:code-block and suddenly got this error message: [bxerr:BXSL0001] ERROR: 'The first argument to the non-static Java function 'codeBlock' is not a valid object reference.' FATAL ERROR: 'Could not compile stylesheet' Ok, so I changed it to a named template called code-block then I got an error about the string-join used inside. So I re-wrote to not use this xpath function. [bxerr:BXSL0001] ERROR: 'Invalid conversion from 'com.sun.org.apache.xalan.internal.xsltc.dom.AdaptiveResultTreeImpl' to 'node-set'.' So something is causing a fallback to Xalan XSLT 1 processor but I cannot undersand why. However, if I remove all functions and named templates this same stylesheet is compiled and executed fine using Saxon again!!?? If necessary I can add some more code. --Marc

2 3

Full text score with or
by Andy Bunce 23 Nov '14

23 Nov '14

Hi, I want to score searches with multiple conditions e.g. let $data:=( <r><a>red apple</a></r>, <r><a>blue lagoon</a></r>, <r><b>fish and chips</b></r>) for $hit score $s in $data[ a contains text("red") or b contains text("fish")] return $s In 7.8.2 it always returns scores of zero. In version 7.6 it returns numbers like 0.6201145069582775 0.4528324252639413 Is this bug? Regards /Andy

2 3

Reg : Collection Creation For Huge XML
by Chandrasekhar 22 Nov '14

22 Nov '14

Dear Team We are adding the 4gb xml file to the collection,while adding the file we are getting the out of main memory.My java application has the 4gb memory.Can you please help me on this.We are using the LocalSession for creating the collection. Thanks&Regards ChandraSekhar The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited.

2 3

small issue with map:put()
by Rob Stapper 21 Nov '14

21 Nov '14

Hi, See attached snippet. I get the error-message: no context value bound, on this one. What's going wrong here? Rob --- Dit e-mailbericht bevat geen virussen en malware omdat avast! Antivirus-bescherming actief is. http://www.avast.com

3 7

Is this an inlining/query compilation issue?
by Marc van Grootel 21 Nov '14

21 Nov '14

Hi, I found that with the following code the trace shows that, for the two functions (FN) created, both have gotten "ul" inlined. I expected the first to get "ul" and the second "li" and that is also what xpath-matches() receives (X). declare function local:select($selectors as item()*) as function(node()*) as node()* { let $fns := for $selector in $selectors return if ($selector instance of xs:string) then trace(local:xpath-matches(trace($selector,'X: ')),'FN: ') else $selector return function($nodes) { fold-left($fns, $nodes, function($nodes, $fn) { $fn($nodes) } ) } }; declare function local:xpath-matches($selector as xs:string) { function($node as node()*) as node()* { xquery:eval($selector, map { '': $node }) } }; local:select(('ul','li'))(<ul><li>item</li></ul>) --Marc

5 8

Re: [basex-talk] BaseX and MySQL
by Hans-Juergen Rennau 20 Nov '14

20 Nov '14

Vincent, cordial thanks for your concise instructions, you helped me a lot, it works and I am glad. And also thanks to Fabrice. Cheers, Hans Fabrice Etanchaud <fetanchaud(a)questel.com> schrieb am 9:35 Donnerstag, 20.November 2014: #yiv2295957486 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}#yiv2295957486 filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}#yiv2295957486 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv2295957486 filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv2295957486 p.yiv2295957486MsoNormal, #yiv2295957486 li.yiv2295957486MsoNormal, #yiv2295957486 div.yiv2295957486MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv2295957486 a:link, #yiv2295957486 span.yiv2295957486MsoHyperlink {color:#0563C1;text-decoration:underline;}#yiv2295957486 a:visited, #yiv2295957486 span.yiv2295957486MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;}#yiv2295957486 p.yiv2295957486MsoAcetate, #yiv2295957486 li.yiv2295957486MsoAcetate, #yiv2295957486 div.yiv2295957486MsoAcetate {margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv2295957486 span.yiv2295957486EmailStyle17 {color:#1F497D;}#yiv2295957486 span.yiv2295957486EmailStyle18 {color:#1F497D;}#yiv2295957486 span.yiv2295957486TextedebullesCar {}#yiv2295957486 .yiv2295957486MsoChpDefault {font-size:10.0pt;}#yiv2295957486 filtered {margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv2295957486 div.yiv2295957486WordSection1 {}#yiv2295957486 Dear all, You might have to add the following call before sql :connect() : sql:init("com.mysql.jdbc.Driver") I found it mandatory in xqm modules run inside Tomcat, for example. If you start playing with the SQL module, You will realize that BaseX rocks also on SQL repositories ! With RESTXQ+SQLMODULE you can write in a few lines a REST service exposing SQL data. Best regards, Fabrice Etanchaud Questel/Orbit De : basex-talk-bounces(a)mailman.uni-konstanz.de [mailto:basex-talk-bounces@mailman.uni-konstanz.de]De la part de Lizzi, Vincent Envoyé : mercredi 19 novembre 2014 23:31 À : Hans-Juergen Rennau; basex-talk(a)mailman.uni-konstanz.de Objet : Re: [basex-talk] BaseX and MySQL Hans, I had to do this a few days ago, so it’s fresh in my mind. Download Connector/J from the MySQL website and place .jar file in the basex/lib folder. Restart BaseX (if you’re using the server version) so it picks up the new .jar. Queries can then be run like: let $c := sql:connect('jdbc:mysql://localhost/database', 'user', 'password') sql:execute($c, "select …") sql:execute($c, "call stored_procedure…();") Cheers, Vincent From:basex-talk-bounces@mailman.uni-konstanz.de [mailto:basex-talk-bounces@mailman.uni-konstanz.de]On Behalf Of Hans-Juergen Rennau Sent: Wednesday, November 19, 2014 5:20 PM To: basex-talk(a)mailman.uni-konstanz.de Subject: [basex-talk] BaseX and MySQL Dear BaseX team, can you point me to some information about which steps I must take in order to start accessing MySQL databases via the sql module? Thank you for help, Hans-Juergen

1 0

BaseX and MySQL
by Hans-Juergen Rennau 20 Nov '14

20 Nov '14

Dear BaseX team, can you point me to some information about which steps I must take in order to start accessing MySQL databases via the sql module? Thank you for help,Hans-Juergen

3 2

QueryProcessor's result has 'restructured ns declarations'
by Erdal Karaca 19 Nov '14

19 Nov '14

Hi all, I have this file (simplified): <r:root xmlns:r="r" xmlns:x="x" xmlns:y="y" xmlns:z="z"> <x:x/> <y:y/> <z:z/> </r:root> I have created a new database from that file (using Java API) and checked in the GUI that the file's contents are as "expected" by querying the root of the database. Now, when using the QueryProcessor API to query the root of the database, I will get this re-structured namespaces xml: <r:root xmlns:r="r"> <x:x xmlns:x="x"/> <y:y xmlns:y="y"/> <z:z xmlns:z="z"/> </r:root> How can I prevent this behavior? Is there a setting to provide to the QueryProcessor? Thanks!

2 4