BaseX-Talk

basex-talk@mailman.uni-konstanz.de

5244 discussions

running xquery file with -c parameter returns unknown command: for
by bryan rasmussen 12 Nov '12

12 Nov '12

When I use -c to run a file and the file is empty_titles.bsx with the following XQUERY for $doc in db:open("dkcontent") where $doc//TITEL[. =""] return <doc>{$doc/*/@ID}</doc> returns fine. when the file is empty_titles.xq with the following: for $doc in db:open("dkcontent") where $doc//TITEL[. =""] return <doc>{$doc/*/@ID}</doc> I get Stopped at line 1, column 3: Unknown command: for. Try HELP. This is on Windows using basexclient. Thanks, Bryan Rasmussen

2 1

Re: [basex-talk] basex RUN local script when talking to Remote server
by Christian Grün 12 Nov '12

12 Nov '12

Hi Bryan (cc @ basex-talk), thanks for the confirmation. Yes, certain combinations of command-line arguments along with "-o" caused a buggy behavior. As usual, I've updated the latest snapshot containing the fix [1]. By the way, please note that all arguments will be evaluated from left to right in BaseX. This way, you can use a single BaseX call to write your results to several files, as e.g. shown here: basex -ofile1.txt -q1 -ofile2.txt -c"xquery 1 to 10" While this behavior may seem surprising at first glance, it has proven to be very helpful in our everyday's use. I tried to make this a little bit more explicit in our documentation [2]. Hope this helps, Christian [1] http://files.basex.org/releases/latest/ [2] http://docs.basex.org/wiki/Startup_Options

1 0

basex RUN local script when talking to Remote server
by bryan rasmussen 12 Nov '12

12 Nov '12

Hi, I have started the basexclient with a -n and -parameter to point to my server, what I would like to do is to execute scripts that I have laying around locally by doing something like RUN name_of_local_script.bsx and not get back a response that it cannot find name_of_local_script.bsx in the folder /home/account that has basex installation... Thanks, Bryan Rasmussen

2 3

UPDINDEX performance problem
by The Trainspotter 11 Nov '12

11 Nov '12

Hi, Just thought I'd share a problem I've got and to see if I'm solving it in the most efficient way. One of the XML documents I process contains various attributes which contain dates in non xs:date forat, e.g. "2010/1/20", "2010/12/1". In order to use the various date functions in XQuery I first need to bulk change all of these attribute values so they're in xs:date format. What I've found is that if I set the UPDINDEX property before I create the database, the XQuery function I have to change the date formats takes an age to complete. If I don't set it then the function completes pretty quickly. I need to use the UPDINDEX setting as I do a lot of updates and queries and I don't want to manually have to keep the indexes up to date. The solution I have at the moment is to create two databases, the first doesn't have UPDINDEX set, I load the document, do the date conversion, then export to a temporary file. I then create a second database from the temporary file, this time with UPDINDEX set. Is there a better/more efficient way of doing this? My date conversion function is this: declare updating function ts:convertToXsDate() { for $e in /*:NML/*:COLLECTION/*:ENTRY/@MODIFIED_DATE union /*:NML/*:COLLECTION/*:ENTRY/INFO/@RELEASE_DATE union /*:NML/*:COLLECTION/*:ENTRY/INFO/@LAST_PLAYED union /*:NML/*:COLLECTION/*:ENTRY/INFO/@IMPORT_DATE let $dateParts:= tokenize( data($e), "/") let $year:= $dateParts[1] let $month:= if( string-length($dateParts[2]) = 1) then concat("0",$dateParts[2]) else $dateParts[2] let $day:= if( string-length($dateParts[3]) = 1) then concat("0",$dateParts[3]) else $dateParts[3] return try { replace value of node $e with xs:date(concat($year,"-",$month,"-",$day)) } catch FORG0001 { () } }; Thanks in advance, Gary

2 3

Documents added by db:add(...) not visible for other existing database connections?
by Arjan van Bentem 10 Nov '12

10 Nov '12

Hi all, I noticed that TCP/IP clients are not seeing new documents that are created using db:add(...) in another client: Once a query has been executed, subsequent queries using the very same database connection do not see/return new documents that were meanwhile created using another connection. When creating some (different) document using one's own existing connection, then everything seems to be in-sync for a moment. But right after that, any new documents are again not seen. Updates made in other clients are visible just fine. So, the documents that are returned are up-to-date. It's just that not all documents are retrieved. I can see that in the query plans, the size in <DBNodeSeq size="..."> does not change, and is lower than the size that clients with a newer connection would show. Should it be okay to keep a connection open? Or is the expected behaviour to need a new connection to see new documents? Details below. Thanks, Arjan. 1. Start the server and a client in debugging mode: ./basexserver -d -S ./basexclient -U admin -P admin -d -x 2. Create and open a database: create database db1 open db1 3. Keep the client open, and make another client insert some documents. Like every second for about 2 minutes, each time using a new connection: for i in {1..120}; \ do doc="<test><a>`uuidgen`</a></test>"; \ echo $i, $doc; \ ./basexclient -U admin -P admin "db:add('db1', '$doc', 'dummy')"; \ sleep 1; \ done 4. While Step 3 is running, back in the first client, execute: xquery count(/test) The log in data/.logs shows: REQUEST XQUERY count(/test) OK Query executed in 25.74 ms. 223.77 ms So far, so good. 5. Repeat Step 4 to see the result NOT change, while the loop from Step 3 is still adding new documents. Logs show a faster result, but otherwise are the same. Also the query plans are always the same. (Typically: the size in <DBNodeSeq size="..."> does not change.) REQUEST XQUERY count(/test) OK Query executed in 5.48 ms. 7.29 ms 6. Using "close" followed by "open db1" gets one a more up-to-date value for "count". Also, using the connection to add some random other type of document, updates the value for "count(/test)" as well: xquery db:add('db1', '<another-test><xyz>123</xyz></another-test>', 'dummy') 7. It's not just "count" that does not change its value. Also, one can only query documents up to that count as returned by Step 4. Like if Step 4 returned "15", then the following would return 5 results, not 10: xquery (/test)[position()=10 to 20] Also, the following would only return the count as returned earlier: xquery /test Like noted, UPDATES made in other clients are visible just fine: xquery replace value of node /another-test/xyz with '456' xquery for $n in /test/a return replace value of node $n with fn:generate-id($n) Tested in both 7.3 and 7.5-20120929.201251 from http://files.basex.org/releases/latest/, in Oracle Java 7 on Mac OS X 10.8.2. I first noticed that my running application did not see new documents created by a test script. But the command line tools show the same issue. Any clue?

2 2

Crash when opening a BaseX database
by Rémi Jannel 10 Nov '12

10 Nov '12

Hi! After crashing my computer while editing a BaseX database, BaseX now returns an error when trying to access the database .I was editing the database through a web application (in Javascript) communicating with BaseX through the PHP wrapper and not with BaseX GUI. My system is Ubuntu 12.04 in a VirtualBox for the development on a Win7 64bits host system. All the other BaseX databases are working properly but when I'm trying to open the one I need, an error is returned. I put the message at the end of the email. I checked on my filesystem, the files corresponding to the database are still present in the BaseX data directory if you think it could be useful to debug what happened I could provide it. Is there something wrong on the BaseX version I'm using that could explain the data being corrupted? And is there a way for me to recover the database? The error message: Potential bug? Improper use? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.0.2 Java: Sun Microsystems Inc., 1.6.0_24 OS: Linux, i386 Stack Trace: java.lang.RuntimeException: Not expected: Data Access out of bounds [pre:1078, indexSize:9, access:9 > 8]. org.basex.util.Util.notexpected(Util.java:67) org.basex.io.random.TableDiskAccess.cursor(TableDiskAccess.java:394) org.basex.io.random.TableDiskAccess.read1(TableDiskAccess.java:107) org.basex.data.Data.kind(Data.java:319) org.basex.query.item.DBNode$4.next(DBNode.java:317) org.basex.query.path.IterStep$1.next(IterStep.java:46) org.basex.query.path.IterStep$1.next(IterStep.java:33) org.basex.query.path.IterPath$1.next(IterPath.java:68) org.basex.query.path.IterPath$1.next(IterPath.java:40) org.basex.core.cmd.AQuery.query(AQuery.java:102) org.basex.core.cmd.XQuery.run(XQuery.java:22) org.basex.core.Command.run(Command.java:328) org.basex.core.Command.exec(Command.java:309) org.basex.core.Command.execute(Command.java:77) org.basex.server.ClientListener.run(ClientListener.java:200) Thanks, Remi Jannel

2 3

passwords
by pw＠themail.co.uk 09 Nov '12

09 Nov '12

trying out changing passwords with BaseX7.5 with a Tomcat war installation. I changed the UID and pwd in web.xml and it doesn't let me authorise.... keeps on asking for the credentials. Am I missing something?

2 1

BaseXException when renaming a database
by Rainer Klute 09 Nov '12

09 Nov '12

I got the exception below when renaming a database. The renaming operation as such succeeded. It is just that exception that bothers me. org.basex.core.BaseXException: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.3 Java: The Android Project, 0 OS: Linux, armv7l Stack Trace: java.lang.ArrayIndexOutOfBoundsException: length=8; index=-1 org.basex.util.list.TokenList.get(TokenList.java:106) org.basex.util.list.TwoWayTokenMap.set(TwoWayTokenMap.java:72) org.basex.util.list.TwoWayTokenMap.set(TwoWayTokenMap.java:87) org.basex.core.Databases.alter(Databases.java:72) org.basex.core.cmd.AlterDB.alter(AlterDB.java:63) org.basex.core.cmd.AlterDB.run(AlterDB.java:48) org.basex.core.Command.run(Command.java:326) org.basex.core.Command.exec(Command.java:305) org.basex.core.Command.execute(Command.java:77) org.basex.core.Command.execute(Command.java:89) ... -- Best regards Rainer Klute

2 2

webapp - set index to be index.xquery or .xml instead of .html
by Colin McEnearney 08 Nov '12

08 Nov '12

Hi, I want my basex webapp's root url, ie domain.com/ to default not to index.html, but to index.xquery or any kind of "x" :-) Currently running with nginx # pass requests for content to basex location / { index index.xqy index.xquery index.xml; proxy_pass http://127.0.0.1:8984; } But only index.html behaves this way. (all others show directory contents) I think maybe this is set somewhere in the jetty context, but can't find it. Does anyone know the answer?

2 1

Best way to run basex webapp in live environment
by Colin McEnearney 08 Nov '12

08 Nov '12

Hi, What is the best way to run a basex webapp for a live site? Right now I've got it started with nohup sh bin/basexhttp -d > nohup_logs/stdout.txt 2> nohup_logs/stderr.txt < /dev/null & Many thanks, Colin

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk