BaseX-Talk

basex-talk@mailman.uni-konstanz.de

5 participants
5249 discussions

[BXSQ0002] calling sql:execute() in BaseX 7.5.1 snapshot
by Charles Duffy 14 Jan '13

14 Jan '13

Howdy -- I have the following code, which worked perfectly with BaseX 7.3: declare function sqlimport:load-sql-source-raw($config as element(config), $sql_source as element(sql-source)) { let $handle := sql:connect( concat($sql_source/@uri, "/", $sql_source/@schema/string()), $sql_source/@username, $sql_source/@password) let $all_column_names := sql:execute( sql:prepare( $handle, "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=? AND TABLE_NAME=?"), <sql:parameters> <sql:parameter type='string'>{$sql_source/@schema/string()}</sql:parameter> <sql:parameter type='string'>{$sql_source/@table/string()}</sql:parameter> </sql:parameters> )/sql:column[@name="COLUMN_NAME"] let $column_names := $all_column_names/text()[not(.=$sql_source/ignore-column/text())] return sql:execute($handle, concat("SELECT ", string-join($column_names, ", "), " FROM ", $sql_source/@table/string())) }; With BaseX 7.5 and current snapshots of 7.5.1, however, it yields the following error: [BXSQ0002] No opened connection with id 1 ...positioned at the sql:execute() call. I would understand sql:connect() failing -- but having the connection appear to take place without errors, followed by a failure with the execution, is surprising. Guidance?

2 1

BaseX Users Meetup, XMLPrague
by Christian Grün 14 Jan '13

14 Jan '13

Dear all, we've now assigned two slots for our Friday's Users Meetup in Prague. The pre-conference schedule is online: http://www.xmlprague.cz/pre-conference-friday/ We are still interested in your presentations, live demos, etc.. Give us a note! Next, you can still register for the conference, which is really budget-friendly, compared to other events of that kind. See you soon, Christian BaseX Team 2013

1 0

BaseX 7.5 Update - Soft-Files.com
by Soft-Files Team 14 Jan '13

14 Jan '13

Dear Developer, Your product BaseX 7.5 has been updated. Your product review page is located at: http://www.soft-files.com/basex_72311.html. Sincerely, The Soft-Files Team

1 0

Re: [basex-talk] data visualisation from BaseX
by pw＠themail.co.uk 12 Jan '13

12 Jan '13

Following my last posting I have rebuilt the database using 36 rather than 12 collections and it seems to perform better. I hope you now have a better chance of accessing the datasets. Peter Hello List http://www.semantechs.co.uk/ has so much data in a BaseX database (of course). How best to visualise? Any ideas of which libraries would be the best fit to develop a restxq front end to this dataset? [the server isn't very performant, so apologies if its slow/stopped. I'd appreciate your suggestions nonetheless] Cheers Peter

1 0

DB backup not backing up images saved as raw files
by France Baril 11 Jan '13

11 Jan '13

Hi, How would I get around that issue? -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

4 5

Query slow via PHP
by Mayer, Jonathan 11 Jan '13

11 Jan '13

Hi, Hope you can help a very novice basex/xquery user! I have the following query to get the complete XML of the "Links.xml" document in the "project" collection. for $doc in collection('project') where matches(document-uri($doc), '^Links.xml') return $doc When running this command in basex on linux it completes in around 2.5 seconds (acceptable speed given the size of the XML file) but when I run it via PHP using the client from the website, it takes around 15 seconds: $session = new Session("localhost", $host, $username, $password); $input = "for \$doc in collection('project') where matches(document-uri(\$doc), '^Links.xml') return \$doc"; $query = $session->query($input); $xml = $query->execute(); Any idea why it might take so long, or whether rewriting my query in a different way would speed up the response? Thanks, Jon.

7 13

data visualisation from BaseX
by pw＠themail.co.uk 10 Jan '13

10 Jan '13

Hello List http://www.semantechs.co.uk/ has so much data in a BaseX database (of course). How best to visualise? Any ideas of which libraries would be the best fit to develop a restxq front end to this dataset? [the server isn't very performant, so apologies if its slow/stopped. I'd appreciate your suggestions nonetheless] Cheers Peter

1 0

Concurrent Query Execution
by happy somani 10 Jan '13

10 Jan '13

Hey Guys, I was trying a scenario out today and wanted to see if I could query two different databases in parallel. I tried out using the code attached and found that while one of the program was trying to write data to a database the other program waits for the write to the database to finish before it could read data from a database. I am attaching the code in this email and here are the steps that you would need to take to reproduce this issue. 1. Run the UploadFileTest class. (This class is trying to create a db using a large xml file) 2. Run the GetData class (This class is trying to read from a small database called sam. The sam database is being created in this program). I would appreciate if somebody could help me in setting up this concurrent query execution framework or if I have been doing something in the wrong way. Thanks. -- Regards Happy

3 3

XQuery update: updating inside a closure & how to modify a node and insert it in a DB
by Daniel Kvasnička 10 Jan '13

10 Jan '13

Hi folks, I'm trying to implement a secure RESTXQ service like this: declare %rest:path("api/users/init") %restxq:PUT("{$data}") %output:method("text") function page:init-user($data) { sec:secure(function() { let $profile := json:parse-ml(convert:binary-to-string($data)) return ( insert node attribute id { sec:get-current-user-id() } into $profile, insert node $profile as last into db:open("db")/s:root ) }) }; And I have two problems: - when executing it like this, inside of a closure, nothing happens. No modifications of the database and no errors (%updating missing) either - which is weird. Is this construct supported in 7.5? - when I remove the sec:secure call and leave only the rest (adding %updating to the declaration) the second insert runs but the first one doesn't - the node is saved without a "id" attribute. Does this have something to do with the PUL order? (http://docs.basex.org/wiki/Update#Example) Thanks for your hints! I feel like I'm overlooking something obvious... Daniel -- danielkvasnicka.net

4 9

example .basexperm files please
by pw＠themail.co.uk 09 Jan '13

09 Jan '13

hello list are there any examples of .basexperm files for use with the WAR distribution or the httpserver? what form are the global permissions described for each user? [i.e. 0777, or -rwxrwxrwx, or some other form] Is the separator a space or a tab? [does it matter?] thanks Pete

3 3

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk