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

Python API error
by Sayth Renshaw 19 Aug '16

19 Aug '16

I created an issue on github #1342 it has been closed until mailing list confirms its a bug On Windows and Fedora with Python 2.7 and 3.5 I cannot import Session from the BaseXClient >> import BaseXClient >>> from BaseXClient import Session Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: cannot import name Session Not sure if there is an obvious thing I am missing I was following the example on github https://github.com/BaseXdb/basex/blob/master/basex-api/src/main/python/Quer… Is there something super simple missing? Sayth

1 0

Example concatenates iterable to database name
by Sayth Renshaw 19 Aug '16

19 Aug '16

Hi Running 8.5.3 on windows. Currently open database is RaceXML1. I am running the example from here http://docs.basex.org/wiki/Databases for $i in 1 to 100 return db:open('books' || $i)//book/title as for $i in 1 to 100 return db:open('RaceXML1' || $i)//meeting/race What occurs though is that the iterable is concatenated to the database name and subsequently not found. Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found. To new to xquery to know why this is wrong. Full error is Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found. Compiling: - pre-evaluating (1 to 100) - rewriting descendant-or-self step(s) Optimized Query: for $i_0 in (1 to 100) return db:open(concat("RaceXML1", $i_0))/descendant::meeting/race Query: for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race Query plan: <QueryPlan compiled="true"> <GFLWOR> <For> <Var name="$i" id="0"/> <RangeSeq from="1" to="100"/> </For> <CachedPath> <DbOpen name="open(database[,path])"> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="RaceXML1" type="xs:string"/> <VarRef> <Var name="$i" id="0"/> </VarRef> </FnConcat> </DbOpen> <IterStep axis="descendant" test="meeting"/> <IterStep axis="child" test="race"/> </CachedPath> </GFLWOR> </QueryPlan> Can you help? Sayth

2 7

XPath query with special char & fails
by Martin Manthey 19 Aug '16

19 Aug '16

Dear all, we use BaseX version 7.9 BaseX nodes and the XPath query of the getNodes()-method contains the char "&" and an exception is thrown. Example: //File[@originalLocation='E:\data\bugs\prom-9366\file & codemodel']/CopiedLocations/CopiedLocation If we use JDOM Nodes the query does not fail in this case. Why JDom can execute this query and BaseX cannot? Is there a general possibility to avoid this special char in a BaseX query, except masked it, or could it be solved in a higher version of BaseX? best regards

2 1

Using BaseXServer and BaseXHTTP at the same time?
by Kendall Shaw 19 Aug '16

19 Aug '16

Hi, Does the fact that basexhttp starts servers on 1984 and 8984 mean that I can have one program using client/server and another using rest using the same databases at the same time? Kendall

2 1

question on XML with prolog
by Wang, Genneva 18 Aug '16

18 Aug '16

Hi Christian, As I was testing some xml files, I realized that xml file with prolog, the prolog will always get removed when persisted in basex. Is that the expected behavior? Is there some option that the prologs can be saved along with the xml file ? Any tips would be greatly appreciated. Thanks! Regards, -Genneva

2 1

Uploading a binary file through RestXQ
by Marco Lettere 16 Aug '16

16 Aug '16

Hello all, I'm currently trying to implement a service for uploading Images to a Basex db. There is a frontend service that serves an HTML + Javascript page which receives the upload as an AJAX call from the browser then POSTs the request to the backend service for storing into the db. There is no big issue when doing it directly by a command or a query. I've been even able to do it by using the following code inside the RestXQ of the frontend service: client:connect("localhost", 1984, "user", "pass") ! client:query(., "db:store('files', '" || $name || "', .)", map{ "" : $file}) But when I POST the data to the backend RestXQ I always get the data stored into the DB as *base64* encoded text which messes up the successive retrieves. This is the code I use on the backend: declare %rest:path("/service/files/{$name}") %rest:POST("{$body}") %rest:consumes("image/png", "image/jpg", "image/jpeg", "image/gif", "image/svg+xml") %output:method("text") function m:upload-maps($userid as xs:string, $name as xs:string, $body as item()){ let $stored := db:store("files", $name, $body) return <rest:response> <http:response status="201"/> </rest:response> }; I call this service from the frontend service with the following request where the media-type is according to the uploaded file extension: <http:request href="{$url}" method="POST"> <http:body media-type="image/png"> {$data} </http:body> </http:request> How do I ensure that the data gets into the DB with its correct raw binary format? Thanks, Marco.

2 11

Re: [basex-talk] Autocommit option using sql:connect to Oracle 11.2.0.3 with ojdbc6.jar
by Christian Grün 15 Aug '16

15 Aug '16

Hi Chris (cc to the list), > I've also attached the basexdebug.txt but it just shows the requests so > probably not useful. Sounds ok so far. I have slightly revised our SQL code (although it shouldn’t make a big difference), and I have uploaded a new snapshot [1]. Could you give it a try? In general, our SQL wrapper is pretty simple [1,2]. Maybe you could check if you get autocommit=false running with a plain Java JDBC code snippet? Hope this helps, Christian [1] http://files.basex.org/releases/latest/ [1] https://github.com/BaseXdb/basex/blob/9a700bf1f663b18eb578acb1a8aa8bbb4d4dd… [2] https://github.com/BaseXdb/basex/blob/9a700bf1f663b18eb578acb1a8aa8bbb4d4dd… > > Thanks, > > chris > > On 12 August 2016 at 14:46, Christian Grün <christian.gruen(a)gmail.com> > wrote: >> >> Could you try the -d command-line flag (or the command SET DEBUG true >> in the GUI) and check if you get some helpful feedback on stderr? >> >> >> On Fri, Aug 12, 2016 at 3:44 PM, chrisis <chrisisanon(a)gmail.com> wrote: >> > The connection is opened successfully.Not getting any feedback. >> > I'm doing a lot of inserts in a loop and it's committing after every >> > insert. >> > My issue is with the overhead of all the extra commits >> > >> > >> > >> > >> > >> > >> > Thanks, >> > >> > chris >> > >> > >> > On 12 August 2016 at 14:19, Christian Grün <christian.gruen(a)gmail.com> >> > wrote: >> >> >> >> > I'm trying to set the autocommit option off and I can't seem to get >> >> > it >> >> > to >> >> > work. >> >> > I'm passing the option to sql:connect as a map >> >> > map { 'autocommit': false() } >> >> > I also tried map { 'autoCommit': false() } as the Oracle JDBC docs >> >> > seem >> >> > to >> >> > suggest. >> >> >> >> What’s happening? Do you get any feedback? >> >> >> >> Thanks >> >> Christian >> > >> > > >

2 1

BaseX 8.5.3: Improved thread safety
by Christian Grün 15 Aug '16

15 Aug '16

Hi everyone, Normally, we do not announce patch releases anymore, but we’d like to point out that we have spent quite some effort in making xquery:fork-join [1] more thread-safe! As usual, you can already play around with the upcoming 8.6 features [2], which are already available in our patch release. Have fun with the new version [3], your feedback is welcome, Christian [1] http://docs.basex.org/wiki/XQuery_Module#xquery:fork-join [2] http://docs.basex.org/index.php?search=8.6 [3] http://basex.org/downloads

1 0

Java
by Tushar Deshmukh 14 Aug '16

14 Aug '16

Namaste all, I have embedded jetty in my application. I am creating basex database. But this database is created on users/public folder in Windows. I wanted to create it under my application folder. For this I have executed context to set dbpath. But it's returning error. Please help how to set dbpath in Java. If possible please please give code snippet. Thanks

2 1

Autocommit option using sql:connect to Oracle 11.2.0.3 with ojdbc6.jar
by chrisis 12 Aug '16

12 Aug '16

I'm trying to set the autocommit option off and I can't seem to get it to work. I'm passing the option to sql:connect as a map map { 'autocommit': false() } I also tried map { 'autoCommit': false() } as the Oracle JDBC docs <http://docs.oracle.com/cd/E11882_01/appdev.112/e13995/constant-values.html#…>seem to suggest. Am I missing something obvious? Regards, Chris Sweeney

2 1