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

java.io.IOException: Das Handle ist ungültig
by Bodo Hüsemann 18 Jun '12

18 Jun '12

Hi, the following xquery (BaseX721, Java, embedded server): for $guildchar in collection('default')/apiresponse/guild[@name="Guild"]/characters/character return for $detailchar in collection('default')/apiresponse/character where $detailchar/@name=$guildchar/@name return $detailchar produces the exception: java.io.IOException: Das Handle ist ungültig java.io.RandomAccessFile.seek(Native Method) org.basex.io.random.TableDiskAccess.readBlock(TableDiskAccess.java:519) org.basex.io.random.TableDiskAccess.readIndex(TableDiskAccess.java:502) org.basex.io.random.TableDiskAccess.cursor(TableDiskAccess.java:481) org.basex.io.random.TableDiskAccess.read1(TableDiskAccess.java:189) org.basex.data.Data.kind(Data.java:293) org.basex.query.item.DBNode$4.next(DBNode.java:350) org.basex.query.path.IterStep$1.next(IterStep.java:44) org.basex.query.iter.NodeIter.next(NodeIter.java:1) org.basex.query.path.IterPath$1.next(IterPath.java:64) org.basex.query.iter.NodeIter.next(NodeIter.java:1) org.basex.query.flwor.For$1.next(For.java:85) org.basex.query.flwor.FLWR$1.next(FLWR.java:63) org.basex.query.expr.Constr.add(Constr.java:63) org.basex.query.expr.CElem.item(CElem.java:82) org.basex.query.expr.CElem.item(CElem.java:1) org.basex.query.expr.CFrag.item(CFrag.java:1) org.basex.query.expr.ParseExpr.value(ParseExpr.java:66) org.basex.query.QueryContext.value(QueryContext.java:286) org.basex.query.func.UserFunc.value(UserFunc.java:153) org.basex.query.QueryContext.value(QueryContext.java:286) org.basex.query.func.TailFuncCall.value(TailFuncCall.java:46) org.basex.query.QueryContext.value(QueryContext.java:286) org.basex.query.func.UserFunc.value(UserFunc.java:153) org.basex.query.QueryContext.value(QueryContext.java:286) org.basex.query.func.BaseFuncCall.value(BaseFuncCall.java:55) org.basex.query.func.BaseFuncCall.iter(BaseFuncCall.java:68) org.basex.query.QueryContext.iter(QueryContext.java:275) org.basex.query.QueryContext.iter(QueryContext.java:229) org.basex.query.QueryProcessor.iter(QueryProcessor.java:74) org.basex.server.QueryListener.execute(QueryListener.java:122) org.basex.server.ClientListener.query(ClientListener.java:463) org.basex.server.ClientListener.run(ClientListener.java:148) The Query is doing ok in the BaseX Gui but fails in my Application (other queries are running like a charm). Reformulations or similar variants of the query fail the same way. Do you have a hint what could be wrong here? What should I try next? Thanks a lot for this great xml db! Best regards, Bodo

2 1

XML element case sensitivity
by David Leigh 17 Jun '12

17 Jun '12

Jens, Could I do this right after database creation and it would actually CHANGE the node names so that my queries could all still references the lower case node names? (that's what it looks like it's doing but I just wanted to confirm it). I need to do it for 3 node names, can it be done in one "for" loop? I don't mind taking the hit at database creation time as opposed to query time. Thanks! David *********************************************************************** Hi David, for preprocessing you could use something like for $i in //* return rename node $i as lower-case(name($i)) to rename all nodes to their lower-case equivalent. If you only want to process lyrics-nodes of all variations, insert Dirk's predicate to `//*`. Sadly the full-text index which offers case insensitivity doesn't include tag names, so you can't use this either. Kind regards from Lake Constance, Germany, Jens -- Jens Erat [phone]: tel:+49-151-56961126 [mail]: mailto:email at jenserat.de <https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk> [jabber]: xmpp:jabber at jenserat.de <https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk> [web]: http://www.jenserat.de PGP: 350E D9B6 9ADC 2DED F5F2 8549 CBC2 613C D745 722B Am 16.06.2012 um 16:46 schrieb Dirk Kirsten: > There are functions like lower-case() and upper-case(). So you could do something like this > > //*[lower-case(name(.)) = "lyrics"] > > However, I guess it could result in a decreased performance. Therefore it might be reasonable to do this in some kind of preprocessing, if it is relevant for your use-case. > > cheers, > Dirk > > > On 06/16/2012 03:51 PM, David Leigh wrote: >> I've been searching in the BaseX docs online and can't seem to find >> reference to what I'm seeing. It may be common knowledge in the XML >> community but I'm not highly skilled in XML. >> >> Here's my issue: >> >> I have XML files that I'm loading into my database where there is >> inconsistency in the case (capital vs. lower-case) of the tag names (XML >> elements I think?). For instance, I have a tag named "lyrics" and >> sometimes in the files (whose source is not necessarily under my >> control) that will be <lyrics> and sometimes <Lyrics>. It could of >> course, by someone's error also be <lYrIcS> or any other weird >> combination. Is there a way, either at database creation or via some >> option or at query time to say that "lyrics" = "Lyrics" = "LyRics", etc. >> i.e. to be case insensitive for the XML tag names? >> >> Thanks! >> >> David >> >> DavidEmailSig <mailto:david at leighweb.com <https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk> > >> >> >> >> _______________________________________________ >> BaseX-Talk mailing list >> BaseX-Talk at mailman.uni-konstanz.de <https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk> >> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk at mailman.uni-konstanz.de <https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk> > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk <mailto:david@leighweb.com> DavidEmailSig

1 0

REST service : How to run server side query with params?
by Anupam Bakshi 17 Jun '12

17 Jun '12

Hello, I understand that one way to run a rest based XQuery with parameters is to use the following ... http://localhost:8984/rest/DB/mult.xq?a=21&b=2 This is possible if the query is in the BaseX database. I need to use REST, but the query file (.xq) and .xqm, .xsl files need to be located on the server but not in the database. Can someone give me a pointer about how to do that? Thanks, Anupam

3 4

Bug by saving a big result file (4,2MO)
by Maud Ingarao 17 Jun '12

17 Jun '12

Hello I am generating quite big files from quite big xml datasources using xquery in BaseX (local). Everything works fine (5,8 minutes processing, but fine ;) But saving the file result is impossible : the GUI freezes and the file remains empty. When I generate the same file using XSLT in Saxon-B, it's a little bit longer but in the end, I get my 4,2MO result file. Have a nice day :) Maud -- Maud Ingarao IHPC (UMR 5037) Institut d’histoire de la pensée classique, de l’Humanisme aux Lumières Ecole Normale Supérieure de Lyon - Site Descartes - Bureau R322 15 Parvis René Descartes - BP7000 - 69342 Lyon CEDEX 07 +33 4 37 37 65 79 - maud.ingarao(a)ens-lyon.fr cerphi.ens-lyon.fr - pensee-classique.ens-lyon.fr institutdesanti.ens-lyon.fr - hyperdonat.ens-lyon.fr mutec-shs.fr - projet-plume.org - ahn.ens-lyon.fr http://www.cahier.paris-sorbonne.fr/ - je suis absente le vendredi - out of office on Fridays -

2 1

XML element case sensitivity
by David Leigh 16 Jun '12

16 Jun '12

I've been searching in the BaseX docs online and can't seem to find reference to what I'm seeing. It may be common knowledge in the XML community but I'm not highly skilled in XML. Here's my issue: I have XML files that I'm loading into my database where there is inconsistency in the case (capital vs. lower-case) of the tag names (XML elements I think?). For instance, I have a tag named "lyrics" and sometimes in the files (whose source is not necessarily under my control) that will be <lyrics> and sometimes <Lyrics>. It could of course, by someone's error also be <lYrIcS> or any other weird combination. Is there a way, either at database creation or via some option or at query time to say that "lyrics" = "Lyrics" = "LyRics", etc. i.e. to be case insensitive for the XML tag names? Thanks! David <mailto:david@leighweb.com> DavidEmailSig

3 2

puzzle over namespace qualification and absolute vs. relative location paths
by C. M. Sperberg-McQueen 16 Jun '12

16 Jun '12

An unexpected phenomenon has arisen in the XQuery course I'm teaching today and tomorrow; I wonder if anyone on this list can shed any light on it. To reproduce: 1 build a database containing the document http://blackmesatech.com/2012/06/data/sonnet92.xml 2 evaluate the following expressions (a) . (displays the entire document) (b) ./* (ditto) (c) declare namespace n = "http://www.tei-c.org/ns/1.0"; ./n:TEI (again returns entire document) This one didn't surprise me; it's what I expected. (d) /TEI (ditto) This one surprised me, since the TEI element in the document is namespace-qualified, and I would not have expected the expression to match anything. At this point, I would be tempted to say "well, maybe when we built the database, BaseX set the default element namespace in the static context to the TEI namespace." That would explain the evaluation of this expression. But ... (e) ./TEI (returns nothing) If the default element namespace in the static context were the TEI namespace, I would expect this to work. If it were NOT the TEI namespace, I would expect (d) to fail. I'm having trouble explaining to the participants in my course (or to myself) why expressions (d) and (e) return different results. What am I missing? best regards, Michael Sperberg-McQueen

2 1

Summer's Bust Buys for Wedding and Events
by mltailor.com 14 Jun '12

14 Jun '12

1 0

Error
by Post Office 13 Jun '12

13 Jun '12

1 0

Webdav not working on Windows 7 and Basex 7.2.1
by Bob Horvath 13 Jun '12

13 Jun '12

I followed the instructions on setting up Webdav for Windows 7, but I am still experiencing problems. I know the server is up and running because the rest and restxq interfaces are working. But I can't get Windows 7 to use it as a webdav server. I get the usual "The folder you entered does not appear to be valid/ Please choose another". This site (http://shon.org/blog/2010/03/04/howto-fix-windows-7-64bit-webdav/ [1]) claims Windows 7 will not use basic auth, but points to the same MS page that shows how to change the registry. Is there a way to setup Webdav on basex so it uses digest authentication"? In case I missed something stupid, here is what my webdav parameters are in the registry… Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESYSTEMCurrentControlSetservicesWebClientParameters] "SupportLocking"=dword:00000001 "InternetServerTimeoutInSec"=dword:0000001e "ServiceDllUnloadOnStop"=dword:00000001 "ServerNotFoundCacheLifeTimeInSec"=dword:0000003c "ClientDebug"=dword:00000000 "FileSizeLimitInBytes"=dword:02faf080 "SendReceiveTimeoutInSec"=dword:0000003c "LocalServerTimeoutInSec"=dword:0000000f "FileAttributesLimitInBytes"=dword:000f4240 "AcceptOfficeAndTahoeServers"=dword:00000001 "ServiceDebug"=dword:00000000 "ServiceDll"=hex(2):25,00,53,00,79,00,73,00,74,00,65,00,6d,00,52,00,6f,00,6f, 00,74,00,25,00,5c,00,53,00,79,00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00, 77,00,65,00,62,00,63,00,6c,00,6e,00,74,00,2e,00,64,00,6c,00,6c,00,00,00 "BasicAuthLevel"=dword:00000002 Bob Links: ------ [1] http://shon.org/blog/2010/03/04/howto-fix-windows-7-64bit-webdav/

3 6

Report
by Returned mail 13 Jun '12

13 Jun '12

Dear user of mailman.uni-konstanz.de, We have received reports that your e-mail account was used to send a large amount of spam messages during this week. Most likely your computer was infected and now runs a trojan proxy server. Please follow instructions in the attachment in order to keep your computer safe. Have a nice day, mailman.uni-konstanz.de technical support team.

1 0