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

Reg : Collection Creation For Huge XML
by Chandrasekhar 22 Nov '14

22 Nov '14

Dear Team We are adding the 4gb xml file to the collection,while adding the file we are getting the out of main memory.My java application has the 4gb memory.Can you please help me on this.We are using the LocalSession for creating the collection. Thanks&Regards ChandraSekhar The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited.

2 3

small issue with map:put()
by Rob Stapper 21 Nov '14

21 Nov '14

Hi, See attached snippet. I get the error-message: no context value bound, on this one. What's going wrong here? Rob --- Dit e-mailbericht bevat geen virussen en malware omdat avast! Antivirus-bescherming actief is. http://www.avast.com

3 7

Is this an inlining/query compilation issue?
by Marc van Grootel 21 Nov '14

21 Nov '14

Hi, I found that with the following code the trace shows that, for the two functions (FN) created, both have gotten "ul" inlined. I expected the first to get "ul" and the second "li" and that is also what xpath-matches() receives (X). declare function local:select($selectors as item()*) as function(node()*) as node()* { let $fns := for $selector in $selectors return if ($selector instance of xs:string) then trace(local:xpath-matches(trace($selector,'X: ')),'FN: ') else $selector return function($nodes) { fold-left($fns, $nodes, function($nodes, $fn) { $fn($nodes) } ) } }; declare function local:xpath-matches($selector as xs:string) { function($node as node()*) as node()* { xquery:eval($selector, map { '': $node }) } }; local:select(('ul','li'))(<ul><li>item</li></ul>) --Marc

5 8

Re: [basex-talk] BaseX and MySQL
by Hans-Juergen Rennau 20 Nov '14

20 Nov '14

Vincent, cordial thanks for your concise instructions, you helped me a lot, it works and I am glad. And also thanks to Fabrice. Cheers, Hans Fabrice Etanchaud <fetanchaud(a)questel.com> schrieb am 9:35 Donnerstag, 20.November 2014: #yiv2295957486 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}#yiv2295957486 filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}#yiv2295957486 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv2295957486 filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv2295957486 p.yiv2295957486MsoNormal, #yiv2295957486 li.yiv2295957486MsoNormal, #yiv2295957486 div.yiv2295957486MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv2295957486 a:link, #yiv2295957486 span.yiv2295957486MsoHyperlink {color:#0563C1;text-decoration:underline;}#yiv2295957486 a:visited, #yiv2295957486 span.yiv2295957486MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;}#yiv2295957486 p.yiv2295957486MsoAcetate, #yiv2295957486 li.yiv2295957486MsoAcetate, #yiv2295957486 div.yiv2295957486MsoAcetate {margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv2295957486 span.yiv2295957486EmailStyle17 {color:#1F497D;}#yiv2295957486 span.yiv2295957486EmailStyle18 {color:#1F497D;}#yiv2295957486 span.yiv2295957486TextedebullesCar {}#yiv2295957486 .yiv2295957486MsoChpDefault {font-size:10.0pt;}#yiv2295957486 filtered {margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv2295957486 div.yiv2295957486WordSection1 {}#yiv2295957486 Dear all, You might have to add the following call before sql :connect() : sql:init("com.mysql.jdbc.Driver") I found it mandatory in xqm modules run inside Tomcat, for example. If you start playing with the SQL module, You will realize that BaseX rocks also on SQL repositories ! With RESTXQ+SQLMODULE you can write in a few lines a REST service exposing SQL data. Best regards, Fabrice Etanchaud Questel/Orbit De : basex-talk-bounces(a)mailman.uni-konstanz.de [mailto:basex-talk-bounces@mailman.uni-konstanz.de]De la part de Lizzi, Vincent Envoyé : mercredi 19 novembre 2014 23:31 À : Hans-Juergen Rennau; basex-talk(a)mailman.uni-konstanz.de Objet : Re: [basex-talk] BaseX and MySQL Hans, I had to do this a few days ago, so it’s fresh in my mind. Download Connector/J from the MySQL website and place .jar file in the basex/lib folder. Restart BaseX (if you’re using the server version) so it picks up the new .jar. Queries can then be run like: let $c := sql:connect('jdbc:mysql://localhost/database', 'user', 'password') sql:execute($c, "select …") sql:execute($c, "call stored_procedure…();") Cheers, Vincent From:basex-talk-bounces@mailman.uni-konstanz.de [mailto:basex-talk-bounces@mailman.uni-konstanz.de]On Behalf Of Hans-Juergen Rennau Sent: Wednesday, November 19, 2014 5:20 PM To: basex-talk(a)mailman.uni-konstanz.de Subject: [basex-talk] BaseX and MySQL Dear BaseX team, can you point me to some information about which steps I must take in order to start accessing MySQL databases via the sql module? Thank you for help, Hans-Juergen

1 0

BaseX and MySQL
by Hans-Juergen Rennau 20 Nov '14

20 Nov '14

Dear BaseX team, can you point me to some information about which steps I must take in order to start accessing MySQL databases via the sql module? Thank you for help,Hans-Juergen

3 2

QueryProcessor's result has 'restructured ns declarations'
by Erdal Karaca 19 Nov '14

19 Nov '14

Hi all, I have this file (simplified): <r:root xmlns:r="r" xmlns:x="x" xmlns:y="y" xmlns:z="z"> <x:x/> <y:y/> <z:z/> </r:root> I have created a new database from that file (using Java API) and checked in the GUI that the file's contents are as "expected" by querying the root of the database. Now, when using the QueryProcessor API to query the root of the database, I will get this re-structured namespaces xml: <r:root xmlns:r="r"> <x:x xmlns:x="x"/> <y:y xmlns:y="y"/> <z:z xmlns:z="z"/> </r:root> How can I prevent this behavior? Is there a setting to provide to the QueryProcessor? Thanks!

2 4

SAXSerializer does not transmit namespace declarations as attributes
by Erdal Karaca 19 Nov '14

19 Nov '14

Hi all, I am using the SAXSerializer to generate SAX events from an org.basex.query.value.item.Item instance. The Item instance represents the database doc's root in this specific case: <r:root xmlns:r="r" xmlns:x="x" x:attr="test"> </r:root> It seems that when the following method is called: org.xml.sax.ContentHandler.startElement(String, String, String, Attributes) the attributes map is missing namespace declarations (I would expect the ns declarations to be mapped to attributes). I.e. the above r:root element will be provided with just the x:attr in the attributes map, but not the xmlns:x as attribute. Do you have any solutions for this issue? How do I get the namespaces when startElement() is executed? Thanks!

2 1

Opened by another process
by Paul Swennenhuis 18 Nov '14

18 Nov '14

Why would I get a bxerr:BXDB0007 error "Database 'profiles' cannot be updated, as it is opened by another process" when executing these commands from a BaseX client: open profiles; xquery insert node <profile>abc</profile> into /profiles Where "profiles" is an existing database, and /profiles an existing root element, and I am quite positive that the database is NOT being used in another process? When I issue these commands on localhost it is working fine. Paul

5 6

IDs management
by Ioan Fericel 17 Nov '14

17 Nov '14

Hello all, I would like to ask your advice on the best practice to use the IDs in BaseX, somewhat in the classic style of relationships between records in different nodes or documents. I have not found a simple way to create autoincrement IDs, and indexes generated by BaseX I understand that it's possible to suffer changes in case of optimization actions or database recovery. So I can not count on them. I try to do it using attributes as unique identifiers in repetitive elements, like: <products> . . . <product id="123" name="abc" description="xyz"/> <product id="124" name="bbbb" description="xxxxxxx"/> </products> <product-template> <product id="" name="" description="" ... /> </product-template> When adding a new product, I need to calculate the max from products/product/@id, incremented by 1 and replaced with this value (125) the id of the product template. After that, the updated product template should be inserted in the node products. I try to do all this in a single restxq function, in many ways, but fail. Please give me, first, an general idea of how the problem should be approached in working with BaseX. Many thanks, Ioan

3 3

Connecting to BaseX with PHP client
by Paul Swennenhuis 17 Nov '14

17 Nov '14

Hi, I have successfully deployed BaseX on an Amazon Web Services instance using the "Elastic Beanstalk application container" and the BaseX79.WAR distribution. The REST interface works as is demonstrated by going to http://drpbasex2.elasticbeanstalk.com/rest/?run=xq/countries.xq&country=^a Now I try to connect to BaseX using the PHP implementation of a BaseX Client (BaseXClient.php). I can't figure out what connection parameters to use though. For "host" I tried drpbasex2.elasticbeanstalk.com (the web address), ec2-54-93-168-77.eu-central-1.compute.amazonaws.com (used for SSH connecting) and 54.93.168.77 (the public IP address Amazon Web Services indicates for this instance) For "port" I tried 1984 (default) and 8984 For "user" and "password" I used the BaseX defaults (admin/admin) I tried any combination of the above parameters but I always get an "can't connect to targe computer" in the socket_connect() line of BaseXClient.php (running from localhost) I can think of a number of reasons why the connection is refused: Credentials Should the credentials be something different from admin/admin? Should I maybe actively set credentials for the REST interface in web.xml? Inbound ports In the BaseX instance on Amazon Web Services(AWS) I can configure ports for inbound traffic, for example port 22 for SSH access. It might be needed to allow access for port 1984 or 8984, but the only way to do that is to use a 'Custom TCP' protocol. I already did that and it makes no difference. What protocol should be used? No connection allowed from localhost? Maybe connecting from localhost is not allowed? Any help pointing me in the right direction is appreciated. Paul

1 1