BaseX-Talk

basex-talk@mailman.uni-konstanz.de

9 participants
5241 discussions

PHP and the QueryExample.php
by johanna.vompras＠uni-bielefeld.de 09 Jul '10

09 Jul '10

Hi all, I was testing the PHP examples on your website ( https://svn.uni-konstanz.de/dbis/basex/trunk/api/etc/php/ ), but I get the following results after executing the QueryExample.php (the query string is: $input = "for $i in 1 to 10 return <xml>Text { $i }</xml>";): This is the output: "instead of 1 commands received." The basex server is running, the access to the server seems to work. I can type the query in the basex-api and it works! Through PHP no query is executed and no results are returned. Can someone help me? Have I overseen something? Should I specify the database (e.g. factbook.xml, and how?)?

2 1

PHP and the QueryExample.php
by johanna.vompras＠uni-bielefeld.de 09 Jul '10

09 Jul '10

1 0

Re: [basex-talk] error importing one million documents using console
by Patrick Schäfer 09 Jul '10

09 Jul '10

Hi Christian, > * Console: > open tuscreen > xquery //*:molecule[@*:id="11178"] Wow, thank you. That gave a huge boost in performance: for $i in //*:molecule[@*:id="298038"]/*:identifier[@*:convention="iupac:smile"] return <smile>{$i/@value}</smile> Takes 80ms now. But unfortunately it doesn't work for a query like: let $ids := (1 to 10) for $i in //*:molecule[@*:id = $ids]/*:identifier[@*:convention="iupac:smile"] return <smile>{$i/@value}</smile> Query executed in 3688.12 ms. So it still takes >3500 ms The Query execution plan is quite different I noticed: First Query: Result: element { "smiles" } { for $i in IndexAccess("298038", ATV)/self::*:id/parent::*:molecule/*:identifier[@*:convention = "iupac:smile"] return element { "smile" } { $i/@value } } Second Query: Result: for $i in IndexAccess("iupac:smile", ATV)/self::*:convention/parent::*:identifier[parent::*:molecule[@*:id = (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)]] return element { "smile" } { $i/@value } So the second plan doesn't make use of the attribute index for locating the id-attributes. > Sorry, zu spät gesehen… Jederzeit ;) Je mehr Mails allerdings an die > Liste gehen, desto besser; dann bleiben auch die anderen auf dem > Laufenden. Dann antworte ich besser an die Liste ;) Patrick

2 2

full-text index available for attributes (is 'contains' applicable to attributes)?
by Patrick Schäfer 09 Jul '10

09 Jul '10

Hi, I wonder if the full-text index is also available to attribute nodes: XQuery-Expression: for $i in //*:identifier[contains(@*:value,'nc1n2[C@H]')] return $i Query executed in 4106.57 ms. I also tried: for $i in //*:identifier[@*:value contains text 'nc1n2[C@H]'] return $i Query executed in 22350.34 ms. The full-test was activated using the console: > create index fulltext Index created in 562.23 ms. > OPTIMIZE Database optimized in 27349.05 ms. > SET FTINDEX Full-Text Index: ON Thank you Patrick

2 1

Adding xml to an embedded database collection
by Charles F. Munat 08 Jul '10

08 Jul '10

Note: I am working in Scala. I want to be able to create new XML documents based on input from a Web-based form, then add them to a Collection in an embedded instance of BaseX programmatically. So if I have a collection called "Persons" and XML in memory thus: <person id="df802f63-f5b9-4b28-951e-aa2c8d7220dd"> <name>Chas</name> <gender>Male</gender> </person> (or as a String, if that's necessary -- Scala allows inline XML). I want this db stored not in my home directory, but in WEB-INF/db. So how do I use CreateDB(input, name) to create the db where I want it? What do I provide for the input? Must I have an XML file already? What is the relationship between that file and the DB, and how does this differ from a collection? Can anyone point me to a spot in the documentation where this is covered? All I can find are examples and they are confusing to me. Once I have a DB open (and maybe a collection), I want to add an XML document directly from code, thus: val xml = <person><name>Chas</name></person> or maybe val xml = "<person><name>Chas</name></person>" then Add(xml).execute(context) I've tried this but the XML disappears. How do I put this in the correct DB and collection? It seems pretty straightforward to use the console or the GUI, but the documentation on embedded use is pretty sparse. Is anyone else using BaseX in embedded mode? Is there documentation somewhere (or more examples) that I've missed? Thanks. I am thinking about using BaseX for persistence by converting objects to/from XML using XStream: http://xstream.codehaus.org/index.html Should be interesting. TIA, Chas.

2 5

Re: [basex-talk] BaseX-Talk Digest, Vol 7, Issue 6
by Patrick Schäfer 08 Jul '10

08 Jul '10

Hi Christian, thank you for the response. The error occurs every time I try to import the folder when using version 6.1. Using version 6.1.9 it doesn't throw an error but it just quits. INFO DB gives me: Database Properties Name: tu Size: 4546 Bytes Nodes: 1 Height: 0 Database Creation Source Path: /home/tuscreen/cml Time Stamp: 29.05.2010 08:02:54 Input Size: 0 Bytes Encoding: UTF-8 Documents: 1 Whitespace Chopping: ON Entity Parsing: OFF Indexes Path Summary: ON Text Index: ON Attribute Index: ON Full-Text Index: OFF Patrick > Patrick, > > thanks for your report. Have you managed to reproduce the bug (i.e., > has it occurred a second time?) As a shorthand, I'd suggest to try the > latest, stable version of BaseX, which you find at: > > http://www.inf.uni-konstanz.de/dbis/basex/maven/org/basex/basex/6.1.9/ > > Looking forward to your feedback, > Christian

2 1

error importing one million documents using console
by Patrick Schäfer 07 Jul '10

07 Jul '10

Hi, I am trying to import one million documents within a directory to basex using the console as described on the faq-page. The command I am using is: java -cp BaseX61.jar org.basex.BaseXClient -vc "create DB /home/tuscreen/cml tuscreen " Immediately after execution the server throws an exception: Exception in thread "Thread-6" java.lang.NullPointerException at org.basex.build.DiskBuilder.close(DiskBuilder.java:102) at org.basex.build.DiskBuilder.abort(DiskBuilder.java:88) at org.basex.core.Progress.abort(Progress.java:98) at org.basex.core.Proc.run(Proc.java:146) at org.basex.core.Proc.exec(Proc.java:109) at org.basex.server.ServerProcess.run(ServerProcess.java:128) When importing a small fraction of the data, everything works fine. Is there any way to import all documents? Thank you Patrick

2 1

Feature Requests
by Swaminathan S 06 Jul '10

06 Jul '10

Hi Christian, Please find below my feature requests: 1) Support constraints (xsd validation and user defined constraints (like support for database triggers)) 2) Transaction support - a rollback feature 3) CData declarations to be retained Thanks Swaminathan Sahiram

1 0

BaseX embedded
by Charles F. Munat 06 Jul '10

06 Jul '10

I'm working on a Maven web project and I'd like to use BaseX in embedded mode to store XML and XHTML documents. I've experimented with other databases in embedded mode, and generally I include a jar (hopefully via Maven, though not always), then I can use the API to create a session, create databases, collections, and documents, run queries, etc. I found the well-hidden Maven configuration to add Maven to the pom.xml file, but I am having a hard time finding any documentation or examples that show me how to use the API. The examples I have found use sockets to connect to a running instance of the database server. This is not what I had in mind. Is it the only way to use BaseX, or am I missing a more direct way? Thanks for clarification... Chas.

2 1

Reminder about your invitation from sayali Kulkarni
by sayali Kulkarni (LinkedIn Invitations) 06 Jul '10

06 Jul '10

LinkedIn ------------ This is a reminder that on June 21, sayali Kulkarni sent you an invitation to become part of his or her professional network at LinkedIn. Follow this link to accept sayali Kulkarni's invitation. https://www.linkedin.com/e/87foxj-gbacdcas-1u/doi/1401339739/ZCnLLJ4a/gir_8… Signing up is free and takes less than a minute. On June 21, sayali Kulkarni wrote: > To: [basex-talk(a)mailman.uni-konstanz.de] > From: sayali Kulkarni [sayalikulkarni7(a)gmail.com] > Subject: sayali Kulkarni wants to stay in touch on LinkedIn > > I'd like to add you to my professional network on LinkedIn. > > - sayali Kulkarni The only way to get access to sayali Kulkarni's professional network on LinkedIn is through the following link: https://www.linkedin.com/e/87foxj-gbacdcas-1u/doi/1401339739/ZCnLLJ4a/gir_8… You can remove yourself from sayali Kulkarni's network at any time. -------------- ------ (c) 2010, LinkedIn Corporation

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk