BaseX-Talk July 2015

basex-talk@mailman.uni-konstanz.de

35 participants
50 discussions

Getting More Diagnostic Info From DBA Query Runner?
by Eliot Kimber 28 Jul '15

28 Jul '15

I'm using the DBA web app to test and debug my Web app and underlying queries. However, when there are runtime errors it only reports the error, but not the code that produced it. Is there any way for the query runner to report what module/function/line the error resulted from? Or is that information in a log somewhere? Thanks, Eliot ---- Eliot Kimber, Owner Contrext, LLC http://contrext.com

2 6

RESTXQ: wrong doctype with xhtml method
by Maximilian Gärber 28 Jul '15

28 Jul '15

Hi, when using 'xhtml' output method, the doctype always matches the name of the root element (instead of 'html'). Does not happen with 'html' output method. -- start xqm -- declare %rest:GET %rest:path("test-frag") %output:method("xhtml") %output:html-version("5.0") function _:test-frag(){ <form> </form> }; -- end xqm -- Result: <!DOCTYPE form> <form></form> Regards, Max

2 1

Error [FODC0002] when XSL returns sequence
by Maximilian Gärber 28 Jul '15

28 Jul '15

Hi, calling the test-xsl function does not work (might be a bug). I think returning a document fragment from xsl is not forbidden (at least exist-db permits it). The transform itself uses Saxon HE but this seems not related. -- start xqm -- xquery version "3.0"; module namespace _= "http://foo.org/test"; import module namespace xslt = "http://basex.org/modules/xslt"; declare variable $_:DATA := <foo> <bar1></bar1> <bar2></bar2> </foo>; declare variable $_:XSL := <xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xhtml"/> <xsl:template match="/*/*"> <div>some div</div> </xsl:template> </xsl:stylesheet>; declare %rest:GET %rest:path("test-xsl") function _:test-xsl(){ let $out := xslt:transform($_:DATA, $_:XSL) return $out }; --- end xqm -- Message: Stopped at test-xsl.xqm, 26/31: [FODC0002] "" (Line 2): Markup im Dokument nach dem Root-Element muss ordnungsgemäß formatiert sein. Regards, Max

2 1

Custom URI resolver
by Max Goltzsche 28 Jul '15

28 Jul '15

Hello, I want to import a XSL transformation into another by name as it is already possible with XQuery modules - a pitty that this doesn't work with XSL transformations imported via expath package. Furthermore I want to restrict file system access in XSL transformations and xqueries. As far as I understand it to do both I need to define a custom URI resolver - Please tell me if there is a better way. Thus my question is: How can I register a central URI resolver to be used by both XSLT and XQuery? I work with BaseX 8.2.3 and Saxon-HE 9.6.0-6 directly with Context and LocalSession objects in Java. I've read http://docs.basex.org/wiki/Catalog_Resolver and registered a catalog file via SET CATFILE but it doesn't seem to be used in XSL transformations. I've also tried it with Apache XML resolver in the classpath. For Saxon I tried to register the CatalogResolver explicitly by setting the system property http://saxon.sf.net/feature/uriResolverClass to org.apache.xml.resolver.tools.CatalogResolver and writing a CatalogManager.properties file without effect. What is missing? Please help! Best regards, Max

2 1

hickup in typeswitch
by Rob Stapper 25 Jul '15

25 Jul '15

Hi, I encountered a little but nasty to find hick-up in the typeswitch command. One would expect the code below to return: "map". It returns: "function". Looks like a bug to me. typeswitch( map { 'p' : 'test'}) case function(*) return 'function' case map(*) return 'map' default return 'other' Rob Stapper --- Dit e-mailbericht is gecontroleerd op virussen met Avast antivirussoftware. https://www.avast.com/antivirus

2 2

Re: [basex-talk] Merging databases?
by Eliot Kimber 24 Jul '15

24 Jul '15

If there's to better way you should be able to simply copy the docs without first exporting them: For $dbname in $dbNames Return Let $docs := collection($dbname) For $doc in $docs db:add($newDbName, $doc, $local:makeNewDocUrl($doc)) Or something close to that Cheers, Eliot ---- Eliot Kimber, Owner Contrext, LLC http://contrext.com On 7/24/15, 2:30 PM, "Amanda Galtman" <basex-talk-bounces(a)mailman.uni-konstanz.de on behalf of Amanda.Galtman(a)mathworks.com> wrote: >Hi, > >Is there a simple, fast way to merge databases? For example, suppose I >have 200 databases, each with 5 XML documents, and the document paths are >unique across all the databases. I want to produce a database containing >all 1000 documents. > >I looked in the Database Module wiki and nothing jumped out as being >uniquely tailored for this task. I¹m sure there is an ad hoc way to do it >by looping over the documents in the databases, exporting them, and >adding them to the new database. > But if that takes the same amount of time as building the 200 databases >in the first place, I should change other things about my design to avoid >the need to merge databases. > >Thanks, >Amanda >

3 2

Merging databases?
by Amanda Galtman 24 Jul '15

24 Jul '15

Hi, Is there a simple, fast way to merge databases? For example, suppose I have 200 databases, each with 5 XML documents, and the document paths are unique across all the databases. I want to produce a database containing all 1000 documents. I looked in the Database Module wiki and nothing jumped out as being uniquely tailored for this task. I'm sure there is an ad hoc way to do it by looping over the documents in the databases, exporting them, and adding them to the new database. But if that takes the same amount of time as building the 200 databases in the first place, I should change other things about my design to avoid the need to merge databases. Thanks, Amanda

1 0

annotations in function-declarations
by Rob Stapper 24 Jul '15

24 Jul '15

Hi, I guess, Dirk, See the attached mail-threat, probably already noticed on talk@xquery. Is it possible that you do a little feasibility-study on the basex-implementation for my request? Thanx in advance, Rob Stapper --- Dit e-mailbericht is gecontroleerd op virussen met Avast antivirussoftware. https://www.avast.com/antivirus

2 4

Re: [basex-talk] BASEX Help
by Dirk Kirsten 24 Jul '15

24 Jul '15

Hello, please make sure to always cc the mailing list, as we can't provide personalized support for free, but we try to supports as much as possible on our mailing list, but others should benefit from it as well. However, I have to say that I have the feeling you lack a basic understand of Java and you might be better of learning Java fundamentals first. Also, given that you said you are still in school you might want to ask your lecturer or a TA to give you hands-on help. Having said that, you simply have to do a new Check("mydatabase").execute(context); with context holding a Context object. Please take a look at the source code example I linked to in the last mail, it really follows the exact same principle. Cheers Dirk On 07/24/2015 09:29 AM, Yassine Hamdouni wrote: > hi Dirk , > > can you give me a sample of Check() in basex because I ue it for > checking the existence the databaseX but i don't now how use it . > > new Check ("C:\\Program Files (x86)\\BaseX\\data\\nomDeLaBaseDeDonnee"); > > Regards > > 2015-07-23 16:12 GMT+02:00 Dirk Kirsten <dk(a)basex.org > <mailto:dk@basex.org>>: > > Hello, > > please be much more specific what you want to do and what does not > work. > That your tutor does not agree is not a proper problem description > - Why > does he not agree, what does not work as expected? > > However, I seriously doubt you ever attempted to run this code sample, > so this should be the first thing to do. If you do, you should > notice at > least compiler warnings as for example your statement "final Context > context = null;" is not really useful as it initializes the variables > context with null and can not be changed. So your next usage of this > variable will fail. Also, you always have to execute database commands > against a database context. > Please take a look at our examples, e.g. at > https://github.com/BaseXdb/basex/blob/master/basex-examples/src/main/java/o… > > Cheers, > Dirk > > On 07/23/2015 01:52 PM, Yassine Hamdouni wrote: > > hello , > > > > I'm studying engineering school, I have to make a java method that > > allows to import the xml file, and put in a database so it ca not > > exist creates it, and after you optimize, > > I do this code, but my placement tutor does not agree, is that > you can > > help me please. > > > > public void importerImpl(File dossierContenantLesXmls, String > > nomDeLaBaseDeDonnee, boolean ecraserDb) { > > > > final Context context = null; > > Parser parser = null; > > File[] listefichierXml = > dossierContenantLesXmls.listFiles(); > > > > /*tester si la base de donnée exste on l'ouvre sinon > on la > > crée > > pour le test d'existence il y a ausi cette fonction à > > voir avec Bruno > > con.getDatabaseConnection(nomDeLaBaseDeDonnee); > > */ > > > > System.out.println("------------------ opens an existing > > database or creates a new one------------------ "); > > if(context.soptions.dbexists("nomDeLaBaseDeDonnee")) { > > new Open > > ("nomDeLaBaseDeDonnee"); > > }else { > > try { > > Data data = CreateDB.create( nomDeLaBaseDeDonnee, > > parser, context, null); > > new Open ("nomDeLaBaseDeDonnee"); > > } catch (IOException ex) > > { > > ex.getCause(); > > } > > } > > // parcourir une liste de fichier Xml puis ajouter > chaque > > fichier a basex > > for (int i=0;i<=listefichierXml.length;i++){ > > new Add("listefichierXml[i].getAbsolutePath()"); > > } > > new Optimize(); > > context.close(); > > } > > } > > > > > > > > > > > > -- > > cordialement > > > > HAMDOUNI Yassine > > > > -- > Dirk Kirsten, BaseX GmbH, http://basexgmbh.de > |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz > |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: > | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle > `-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22 > > > > > -- > cordialement > > HAMDOUNI Yassine > -- Dirk Kirsten, BaseX GmbH, http://basexgmbh.de |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle `-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22

1 0

Option Parallel Verständnisfrage
by Dennis Wiest 23 Jul '15

23 Jul '15

Hallo, ich habe eine Verständnisfrage bezüglich der Option "Parallel". Ich wollte mir einen Überblick über die Geschwindigkeit von BaseX machen bezüglich mehrerer Benutzeranfragen. Ich verwende Basex 7.7. Ich habe mir ein Java Programm mit Multithreads geschrieben, welches das ganze simuliert. Das Script funktioniert soweit auch und es werden mir im BaseX die Session für jeden Benutzer angezeigt. Als erstes hab ich Parallel auf 20 gesetzt. Mir ist dabei aufgefallen das es pro Benutzer immer langsamer wird und die CPU-Auslastung nicht wirklich hoch ist. Wird das ganze gar nicht Parallel abgearbeitet ? Verteilt BaseX die Last nicht auf die CPU´s?? Danach hab ich Parallel auf 1 gesetzt. Das Ergebnis ist schneller als Parallel 20, das dürfte bei einer sequenziellen Abarbeitung nicht sein oder ?? Das ganze System läuft auf einem HP Server mit 64 GB Arbeitsspeicher einer PCI SSD Festplatte und einem Intel Xeon E5-2690 8-Core 2.90 GHz Prozessor. Könnt ihr mir da vielleicht eine Erklärung liefern ? Ich hab das ganze nochmal in Englisch geschrieben. Vielen dank Gruß Dennis Wiest Hello There, I have a question concerning the understanding of "parallel" option. I wanted to make an overview of the speed of BaseX regarding several user requests. I use Basex 7.7. I have a Java program written with multi-threads, to simulating this. The script works well so far and the session for each user are displayed in BaseX. First I set "parallel" to 20. I've noticed that it is getting slower for each user and the CPU utilization is not really high. Will not parallel processed? Distributes the load on the CPU not BaseX ?? Then I got the same and set "parallel" to 1. The result is faster than parallel 20, that should not be in a sequential processing or ?? The whole system runs on an HP server with 64GB of RAM PCI SSD hard drive and an Intel Xeon E5-2690 8-core 2.90 GHz processor. Can you provide an explanation as me, maybe? I have the whole again written in English. many thanks Greeting Dennis Wiest ________________________________ Avitech GmbH Principal Office: Bahnhofplatz 1 | 88045 Friedrichshafen | Germany Court Registration: Amtsgericht Ulm | HRB 728293 Geschäftsführer/Managing Director: Antonio Maria Gonzalez Gorostiza VAT No.: DE223719716 http://avitech.aero

2 1

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk July 2015