BaseX-Talk March 2014

basex-talk@mailman.uni-konstanz.de

44 participants
55 discussions

Catching errors on DB name
by France Baril 12 Mar '14

12 Mar '14

I was getting an error (improper use or bug) on : for $file in db:open('Translation-management', '/xliff-history/fr-ca')[not(ends-with(base-uri(), 'accessibility.xml')) and not(ends-with(base-uri(), 'account-add.xml')) and not(ends-with(base-uri(), 'account-sync.xml'))] let $sub-uri := substring-after($file/base-uri(), 'Translation-management') return db:delete('Translation-management-simple', $sub-uri) where the DB name in the db:delete doesn't exist (my fault, I forgot to rename it). Stil,, it'd be nice to have a more specific error message for a case like this. Other similar function return DB does not exist, if I recall properly. Thanks, France -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 1

Re: [basex-talk] BaseX server.close() "Connection refused" in Openshift
by P.C. 10 Mar '14

10 Mar '14

Christian and Andy, thank you for the response. I tried to use the "-d" option when starting the server, like this: server = new BaseXServer("-p"+SERVERPORT, "-e"+EVENTPORT, "-n" + host, "-d"); but I wasn't able to get any information (actually, for some reason I had to change DEBUG to true inside the .basex file). In the "catalina.out" file, the same "java.net.ConnectException: Connection refused" exception appears. For some reason, the connection is refused when I try to stop the server (but the connection works when trying to execute other commands). In the BaseX log, nothing different appears. It also happens when I try to do the following: BaseXServer.stop(SERVERPORT, EVENTPORT); Anyway, in the BaseX log, there are lines such as: 19:35:43.118127.12.249.129:33012adminREQUESTINFO 19:35:43.865127.12.249.129:33012adminOK810.3 ms 19:35:57.304127.12.249.129:33083adminREQUESTINFO 19:35:58.072127.12.249.129:33083adminOK768.67 ms 127.12.249.129 is the internal Openshift IP. The numbers 33012, 33083 are arbitrary port numbers? The Openshift available port numbers range from 15000 to 35530. thank you in advance.

1 0

Fulltext query: values in some elements are not indexed?
by Ioannis Kavvouras 10 Mar '14

10 Mar '14

We query on fulltext an xml file. After some experiments we found out that if the "terms" are in the middle of the text-element the 'ft:contains' returns true. On the other hand, if the query is the whole text-element it returns false. ie. <ows:IndividualName>FirstName LastName</ows:IndividualName> the query -------- query -------- for $r in /server where ft:contains($r, ( 'FirstName' , 'LastName' ), <options><fuzzy value="true"/><mode value='any'/></options>) return $r --- end of query --- returns an empty set. In addition, queries with fuzzy value equal to false or true and mode value phrase return also an empty set. Regards Yannis

2 4

Re: [basex-talk] Print out table view
by Dirk Kirsten 10 Mar '14

10 Mar '14

Hi, there are a number of options how to set the serialization options, e.g. by putting them into the prolog of a query, e.g. declare option output:method "csv"; You can find out more about the serialization options and also one example using CSV at our documentation at https://docs.basex.org/wiki/Serialization Cheers, Dirk On 09/03/14 23:17, kleinempfaenger(a)hotmail.com wrote: > Hi, thanks for your answer, > How can I serialize the output as CSV? Could you please link a simple > xquery-documentary. > Greetings > > > > El 06/03/14 04:24, Dirk Kirsten escribió: >> Hello, >> >> no, I don't think that's possible at the moment. However, you could >> write a little XQuery and serialize the result as CSV, giving you exact >> control over which element and nodes you will have in your result set. >> You can then save the output and e.g. import into something like Excel >> or Libreoffice Calc. >> >> Cheers, >> Dirk >> >> On 06/03/14 02:51, kleinempfaenger(a)hotmail.com wrote: >>> Hi, nice program. I didn't find a way to print out the table view of my >>> xml file, or better export it to pdf (on Linux, virtual printers >>> installed). Is that possible? >>> Greetings and thanks. >>> kl >>> >>> _______________________________________________ >>> BaseX-Talk mailing list >>> BaseX-Talk(a)mailman.uni-konstanz.de >>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >>> > -- Dirk Kirsten, BaseX GmbH, http://basex.org |-- 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

Re: [basex-talk] cctv mini cameras prices
by Flycctv 08 Mar '14

08 Mar '14

Dear Product Manager, Nice Day. This is Fly, we specialize in HD network cameras&NVR products. Here introduce our TOP1 last year: SIP Mini dome cameras below. Features: 1. SIP/ VoIP, E-PTZ supported 2. Software (VMS/CMS) for you without cost 3. ONVIF compatibility with kinds of brands such as Axis/ NUUO/Synology/QNAP/IPCorder etc. 4. View via APP, computers, video phones, VMS etc. Waiting to hear from you soon. Warmly regards, Fly ----------------------------------------- If you would like to receive our newsletters to get more idea of our products, please click here to subscribe; Don't want to receive these newsletters anymore? unsubscribe

1 0

Re: [basex-talk] Creating connection pool in basex
by Christian Grün 08 Mar '14

08 Mar '14

Hi iClays (cc to the list), > Thanks for replying. Basically our users have grown tremendously. So with > the embedded basex solution, we thought a connection pool or load balancing > could make the already faster basex even more amazing for us and our user > experience. That is the reason... Thanks for your feedback. As you said you want to speed up BaseX... Have you already found out what takes most time? Is it the time for connecting to the database, the repeated request of identical results, or something else? > Is the embedded solution limited in terms of what we can do with it? The embedded solution will generally give you best performance, because it has no overhead for sending data over sockets, etc., but it may not be well suited if you want to handle external clients. Could you give me more information on what your "users" are? Christian

1 0

BaseX server.close() "Connection refused" in Openshift
by P.C. 07 Mar '14

07 Mar '14

I have set up an application in Openshift. This application has a Tomcat 7 (JBoss EWS 2.0) cartridge. I deploy Web applications to it by sending the WAR with an SFTP client. This is a very simple configuration that would be straightforward to set up in Openshift. Inside a servlet, I start a BaseX server so that the servlets in this application can use it as clients.I start it by calling the following instructions, which work as expected: String folder = System.getenv("OPENSHIFT_DATA_DIR"); if (folder == null) folder = System.getProperty("user.home"); System.setProperty("org.basex.path", folder); if (false == BaseXServer.ping(host, 15000)) { server = new BaseXServer("-p15000", "-e15001", "-n" + System.getenv("OPENSHIFT_JBOSSEWS_IP")); } (Notice that the environment variable "OPENSHIFT_DATA_DIR" indicates the data directory of the Openshift application, where BaseX should store databases. With this property set, the database path, the repository path and the configuration files are all automatically placed relative to this path. I ping the server to see if it is already running; if not, I start it. Notice that I start the server in port 15000 (event handling port 15001), because these ports are available in Openshift. Also, the server is bound to the IP indicated by the environment variable OPENSHIFT_JBOSSEWS_IP, which is the internal IP in my application.) The problem is that I can't close this server. When I call server.stop(), a "Connection refused" error occurs. I thought this could be a bug, but this may also be specific to Openshift, because I don't get this error when I execute this simple example in my home computer. Here is the stacktrace: Mar 05, 2014 8:19:33 AM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet [NewServlet] in context with path [/basextest] threw exception java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at java.net.Socket.connect(Socket.java:528) at java.net.Socket.<init>(Socket.java:425) at java.net.Socket.<init>(Socket.java:208) at org.basex.BaseXServer.stop(BaseXServer.java:333) at org.basex.BaseXServer.<init>(BaseXServer.java:93) at org.basex.BaseXServer.<init>(BaseXServer.java:65) at x.NewServlet.processRequest(NewServlet.java:112) at x.NewServlet.doGet(NewServlet.java:128) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) Thank you in advance.

3 4

Creating connection pool in basex
by iClays 07 Mar '14

07 Mar '14

Is there a way to create a connection pool in basex as you would with applications that connects to oracle or sql server? How do we achieve this? Thx On Tuesday, March 4, 2014 1:14 AM, "basex-talk-request(a)mailman.uni-konstanz.de" <basex-talk-request(a)mailman.uni-konstanz.de> wrote: Send BaseX-Talk mailing list submissions to basex-talk(a)mailman.uni-konstanz.de To subscribe or unsubscribe via the World Wide Web, visit https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk or, via email, send a message with subject or body 'help' to basex-talk-request(a)mailman.uni-konstanz.de You can reach the person managing the list at basex-talk-owner(a)mailman.uni-konstanz.de When replying, please edit your Subject line so it is more specific than "Re: Contents of BaseX-Talk digest..." Today's Topics: 1. Re: import in xsd (Jan Techter) 2. Re: import in xsd (Andy Bunce) 3. BaseX 7.8.1 Update - Soft-Files.com (Soft-Files Team) 4. Error in webdav.xqm (France Baril) ---------------------------------------------------------------------- Message: 1 Date: Mon, 03 Mar 2014 12:08:23 +0100 From: Jan Techter <techter(a)mailbox.tu-berlin.de> To: Christian Gr?n <christian.gruen(a)gmail.com> Cc: BaseX <basex-talk(a)mailman.uni-konstanz.de> Subject: Re: [basex-talk] import in xsd Message-ID: <531462A7.7090609(a)mailbox.tu-berlin.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hi, thx for the info. I'll have to manage with absolute paths then for the time being. Best, Jan On 02/28/2014 08:23 PM, Christian Gr?n wrote: > Hi Jan, > > the reason for the unexpected behavior may be that the referenced > schema files cannot be retrieved from the database. Instead, they will > be requested from the local system. One of the reasons is that schema > validation is peformed by the standard Java validators, or by Saxon, > and both of them have no access to database files. > > Hope this helps, > Christian > ___________________________________ > >> is the validation:xsd() function able to handle the import of other >> schemata? >> I tried to do something like >> >> <import namespace="http://bibtexml.sf.net/" >> schemaLocation="bibtexml-handwritten.xsd"/> >> >> to use types which are defined in this schema in my own schema. >> Both schema files are lying next to each other in the same basex database. >> >> The validation function doesnt throw an error that the import failed. >> But rather only states that it can't resolve the types i used from the other >> schema: >> >> Validation failed. "Fatal:src-resolve: Cannot resolve the name >> 'bibtex:entry' to a(n) 'type definition' component." >> >> So it seems like it just ignores the import statement. >> >> Best, >> Jan >> _______________________________________________ >> BaseX-Talk mailing list >> BaseX-Talk(a)mailman.uni-konstanz.de >> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk ------------------------------ Message: 2 Date: Mon, 3 Mar 2014 11:26:30 +0000 From: Andy Bunce <bunce.andy(a)gmail.com> To: Jan Techter <techter(a)mailbox.tu-berlin.de> Cc: BaseX <basex-talk(a)mailman.uni-konstanz.de> Subject: Re: [basex-talk] import in xsd Message-ID: <CAPH12r2=6Y-n5KkjJiA+YWdt5M3Jn_UYisyZk02BG82AzBZFVg(a)mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Could not a custom LSResourceResolver<http://docs.oracle.com/javase/1.5.0/docs/api/org/w3c/dom/ls/LSResourceResol…>[1] be created to handle loading from the database? Regards /Andy [1] http://docs.oracle.com/javase/1.5.0/docs/api/javax/xml/validation/Validator… On Mon, Mar 3, 2014 at 11:08 AM, Jan Techter <techter(a)mailbox.tu-berlin.de>wrote: > Hi, > > thx for the info. > I'll have to manage with absolute paths then > for the time being. > > Best, > Jan > > > > > On 02/28/2014 08:23 PM, Christian Gr?n wrote: > >> Hi Jan, >> >> the reason for the unexpected behavior may be that the referenced >> schema files cannot be retrieved from the database. Instead, they will >> be requested from the local system. One of the reasons is that schema >> validation is peformed by the standard Java validators, or by Saxon, >> and both of them have no access to database files. >> >> Hope this helps, >> Christian >> ___________________________________ >> >> is the validation:xsd() function able to handle the import of other >>> schemata? >>> I tried to do something like >>> >>> <import namespace="http://bibtexml.sf.net/" >>> schemaLocation="bibtexml-handwritten.xsd"/> >>> >>> to use types which are defined in this schema in my own schema. >>> Both schema files are lying next to each other in the same basex >>> database. >>> >>> The validation function doesnt throw an error that the import failed. >>> But rather only states that it can't resolve the types i used from the >>> other >>> schema: >>> >>> Validation failed. "Fatal:src-resolve: Cannot resolve the name >>> 'bibtex:entry' to a(n) 'type definition' component." >>> >>> So it seems like it just ignores the import statement. >>> >>> Best, >>> Jan >>> _______________________________________________ >>> BaseX-Talk mailing list >>> BaseX-Talk(a)mailman.uni-konstanz.de >>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >>> >> > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk(a)mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >

2 1

Bug in tar reading support
by Hondros, Constantine (ELS-AMS) 07 Mar '14

07 Mar '14

Hi Basex team, I have discovered an apparent bug in the tar-reading support new in Basex 7.8.1. Roughly 50% of the files in my tars are not being imported. When the tar is unpacked and imported from the file-system, 100% of files are imported. @Christian: I will mail you privately the location of a sample tar for you to test. On CREATE DB from unpacked tarfile, count(/*) = 1030 On CREATE DB from tarfile, count(/*) = 554 Selected options were: set INTPARSE true set STRIPNS true set SKIPCORRUPT true Cheers, Constantine ________________________________ Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands.

2 2

Print out table view
by kleinempfaenger＠hotmail.com 06 Mar '14

06 Mar '14

Hi, nice program. I didn't find a way to print out the table view of my xml file, or better export it to pdf (on Linux, virtual printers installed). Is that possible? Greetings and thanks. kl

2 1

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk March 2014