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

Re: [basex-talk] Oracle blob
by Erol Akarsu 08 May '14

08 May '14

Scott, Can you please share your experience? Thanks On Wed, May 7, 2014 at 3:43 PM, Dirk Kirsten <dk(a)basex.org> wrote: > Hello Erol, > > Some time ago we had a short discussion on the ML about using clob with > Oracle: > https://mailman.uni-konstanz.de/pipermail/basex-talk/2014-March/006481.html > > Blob is even a standard java.sql type and should work fine. If not, > don't hesitate to report a bug here. > > Cheers, > Dirk > > PS: Next time you might want to start a new conversion with a different > title... makes stuff easier to find in the future for other people, > which might run into the same problem. > > On 07/05/14 21:35, Erol Akarsu wrote: > > Thanks Marco, > > > > I have another question. > > I am trying to use Basex's SQL functions. I have tried some basic SQL > > commands for connecting and selecting some rows from table, it works > fine. > > > > For my project, I need to upload and export pdf document/word > > doc/images form/into Oracle database that needs some special > > oracle-specific stuff. > > Has anybody tried to upload blob/digital document to Oracle with Basex? > > I appreciate any help > > > > Erol Akarsu > > > > > > On Tue, May 6, 2014 at 2:07 PM, Marco Lettere <marco.lettere(a)dedalus.eu > > <mailto:marco.lettere@dedalus.eu>> wrote: > > > > Hi Erol,. > > try > > > > element book { > > > > for $i in 1 to 4 > > return attribute {xs:QName("isbn_" || $i)} { "value" || $i} > > > > } > > > > Regards, > > Marco. > > > > > > On 06/05/2014 19:48, Erol Akarsu wrote: > > > > I would like to create an xml element that will have dynamic > > number of attributes, something like this where n will change > > and $value_1 to $value_2 will be provided by outside > > > > element book { > > attribute isbn_1 {$value_1} > > attribute isbn_2 {$value_2} > > attribute isbn_3 {$value_3} > > . > > . > > . > > attribute isbn_n {$value_n} > > } > > > > Can we do it? > > > > Thanks > > > > > > > > -- > Dirk Kirsten, BaseX GmbH, http://basex.org > |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz > |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: > | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle > `-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22 >

2 7

dynamic number of attributes
by Erol Akarsu 07 May '14

07 May '14

I would like to create an xml element that will have dynamic number of attributes, something like this where n will change and $value_1 to $value_2 will be provided by outside element book { attribute isbn_1 {$value_1} attribute isbn_2 {$value_2} attribute isbn_3 {$value_3} . . . attribute isbn_n {$value_n} } Can we do it? Thanks

3 6

7.8 MAINMEM option
by Maximilian Gärber 07 May '14

07 May '14

Hi, I am running some queries against file based and main-memory dbs for comparison. Creating the main-memory db via xquery (declare option or pragma) did not work: declare option db:mainmem 'true'; or (# db:mainmem true #) Via command line it works: set mainmem true Only the db won't be listed and seems to be dropped after I open another db on the command line. I had expected the main-memory db to be treated like other dbs (e.g. being there as long as I don't drop it or stop the server) Is this behaviour on purpose? Regards, Max

2 4

7.8.2 Updating function items
by Marco Lettere 06 May '14

06 May '14

Hello all, after switching to 7.8.2 we started to get this error: XUST001 Updating function items are not yet supported when passing an updating function as a value. This used to work neatly from 7.6 at least onwards. I must admit that I'm pretty surpirsed and I'd like to ask where ni the docs I could get more info on that. Thanks. Regards, Marco.

3 4

Any news regarding increasing maximum node count?
by David Rudel 04 May '14

04 May '14

Hello, I found in the archive an email indicating that there were nebulous plans to dramatically increase the total number of nodes that a database could accommodate, from 2 billion to 8 quintillion. Are these plans still in the "nebulous" stage, or is there a more specific timeframe in mind? -David -- "A false conclusion, once arrived at and widely accepted is not dislodged easily, and the less it is understood, the more tenaciously it is held." - Cantor's Law of Preservation of Ignorance.

2 1

Customized, Persistent Hashes?
by David Rudel 02 May '14

02 May '14

Hello, Imagine you have data on 100000 test subjects. For every test subject there are 2 data files. For example, one might be a data file describing the actions of a test subject as he went through an obstacle course and the other data file may be time-stamped readings of the subject's heartbeat and breathing rates during the time. These are kept in separate files because the data differs in structure and paradigm (one is event-based the other is a time log). Queries run against such a data base will very frequently want to match up events in one data file to timestamped biometric data in the other for the same student. My question is whether there is a way to set up a persistent pairing of these two files so that any query run against the database knows of this natural connection without it having to be explicitly built each time. For example, it would be nice to create two persistent maps $events and $bio so that the keys of the $events map are document nodes of the data files recording actions students make in the obstacle course and the values are document nodes for associated biometric data, and then $bio is the reverse lookup. Is it possible in BaseX to create a persistent, user-defined hash that is stored and available without needing to be rebuilt to all queries run against a database? Thanks, Davd -- "A false conclusion, once arrived at and widely accepted is not dislodged easily, and the less it is understood, the more tenaciously it is held." - Cantor's Law of Preservation of Ignorance.

2 2

Is there a way to identify an inline function in BaseX?
by Rob Stapper 01 May '14

01 May '14

Hi, In my xquery-program I need to identify an inline function. ( it's a generalized function with a specialized inline function as parameter. The generalized function has to determine which type it's dealing with) I tried annotations but the inspect:function( $f) function doesn't give anything away in case of an inline-function. See attachment. Is there a way to identify inline-functions? Even the namespace of the inline-function would be enough. Thanx, Rob Stapper --- Dit e-mailbericht bevat geen virussen en malware omdat avast! Antivirus-bescherming actief is. http://www.avast.com

2 2

Nullpointer Exception with empty reason in RestXQ response
by Marco Lettere 29 Apr '14

29 Apr '14

Hi all, when, in 7.8.x, I override the rest response in an RestXQ as in: declare %rest:path('testhead1') %rest:HEAD function test:myfunct1() { let $out := () (: also with let $out := "" :) <rest:response> <http:response status="404" reason="{$out}" /> </rest:response> }; I get a null pointer exception from a calling http-client code (in the GUI the usual message "Improper use or potential Bug ..."). http:send-request(<http:requestmethod="head" href="http://localhost:8984/testhead1"/>) If I omit the reason attribute alltogether it correctly defaults to the HTTP Phrase "Not Found". Couldn't it be useful to handle the two cases in the same way? Regards, Marco.

2 1

GET request serialization options
by Martin Reckziegel 29 Apr '14

29 Apr '14

Hello all, i'm trying to get the result of a REST GET query as json. Setting just the GET parameter 'method=json' doesn't work since i don't have a <json> root node. How do I specify the JSON Module options (http://docs.basex.org/wiki/JSON_Module) as GET parameters? The parameter 'format' seems to be reserved by some other module since it only allows 'yes' or 'no' as value. I want to set format=jsonml since then I can export any xml result as json. Is this possible with a GET request? thanks in advance Martin

3 3

? Startup Script for Mac OSX Server (10.9) ?
by Dr. Denis Giffeler 27 Apr '14

27 Apr '14

Hello, sorry - didn’t find a solution in the FAQ or mail archives. Is there an example for a mac osx server (version 10.9) startup script and/or startup environment to make BaseX boot-safe for all users? I’m thinking of something like StartupParameters.plist, /Library/StartupItems, /etc/rc, … tia, Denis

1 0