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

Final update on BaseX 6.8
by Christian Grün 04 Oct '11

04 Oct '11

Dear all, the final deadline of BaseX 6.8 will be October 14th. Be sure this won't be an ordinary release.. ;) Thanks to your feedback, our new REST API has undergone some more changes: -- XQuery files that are stored in the database will now be evaluated instead of being retrieved as raw file. -- all binary resources will now be returned with their correct content (mime) type -- variables don't have to be prefixed with a dollar sign anymore Find some more information at: http://docs.basex.org/wiki/REST Next, thanks to the contributions of Toshio HIRAI, our full-text engine can now be used to tokenize Japanese text corpora: http://docs.basex.org/wiki/Full-Text#Languages Have fun, Christian ___________________________ BaseX Team Christian Grün Uni KN, Box 188 D-78457 Konstanz http://www.basex.org

1 0

testing external variables in the gui
by Randy reed 02 Oct '11

02 Oct '11

I'm new to XQUERY so perhaps I misunderstand how to do what I want. I'm trying to pass an external value to a variable in the query. I declared the variable as external at the top. Like this: declare variable $inputstud as xs:string* external; My understanding is that I now execute the program like this java -cp basex-6.8-SNAPSHOT.jar org.basex.BaseX ~/MyDocuments/Dropbox/student_ind_detail.xq -binputstud=900426517 then in the where of my query I do where $u/ID eq $x/USERID and $u/IDNUMBER eq $inputstud Unfortunately, for some reason this doesn't work. I'd like to try this in the gui of basex to see if I can figure out what has gone wrong, but I can't figure out how to pipe external variable to the Gui, is there a way. Thanks Randy -- Dr. Randall Reed Assistant Professor, Dept. of Philosophy and Religion Appalachian State University

2 4

SQL for Basex
by Erol Akarsu 01 Oct '11

01 Oct '11

I am testing SQL functions in upcoming basex 6.8. I downloaded snapshot and run it against oracle and provided oracle jdbc driver. But it could not find driver. I am using MAC OSX Lion Here is how I execute: java -cp ~/workspace/lib/ojdbc14.jar -jar ~/Desktop/basex-6.8-SNAPSHOT.jar let $url := "jdbc:oracle:thin@xxx.com:1521/b2bdev" (: let $l := sql:init("oracle.jdbc.driver.OracleDriver") :) let $ll := sql:connect($url) return $ll Result Query: let $url := "jdbc:oracle:thin@xxx.com:1521/b2bdev" (: let $l := sql:init("oracle.jdbc.driver.OracleDriver") :) let $ll := sql:connect($url) return $ll Error: [FOSQ0001] An SQL exception occurred: 'No suitable driver found for jdbc:oracle:thin@xxx.com:1521/b2bdev' Thanks Erol Akarsu On Fri, Sep 30, 2011 at 8:30 PM, developer loke <developer.loke(a)gmail.com>wrote: > Hi. I am looking for options to configure the server as documented in > the Wiki, but I can not find .basex file anywhere, and there seems to > be no documentation on the Wiki. I am specifically looking for > settings to bind the server to a particular IP address. > > Thanks > Loke > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk(a)mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >

2 1

csv export problem
by Kevin S. Clarke 26 Sep '11

26 Sep '11

Hi, Timely that CSV is being discussed. I have a question that has been stumping me... I want to be able to output something like: "text here", "<div><a href=""http://basex.org"">text, and more</a></div>", "text here again" What's stumping me is being able to double-quote escape the quotation marks that are in my markup. I've tried serializing my elements and then replacing the single quotes of the attributes to double quotes but then when I try to write that to a file (either serializing as text or xml) the tags are escaped to < etc. Here is a bit of what I've tried: declare option output:indent 'no'; declare variable $txtSer := <serialization-parameters xmlns="http://www.w3.org/2010/xslt-xquery-serialization"> <method value="text"/> </serialization-parameters>; declare variable $xmlSer := <serialization-parameters xmlns="http://www.w3.org/2010/xslt-xquery-serialization"> <method value="xml"/> <indent value="no"/> </serialization-parameters>; declare variable $outFile := 'out2.csv'; declare variable $xml := <sample><a href="http://basex.org">text, and more text</a></sample>; declare function local:writeEOL() { file:append($outFile, '
', $txtSer) }; (: Trying to output markup so I can eventually output something like: "text", "<div><a href=""http://basex.org"">text, and more</a></div>", "text" :) ( file:append($outFile, $xml, $txtSer), (: only text of xml out :) local:writeEOL(), file:append($outFile, $xml, $xmlSer), (: xml out but can't escape quotes :) local:writeEOL(), file:append($outFile, serialize($xml), $txtSer), (: tags escaped :) local:writeEOL(), file:append($outFile, serialize($xml, $txtSer), $txtSer), (: only text out :) local:writeEOL(), file:append($outFile, serialize($xml), $xmlSer), (: tags escaped :) local:writeEOL(), file:append($outFile, serialize($xml), $txtSer), (: tags escaped :) local:writeEOL(), file:append($outFile, concat('<![CDATA[', serialize($xml), ']]>'), $xmlSer), (: tags escaped :) local:writeEOL(), file:append($outFile, concat('<![CDATA[', serialize($xml), ']]>'), $txtSer), (: tags escaped :) local:writeEOL(), file:append($outFile, '<,<', $txtSer) (: both are escaped :) ) I don't seem to be able to output the markup in either text or xml mode. What am I doing wrong? Thanks! Kevin

2 3

export to CSV, or even Excel
by Andreas Karpf 26 Sep '11

26 Sep '11

Hello, I have got question regarding the export function of Basex. I used BaseX to load the Reuters Corpus Volume 1 which is a corpus of around 800k files, unzipped nealry 3GB in size. Is there any way to export some parts of these files (with xpath), parsed into a Basex database, to csv? I am aware that those kind of questions would probably fall under the support which costs. But if there is any simpler solution for that it would be very nice if you could post it. It would help me a lot! Best regards, Andreas

3 2

Builds full-text information.
by Toshio HIRAI 26 Sep '11

26 Sep '11

Hi. Although I was trying implements of Japanese Lexer to 6.8 beta, I have noticed that the result of a ft:mark() function shifts. 55 line of https://github.com/BaseXdb/basex/blob/master/src/main/java/org/basex/query/… final FTLexer lex = new FTLexer(ftopt).sc().init(nd.atom()); FTLexer will generate the tokenizer of the default language instead of an original language, if it does not perform in this way. How is it? In code which I am correcting, ft:mark() operated normally by carrying out like this. thanks. -- Toshio HIRAI

2 1

Query question
by Wiard Vasen 26 Sep '11

26 Sep '11

Dear All, Is it possible to formulate a query which gives the distinct documents from a repository containing a specific word: let $range := 1 to 640 for $doc in collection('brievenvangogh') let $uri := base-uri($doc), $num := substring($uri, string-length($uri) - 6, 3) where $num castable as xs:integer and xs:integer($num) = $range return <document uri='{$uri}'>{ for $n score $s in $doc//*[text() contains text 'cezanne'] return <hit score='{$s}'>{ $n }</hit> }</document> In this query I get the number of hits of all documents in the repository. Thanks in advance! Regards, Wiard

1 0

NPE Error in GUI 6.7.1
by Randy reed 25 Sep '11

25 Sep '11

HI all, I am running basex 6.7.1 on Ubuntu 10.10 using the .jar module running on OpenJDK runtime 6b20-1.9.9. I received an NPE in the GUI (message below). I have attached my .xq file for your perusal. Let me know if there is any way to work around this, or if downloading a different build will solve it. Thanks so much Error: Potential bug? Improper use? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 6.7.1 Java: Sun Microsystems Inc., 1.6.0_26 OS: Linux, i386 Stack Trace: java.lang.NullPointerException org.basex.util.Token.token(Token.java:152) org.basex.query.item.DTd.<init>(DTd.java:103) org.basex.query.item.AtomType$31.e(AtomType.java:441) org.basex.query.item.SeqType.cast(SeqType.java:303) org.basex.query.expr.Cast.item(Cast.java:57) org.basex.query.expr.Arith.item(Arith.java:54) org.basex.query.expr.ParseExpr.value(ParseExpr.java:73) org.basex.query.expr.UserFunc.value(UserFunc.java:121) org.basex.query.expr.BaseFuncCall.value(BaseFuncCall.java:60) org.basex.query.expr.Let$1.next(Let.java:90) org.basex.query.expr.FLWR$1.next(FLWR.java:62) org.basex.query.iter.Iter.finish(Iter.java:65) org.basex.query.expr.ParseExpr.value(ParseExpr.java:76) org.basex.query.expr.UserFunc.value(UserFunc.java:121) org.basex.query.expr.BaseFuncCall.value(BaseFuncCall.java:60) org.basex.query.expr.Let$1.next(Let.java:90) org.basex.query.expr.FLWR$1.next(FLWR.java:62) org.basex.query.iter.Iter.finish(Iter.java:65) org.basex.query.expr.ParseExpr.value(ParseExpr.java:76) org.basex.query.expr.UserFunc.value(UserFunc.java:121) org.basex.query.expr.BaseFuncCall.value(BaseFuncCall.java:60) org.basex.query.expr.BaseFuncCall.iter(BaseFuncCall.java:73) org.basex.query.QueryContext.iter(QueryContext.java:351) org.basex.query.func.FNGen.data(FNGen.java:110) org.basex.query.func.FNGen.iter(FNGen.java:66) org.basex.query.QueryContext.iter(QueryContext.java:351) org.basex.query.expr.Constr.<init>(Constr.java:54) org.basex.query.expr.CElem.item(CElem.java:117) org.basex.query.expr.CElem.item(CElem.java:1) org.basex.query.expr.CFrag.item(CFrag.java:1) org.basex.query.expr.ParseExpr.iter(ParseExpr.java:54) org.basex.query.QueryContext.iter(QueryContext.java:351) org.basex.query.expr.Constr.<init>(Constr.java:54) org.basex.query.expr.CElem.item(CElem.java:117) org.basex.query.expr.CElem.item(CElem.java:1) org.basex.query.expr.CFrag.item(CFrag.java:1) org.basex.query.expr.ParseExpr.iter(ParseExpr.java:54) org.basex.query.QueryContext.iter(QueryContext.java:351) org.basex.query.expr.List$1.next(List.java:81) org.basex.query.expr.FLWR$1.next(FLWR.java:58) org.basex.query.expr.Constr.<init>(Constr.java:55) org.basex.query.expr.CElem.item(CElem.java:117) org.basex.query.expr.CElem.item(CElem.java:1) org.basex.query.expr.CFrag.item(CFrag.java:1) org.basex.query.expr.ParseExpr.iter(ParseExpr.java:54) org.basex.query.QueryContext.iter(QueryContext.java:351) org.basex.query.QueryContext.iter(QueryContext.java:301) org.basex.query.QueryContext.eval(QueryContext.java:260) org.basex.query.QueryProcessor.execute(QueryProcessor.java:128) org.basex.core.cmd.AQuery.query(AQuery.java:83) org.basex.core.cmd.XQuery.run(XQuery.java:22) org.basex.core.Command.run(Command.java:320) org.basex.core.Command.exec(Command.java:301) org.basex.core.Command.execute(Command.java:73) org.basex.gui.GUI.exec(GUI.java:410) org.basex.gui.GUI$5.run(GUI.java:358) -- Dr. Randall Reed Assistant Professor, Dept. of Philosophy and Religion Appalachian State University

2 2

BaseX/REST: Update
by Christian Grün 25 Sep '11

25 Sep '11

Hi there, once more, our integrated REST implementation has been updated (the Wiki should reflect all changes [1]), and should soon reach its final state: - POST is now limited to only perform operations (query, run or command) - Resources can now be returned via GET by simply specifying their exact path - Binary resources are returned with the correct content type - PUT can also be used to store binary files - The HTTP Server now starts the BaseX Server by default Your feedback, be it public or private, is welcome as usual, Christian [1] http://docs.basex.org/wiki/REST ___________________________ BaseX Team Christian Grün Uni KN, Box 188 D-78457 Konstanz http://www.basex.org

1 0

Passing XML data to a query
by Ralf Jung 24 Sep '11

24 Sep '11

Hi list, I am currently looking into BaseX to find out if it meets my requirements for an XML database with XQuery implementation and REST interface. I already got the data imported, now I'm looking into the queries I need. I just stumbled upon the following problem, and could not find any documentation to overcome it, just a bug report that I think is related (https://github.com/BaseXdb/jax-rx/issues/3) The problem is that I need to work on XML data that is POSTed to the query, the data must be available during query execution. However I could not find a way to do so, the jax-rx parameters seem to be restricted to atomic values. Did I miss anything? As work-around, I tried to construct the entire query in the database client (which in my case is Orbeon, the runtime for the XForms application that serves as user interface), serializing the XML into a string and making it part of the query, i.e. something like let $data = <xsl:value-of select="saxon:serialize($data)"/> The query is created correctly, however, I can not get it to execute on the server as BaseX requires a content-type of application/query+xml, whereas XForms submissions (the only way to issue POST requests from Orbeon) have a content-type of application/xml. Is there any way to pass an XML data parameter, or at least to send a custom query without using a special mime-type? Any help would be appreciated, Ralf

3 15