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

Leave whitespaces in XML when loading XML file with new CreateDB
by Jiří Kadlec 17 Jun '10

17 Jun '10

Hi Guys, How can I preserve whitespaces in XML document, when i'm using new CreateDB(..) object for creating new database from Java code. When I export data with new Export(..) I get document with choped whitespaces. I found out, that there is a possibility to preserve whitespaces when I create DB from BaseX gui. There is a possibility to uncheck option chop whitespaces which gives me required result. Is there any way how to do this from Java. Thank you Jiri

4 9

basex xquery optimization not using attribute index on "joins"?
by Sandra Maria Silcot 06 Apr '10

06 Apr '10

Hi all, First, thanks to the developers for a great piece of software. I am having difficulty getting an xquery on a large database to run using indexed attributes when a "join" idiom is used. I have a large basex database, with multiple documents. One of those contains <rs> elements as shown below, where the @corresp attribute contains values which are identical to the @key attribute on <person> elements, which live in multiple separate files: <personGrp type="match:policeNum+ship" size="3"><persName> <rs corresp="c23a2866">Corper, Jno (Pn:1000C)...</rs> <rs corresp="dlm18192024">Corper, John (Pn:1000C)...</rs> <rs corresp="c31a31061000" >Corper, Jno (Pn:1000CC)...</rs> </persName></personGrp> I know indexes have been built as xpaths like this are lightening quick: //person[@key="c23a2866"] or //rs[@corresp="dlm18192024"] But when I do this, it is glacial (nearly 1 minute): EG(A) for $rs in //rs[@corresp="c31a31061000"]/../..//rs let $keyval := data($rs/@corresp) return //person[@key=$keyval] I am using BaseX6.jar on XP. When I look at the query plan, the ONLY time the attribute index used is on the //rs[@corresp="c31a31061000"] part. I can get it to run fast and return the 3 matched <person> elements using the attribute index using basex:eval, like this: EG(B) for $rs in data(//rs[@corresp="c31a31061000"]/../..//rs/@corresp) let $s := concat("//person[@key='",$rs,"']") return basex:eval($s) So rather than execute this query asa "join" -- a manner which seem widespread in the xquery world -- I must manually build and execute each //person[@key='string'] request "manually" to get basex to use its attribute index. Whilst this works, it seems a rather strange idiom to have to employ, and locks my queries into basex. Is the behaviour of EG(A) by design, or is it a bug that the query optimizer is failing to recognise it can use the attribute index on the //person[@key=$keyval] part? Any guidance much appreciated. Best wishes to all, Sandra.

2 4

Bug: baseX can't create XMLDB with non utf-8 xml String
by l0979365428＠gmail.com 05 Apr '10

05 Apr '10

Dear baseX creater: If it is xml file ,it 's ok. If it is xml String, BaseX only receives utf-8 encoding of XML. The reasion is : //---------------------------------------------------// public static IO get(final String s) { if(s == null) return new IOFile(""); if(s.startsWith("<")) return newIOContent(Token.token(s)); if(s.startsWith("http://")) return new IOUrl(s); return new IOFile(s); //---------------------------------------------------------// public static byte[] token(final String s) { final int l = s.length(); if(l == 0) return EMPTY; final byte[] bytes = new byte[l]; for(int i = 0; i < l; i++) { final char c = s.charAt(i); if(c > 0x7F) return utf8(s); bytes[i] = (byte) c; } return bytes; //-----------------------------------------------// Doesn't parse with the head of XML file. But this programe create xml struts with Sax which pares the xml with the head info. For this reason，it'll make mistakes once the XML String is not UTF-8. I fix it : if(s.startsWith("<")) return new IOContent(Token.encoding(s)); //----------------------------------------------// public static byte[] encoding(final String s) { final int l = s.length(); if(l == 0) return EMPTY; int i=0; int j =0; StringBuilder ss=new StringBuilder(); char hope[]=new char[]{'c','=','"','"'}; while (true) { final char c = s.charAt(i); if(hope[j]==c) j++; if(j==4) break; if(j>2&&c!=hope[j-1]) { ss.append(c); } i++; } final byte[] bytes = new byte[l]; for(int k = 0; k < l; k++) { final char c = s.charAt(k); if(c > 0x7F) return others(s,ss.toString()); bytes[k] = (byte) c; } return bytes; } //-----------------------------------------------// I wonder if you could fix this bug in the next version. Also BaseX doesn't support the String of xml with namespace build DB. And I have no idea. PS: BaseX57,Jdk1.5 best wishes Ruby

3 2

Namespace conflict problem
by Jiří Kadlec 01 Apr '10

01 Apr '10

Hi all, Could you help with following error [XUDY0024] New namespaces conflict with each other. I create database in basex GUI from following XML file: <root xmlns:my="http://www.somedomain.com"> <subroot my:index="1">aaa</subroot> <subroot my:index="2">bbb</subroot> <subroot my:index="3" my:delete="true">ccc</subroot> </root> Then I try to execute following statement declare namespace my="http://www.somedomain.com"; insert node attribute my:addedAttribute {"1"} into /root/subroot[@my:index=1] Am i doing something wrong, how should i write a query which will add add my:addedAttribute {"1"} into subroot element with my:index="1". Any help appreciated Jiri

2 1

Bug: baseX can't create XMLDB with non utf-8 xml String
by l0979365428＠gmail.com 31 Mar '10

31 Mar '10

Dear baseX creater: If it is xml file ,it 's ok. If it is xml String, BaseX only receives utf-8 encoding of XML. The reasion is : //---------------------------------------------------// public static IO get(final String s) { if(s == null) return new IOFile(""); if(s.startsWith("<")) return newIOContent(Token.token(s)); if(s.startsWith("http://")) return new IOUrl(s); return new IOFile(s); //---------------------------------------------------------// public static byte[] token(final String s) { final int l = s.length(); if(l == 0) return EMPTY; final byte[] bytes = new byte[l]; for(int i = 0; i < l; i++) { final char c = s.charAt(i); if(c > 0x7F) return utf8(s); bytes[i] = (byte) c; } return bytes; //-----------------------------------------------// Doesn't parse with the head of XML file. But this programe create xml struts with Sax which pares the xml with the head info. For this reason，it'll make mistakes once the XML String is not UTF-8. I fix it : if(s.startsWith("<")) return new IOContent(Token.encoding(s)); //----------------------------------------------// public static byte[] encoding(final String s) { final int l = s.length(); if(l == 0) return EMPTY; int i=0; int j =0; StringBuilder ss=new StringBuilder(); char hope[]=new char[]{'c','=','"','"'}; while (true) { final char c = s.charAt(i); if(hope[j]==c) j++; if(j==4) break; if(j>2&&c!=hope[j-1]) { ss.append(c); } i++; } final byte[] bytes = new byte[l]; for(int k = 0; k < l; k++) { final char c = s.charAt(k); if(c > 0x7F) return others(s,ss.toString()); bytes[k] = (byte) c; } return bytes; } //-----------------------------------------------// I wonder if you could fix this bug in the next version. Also BaseX doesn't support the String of xml with namespace build DB. And I have no idea. PS: BaseX57,Jdk1.5 best wishes Ruby

1 0

Bug: baseX can't create XMLDB with non utf-8 xml String
by l0979365428＠gmail.com 31 Mar '10

31 Mar '10

Dear baseX creater: If it is xml file ,it 's ok. If it is xml String, BaseX only receives utf-8 encoding of XML. The reasion is : //---------------------------------------------------// public static IO get(final String s) { if(s == null) return new IOFile(""); if(s.startsWith("<")) return newIOContent(Token.token(s)); if(s.startsWith("http://")) return new IOUrl(s); return new IOFile(s); //---------------------------------------------------------// public static byte[] token(final String s) { final int l = s.length(); if(l == 0) return EMPTY; final byte[] bytes = new byte[l]; for(int i = 0; i < l; i++) { final char c = s.charAt(i); if(c > 0x7F) return utf8(s); bytes[i] = (byte) c; } return bytes; //-----------------------------------------------// Doesn't parse with the head of XML file. But this programe create xml struts with Sax which pares the xml with the head info. For this reason，it'll make mistakes once the XML String is not UTF-8. I fix it : if(s.startsWith("<")) return new IOContent(Token.encoding(s)); //----------------------------------------------// public static byte[] encoding(final String s) { final int l = s.length(); if(l == 0) return EMPTY; int i=0; int j =0; StringBuilder ss=new StringBuilder(); char hope[]=new char[]{'c','=','"','"'}; while (true) { final char c = s.charAt(i); if(hope[j]==c) j++; if(j==4) break; if(j>2&&c!=hope[j-1]) { ss.append(c); } i++; } final byte[] bytes = new byte[l]; for(int k = 0; k < l; k++) { final char c = s.charAt(k); if(c > 0x7F) return others(s,ss.toString()); bytes[k] = (byte) c; } return bytes; } //-----------------------------------------------// I wonder if you could fix this bug in the next version. Also BaseX doesn't support the String of xml with namespace build DB. And I have no idea. PS: BaseX57,Jdk1.5 best wishes Ruby

1 0

Re: [basex-talk] Problems connecting to the database
by Christian Grün 30 Mar '10

30 Mar '10

Hi Daniel (cc to mailing list), > wow, this where a quick response :) ..you're welcome. >> Hm, didn't experience this before; have you tried BaseX on another >> machine, or user other ports? > > Tried it on my pc and on the server, same result. > >> By the help of your mail, I noticed that our documentation was >> out-of-dated; you need to specify -n instead -s (or try -h for help). >> I've updated our docs. Next, just to get sure, verify if port 7000 is >> opened on your server machine. > > Thank you for that, found out port 7000 where not open by default, and > corrected that. > > With no change in the BaseXServer behavior, I where expecting som sort > of console to controle the server with, but that will not happen? You can throw in the -i argument to end up in the console mode. Note that all admin commands can as well be used from another client, which is logged in with admin rights. > I solved another problem I got an now the Client code ask for login > and password, but now it just times out every time I try to log on. So you're getting a "Timeout exceeded." message? Hm, this would indicate that the server isn't reachable. Are you sure the ports are opened and available? > When I am logging on I am able to use the default admin/admin > login/password right? > My CentOS server, where the BaseX server is, have a password for every > user but If I have opened the port I dont need to go through any proxy > there, I just use admin/admin? …exactly, admin/admin is the default login. You may adjust the admin password or add more users in the next step. Christian > > ~DWP > > 2010/3/26 Christian Grün <christian.gruen(a)gmail.com>: >> Hi, >> >>> java -cp BaseX6.jar org.basex.BaseXServer -p 7000 >>> >>> To set up a server listening on port 7000. And i says "BaseX 6.0 >>> [server] \n Server was started" and not as it says in the guide >>> "Waiting for requests...", is that a problem? >> >> Hm, didn't experience this before; have you tried BaseX on another >> machine, or user other ports? >> >> >>> java -cp BaseX6.jar org.basex.BaseXClient -s [ip on my server] -p 7000 >>> >>> to try connecting, but then it just displays the help message and are >>> not doing anything. I am expecting a new console where I where able to >>> write commands to my baseX server, is that not the intention? >> >> By the help of your mail, I noticed that our documentation was >> out-of-dated; you need to specify -n instead -s (or try -h for help). >> I've updated our docs. Next, just to get sure, verify if port 7000 is >> opened on your server machine. >> >> Christian

3 14

xquery replace
by Travis Webb 28 Mar '10

28 Mar '10

I am trying to use xquery replace but cannot, it seems, figure out the correct syntax. As I understand it, the replace query should be of the form: "xquery replace expr with node", so I'm trying to do the following: > xquery replace root()/child with <child>new data</child> Stopped at line 1, column 15: Syntax: XQUERY [query] Evaluate XQuery. I've tried a number of variations but I get the same error. Any ideas? Thanks. -tjw

3 4

How to address a document inside a basex database?
by Sandra Maria Silcot 28 Mar '10

28 Mar '10

Hi all, I have a large database of about a dozen separate xml files. When I use the GUI interface, I can see them all in the graphical display, and as I pass the cursor over elements, it displays doc("om.xml")/... But when I try that in a query (the database is open), I'm told: FODC0002 File or directory C:/servers/basex/om.xml not found The basex installation is at C:/servers/basex and the currently opened database ("fasdb"), which was loaded from file 'om.xml' and others on a different machine, and downloaded, lives here: C:/servers/basex/BaseXData/fasdb How can I refer just to one document from that db in a query e.g. let $persons := doc("om.xml")//person Forgive me if this is a basic error on my part, I am still learning. I have tried variations on the basex:db construct, but all give a file not found error. If I move the document to where it is looking, basex builds a new db, not what I want at all! I'm sure there is a simple solution but I cannot see it. Any clues much appreciated. Cheers all, Sandra

2 1

Problems connecting to the database
by Daniel .Petersen 26 Mar '10

26 Mar '10

Hay Just started using baseX and have uploaded til executable .jar file to my server. Then i use the command: java -cp BaseX6.jar org.basex.BaseXServer -p 7000 To set up a server listening on port 7000. And i says "BaseX 6.0 [server] \n Server was started" and not as it says in the guide "Waiting for requests...", is that a problem? My intention is to be able to connect to my BaseX DB with a client from my pc to the server where the DB is. Then I on my pc run the command: java -cp BaseX6.jar org.basex.BaseXClient -s [ip on my server] -p 7000 to try connecting, but then it just displays the help message and are not doing anything. I am expecting a new console where I where able to write commands to my baseX server, is that not the intention? Thanks in advance for reading this and I hope for a quick answer. ~DWP

2 1