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

try catch with return?
by bryan rasmussen 23 Nov '12

23 Nov '12

Hi, I'm getting the following: Error: Stopped at line 1, column 73: [XPST0003] Expecting 'where', 'order' or 'return' expression. Query: for $doc in db:open('dk') let $dates := $doc//DATO for $date in $dates try{ return <gooddate>{xs:date($date)}</gooddate> } catch *{ return <baddate docid="{$doc/*/@ID}">{$date}</baddate>} I wanted to basically to return all DATO elements with document ids that were not valid xs dates, and figured a try catch with returns in it were the best option. Is that not allowed or have I made some basic error? If it's not allowed how would you handle it? Note it is not really realistic to do something like catch these errors in validation since they've already been past the validation process, first I'd have to do a lot of work to write a schema that handled the document structure since there are a lot of mixed content possibilities (or add new validation language etc.), second I'd have to have it in my validation pipeline and the several hundred thousand large documents would have to be run through the pipeline again just to find a few thousand malformed dates that anyway are currently not used for anything important (but of course if we make them valid date then they can start being used for stuff) at any rate handling it with XQuery seems the best solution. Thanks, Bryan Rasmussen

2 1

FLWOR window clause
by Hans-Juergen Rennau 23 Nov '12

23 Nov '12

Hello, are there already any plans for implementing the XQuery 3.0 feature "window clause in FLWOR expressions"? It seems to me so interesting as it allows the creation and evaluation of "self describing item streams", that is, streams of XDM items with interspersed control items which define and annotate sub units (windows) of the stream total, thus effectively translate the stream of items into a stream of larger units, in analogy to XML tags which translate a stream of characters into a stream of information items... Thank you, Hans-Juergen

2 1

ASSALAMUALAIKUM
by Surina Binti Abdul Majid 23 Nov '12

23 Nov '12

Salam, Saya Surina Binti Abdul Majid dan sekarang bekerja di London sebagai Pegawai Pemasaran (Marketing Officer) di sebuah syarikat pemprosesan batu permata di London.Untuk pengetahuan anda terdapat peluang perniagaan yang hendak saya perkenalkan dan keuntungannya akan diperolehi daripada kerjasama dan bantuan segera yang saya perlukan daripada anda. Saya menghubungi anda kerana saya tidak mahu lepaskan peluang yang ada di dalam syarikat kami buat masa ini dan juga pada masa hadapan. Saya perlukan anda sebagai pembekal (supplier/agent) kepada syarikat kami supaya kita boleh sama-sama merebut peluang perniagaan yang terbuka sekarang ini. Syarikat kami memerlukan produk bernama (TATALITE SUPPLE). Produk Tatalite Supple ini merupakan bahan cecair kimia saintifik yang baru dan merupakan pelincir yang digunakan di dalam makmal permata (gemological laboratory) untuk rawatan penulenan berlian (purification of diamonds clarity treatment). Pelincir yang digunakan semasa rawatan tersebut akan menembusi jauh ke dalam berlian dan semua kotoran hitam kecil di dalam berlian dan batu permata akan meruap keluar. Pembekal utama produk ini berada di Malaysia tetapi pembekal produk terus kepada syarikat kami telah mengalami kemalangan dan meninggal dunia di UK, beliau merupakan Pengurus Pemasaran (Marketing Manager) dan semenjak kemalangan tersebut, monopoli perniagaan telah terputus. Sesiapapun boleh membekalkan produk dan bergabung untuk membuat perkongsian dengan syarikat kami dan ini adalah sebabnya saya menulis email kepada anda untuk meminta bantuan, di mana saya memerlukan anda untuk bertindak sebagai ejen perantara yang akan mengisi kekosongan di antara pembekal utama dan pembeli iaitu syarikat kami. Ini adalah perniagaan yang besar dan akan memberikan dividen yang baik kepada kita berdua. Saya hanya memerlukan kerjasama anda untuk menjadikan perniagaan ini berjaya. Maklumat lanjut akan saya berikan sekiranya anda sanggup menjadi ejen yang membekalkan produk ini kepada syarikat kami. Pertama, saya akan mendapatkan satu perjanjian bekalan kontrak untuk anda sebagai pembekal kepada syarikat di mana saya bekerja. Berdasarkan peratusan, harga belian produk daripada syarikat adalah 4,000.00 USD per karton, manakala di Malaysia harga jualan produk adalah 2,100 USD. Jumlah yang diperlukan oleh syarikat adalah tidak kurang daripada 200 karton. Tujuan mengapa saya mahu anda untuk menjadi ejen kami adalah untuk menjadi pautan yang menghubungkan penjual tempatan di Malaysia secara langsung kepada syarikat yang membeli. Maka margin keuntungan akan dikongsi oleh kita berdua 60% untuk anda manakala 40% untuk saya. Bantuan utama yang diperlukan daripada anda adalah supaya anda memberitahu kepada pengurus saya bahawa anda boleh membekalkan produk ini kepada syarikat kami dan juga untuk mendalami butiran tentang harga dan cara bayaran. Kemudian, kami akan ambil langkah selanjutnya daripada situ. Hubungi saya setelah terima emel ini supaya saya boleh berikan nama dan butiran pembekal utama di Malaysia. Setelah menerima butiran pembekal utama ini, anda perlu menghubungi pembekal tersebut untuk bertanya samada, sekarang ada stok atau tidak untuk bekalan segera kepada kamu, sebelum saya maklumkan kepada Pengarah Syarikat (Company Director) kami tentang anda. Seterusnya Pengarah Syarikat akan hubungi anda dan membuat persediaan kepada Pengurus Pembelian (Purchasing Manager) terbang ke Malaysia. Purchasing Manager ini akan membeli produk daripada anda dan bayaran adalah secara tunai melalui bank di Malaysia. Harap boleh balas dengan segera. Sekian Surina

1 0

Re: [basex-talk] Adding documents to database while space on diskdrive runs out
by pw＠themail.co.uk 22 Nov '12

22 Nov '12

I think that eXist-db takes the latter approach - the database becomes read-only when the disk is limited in space > > >---- Original Message ---- >From: christian.gruen(a)gmail.com >To: thomas.kaltofen(a)risc.uni-linz.ac.at >Subject: Re: [basex-talk] Adding documents to database while space on >diskdrive runs out >Date: Thu, 22 Nov 2012 19:08:01 +0100 > >>Dear Thomas, >> >>Im sorry that your data got corrupted. I agree that such a test >would >>be a desirable addition, Im afraid its often difficult to guess >how >>much space will be occupied by a specific update operation. We could >>generally disable update operations when the remaining space falls >>below a given limit, but once again such a limit would be strongly >>dependent on the used system and use cases. >> >>Rollbacks are on our long-term todo list (along with, or even >without >>MVCC), similar to incremental backups, but if memory gets low, they >>may as well lead to unexpected behavior. >> >>All the best, >>Christian >>_________________________________________ >> >>> I just had the problem that the disk space of the drive where a >BaseX database instance was stored ran out while adding a new >document to the database via the server interface. The result was a >half-finished document in the database resulting in >ArrayIndexOutOfBounds-exceptions when querying the database and >strange behavior of the GUI (views are not shown and even disabled). >Would it be possible to check for sufficient disk space before >writing to the database files? Moreover, it would be nice if the >failed transaction of adding the document while the space ran out >could be rolled back somehow to get the database back into a >consistent state. >>> >>> Thank you for your support! >>> >>> Best regards, >>> Thomas >>> _______________________________________________ >>> BaseX-Talk mailing list >>> BaseX-Talk(a)mailman.uni-konstanz.de >>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >>_______________________________________________ >>BaseX-Talk mailing list >>BaseX-Talk(a)mailman.uni-konstanz.de >>https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >>

2 1

Unable to integrate with oxygen to run xquery
by Alex Muir 22 Nov '12

22 Nov '12

Hi, I've got basex set up using jetty and can query within the firefox browser to return data for example using the url http://localhost:8080/rest/DDEX?query=//MessageHeader however my equivalent oxygen xquery does not return data and rather continues to run not stopping I've recently downloaded the jars and configured the Data Source Drivers as per the http://docs.basex.org/wiki/Integrating_oXygen file:/mnt/xslt_volume/i4EnrichV7/analysis/resources/libs/basex-xqj-1.2.3.jar file:/mnt/xslt_volume/i4EnrichV7/analysis/resources/libs/xqj-api-1.0.jar file:/mnt/xslt_volume/i4EnrichV7/analysis/resources/libs/xqj2-0.1.0.jar In the basex connection which is enabled I've got the following settings port 8080 databaseName DDEX logLevel description loginTimeout 6000 serverName localhost user admin password admin I set up a trasformation scenario with BaseX transformer with the following xquery let $content := //MessageHeader return $content The scenario does not return any data Thoughts? Regards -- - Alex G. Muir Software Engineering Consultant Linkedin Profile : http://ca.linkedin.com/pub/alex-muir/36/ab7/125 Love African Kora Music? Take a moment to listen to Gambia's - Amadu Diabarte & Jali Bakary Konteh www.bafila.bandcamp.com Your support keeps Africa's griot tradition alive... Cheers!

3 4

Adding documents to database while space on disk drive runs out
by Thomas Kaltofen 22 Nov '12

22 Nov '12

Hi, I just had the problem that the disk space of the drive where a BaseX database instance was stored ran out while adding a new document to the database via the server interface. The result was a half-finished document in the database resulting in ArrayIndexOutOfBounds-exceptions when querying the database and strange behavior of the GUI (views are not shown and even disabled). Would it be possible to check for sufficient disk space before writing to the database files? Moreover, it would be nice if the failed transaction of adding the document while the space ran out could be rolled back somehow to get the database back into a consistent state. Thank you for your support! Best regards, Thomas

2 2

Re: [basex-talk] 3 steps
by Simon Knuijver 21 Nov '12

21 Nov '12

Hi Christian, I see but there you put the entire xslt in one place, Simon -----Original Message----- From: Christian Grün [mailto:christian.gruen@gmail.com] Sent: woensdag 21 november 2012 14:38 To: Simon Knuijver Cc: BaseX Subject: Re: [basex-talk] 3 steps >> The current way to do this is transform your request via XQuery and the XSLT module. We may add a parameter for XSLT transformations to our REST API [4]; details would first have to be specified, though. Yes, it can also be done in Java. The most compact solution I get in mind is: 1. Create a database X with your XML and XSLT file (called "example" in the following) 2. Go to your browser and visit http://localhost:8984/rest/X/example.xml?query=xslt:transform(.,db:open(.,'example.xslt'))" If we added an additional xslt parameter, the URL could look as follows: http://localhost:8984/rest/X/example.xml?xslt=example.xslt C.

2 1

Re: [basex-talk] 3 steps
by Simon Knuijver 21 Nov '12

21 Nov '12

Hi Christian, thanks for your swift reply. I'll get on it right away and I would be interested in that extra parameter :) To dumb this one down a little: >> 3. Connect to that database and query for the templates within another >> XSL file? You said: > The current way to do this is transform your request via XQuery and the XSLT module. We may add a parameter for XSLT transformations to our REST API [4]; details would first have to be specified, though. What would that look like, something like this (in Java)?: package org.basex.examples.rest; import java.io.*; import java.net.*; import org.basex.*; /** * This class is a simple example to demonstrate applying stored templates from the REST API. * * @author BaseX Mailing list, BSD License */ public final class RESTGet { /** * Runs the example. * @throws IOException I/O exception */ static void run() throws IOException { System.out.println("=== GET: execute a query ==="); // The java URL connection to the resource String base = "http://localhost:8984/rest/"; URL url = new URL(base + "templates?query=(//tag/styleVersion) "); System.out.println("\n* URL: " + url); // Establish the connection to the URL HttpURLConnection conn = (HttpURLConnection) url.openConnection(); // Print the HTTP response code int code = conn.getResponseCode(); System.out.println("\n* HTTP response: " + code + " (" + conn.getResponseMessage() + ')'); // Check if request was successful if(code == HttpURLConnection.HTTP_OK) { // Print the received result to standard output System.out.println("\n* Result:"); // Get and cache input as UTF-8 encoded stream BufferedReader br = new BufferedReader(new InputStreamReader( conn.getInputStream(), "UTF-8")); // Print all lines of the result for(String line; (line = br.readLine()) != null;) { System.out.println(line); } br.close(); } // Close connection conn.disconnect(); } /** * Main method. * @param args (ignored) command-line arguments * @throws Exception exception */ import javax.xml.transform.*; import javax.xml.transform.stream.StreamResult; import javax.xml.transform.stream.StreamSource; import java.io.File; import java.io.IOException; import java.net.URISyntaxException; public static void main(final String... args) throws Exception{//, IOException, URISyntaxException, TransformerException { // Start servers final BaseXHTTP http = new BaseXHTTP("-Uadmin", "-Padmin"); TransformerFactory factory = TransformerFactory.newInstance(); // Run example //run();//How does this call the RESTGET class? //for now (You may not want to do make RESTGET instance for every template, instead, it may be easier to ask for a set of templates at once and apply them as a stylesheet here) //For(tags) //Get template and add to stylesheet Source xslt = theBuiltStyleSheet; Transformer transformer = factory.newTransformer(xslt); Source text = new StreamSource(new File("input.xml")); transformer.transform(text, new StreamResult(new File("output.xml"))); // Stop servers http.stop(); } } Best, Simon

2 1

Re: [basex-talk] db:list via basexclients doesn't show all databases
by Andreas Weiler 21 Nov '12

21 Nov '12

The server creates an index of all existing databases on startup. Afterwards only by client created databases are added to that index. So all databases created by other processes (GUI, Console) are not in the index. Restart the server and you will see all databases. I guess the db:list() function uses that index and the db:list("dbname") function does not. -- Andreas Am 21.11.2012 um 13:01 schrieb Stefan Koch: > Strange thing is: Our application has access to the db. > ... found out that db:list('dbname') has access to the database, while db:list() can't see it. > > > > Am 21.11.2012 12:51, schrieb Andreas Weiler: >> uh same problem for me... >> >> steps to reproduce: >> >> 1. start server >> 2. start GUI and create db "test", close GUI >> 3. run list...DB "test" is not there, but can be accessed with open test >> >> I guess just client connections can add new databases to a running server instance. >> >> -- Andreas >> >> Am 21.11.2012 um 12:48 schrieb Stefan Koch: >> >>> ... the user has all privileges. I tried to added R/W Access via Grant (though basex standalone). >>> But the client still can't see it. >>> >>> Stefan >>> >>> >>> Am 21.11.2012 12:15, schrieb Andreas Weiler: >>>> Hi Stefan, >>>> >>>> does the user have permission to see all databases? >>>> >>>> Regards, >>>> Andreas >>>> >>>> Am 21.11.2012 um 12:21 schrieb Stefan Koch: >>>> >>>>> Hi, >>>>> >>>>> I was wondering why our backupskript isn't exporting all databases, one is missing. >>>>> The I found out why - our backuptool connects via Java and uses db:list to get the names of all databases. >>>>> >>>>> If I connect via basexclient - there is one missing, if I check via basex (from the shell) the database is shown. >>>>> I added the database also via basex and not like the others via the client. >>>>> >>>>> Is this intended behaviour? How can I tell the client, that there is one more database? >>>>> >>>>> Regards, >>>>> >>>>> Stefan >>>>> _______________________________________________ >>>>> BaseX-Talk mailing list >>>>> BaseX-Talk(a)mailman.uni-konstanz.de >>>>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >>>> _______________________________________________ >>>> BaseX-Talk mailing list >>>> BaseX-Talk(a)mailman.uni-konstanz.de >>>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >

2 1

Re: [basex-talk] db:list via basexclients doesn't show all databases
by Andreas Weiler 21 Nov '12

21 Nov '12

uh same problem for me... steps to reproduce: 1. start server 2. start GUI and create db "test", close GUI 3. run list...DB "test" is not there, but can be accessed with open test I guess just client connections can add new databases to a running server instance. -- Andreas Am 21.11.2012 um 12:48 schrieb Stefan Koch: > ... the user has all privileges. I tried to added R/W Access via Grant (though basex standalone). > But the client still can't see it. > > Stefan > > > Am 21.11.2012 12:15, schrieb Andreas Weiler: >> Hi Stefan, >> >> does the user have permission to see all databases? >> >> Regards, >> Andreas >> >> Am 21.11.2012 um 12:21 schrieb Stefan Koch: >> >>> Hi, >>> >>> I was wondering why our backupskript isn't exporting all databases, one is missing. >>> The I found out why - our backuptool connects via Java and uses db:list to get the names of all databases. >>> >>> If I connect via basexclient - there is one missing, if I check via basex (from the shell) the database is shown. >>> I added the database also via basex and not like the others via the client. >>> >>> Is this intended behaviour? How can I tell the client, that there is one more database? >>> >>> Regards, >>> >>> Stefan >>> _______________________________________________ >>> BaseX-Talk mailing list >>> BaseX-Talk(a)mailman.uni-konstanz.de >>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >> _______________________________________________ >> BaseX-Talk mailing list >> BaseX-Talk(a)mailman.uni-konstanz.de >> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >

1 0