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

Agenda XMLPrague Users Meetup
by Colin McEnearney 06 Feb '13

06 Feb '13

Hi, These talks look interesting - wish I could make it! Please let us know if video or other materials are available afterwards. Thanks, Colin Date: Wed, 6 Feb 2013 11:51:37 +0100 From: Christian Gr?n <christian.gruen(a)gmail.com> To: BaseX <basex-talk(a)mailman.uni-konstanz.de>, BaseX <basex-announce(a)mailman.uni-konstanz.de> Subject: [basex-talk] Agenda XMLPrague Users Meetup Message-ID: <CAP94bnPYY-xMDczpVPbZCzOEf+ RH3UmM3txqA3wgzHh=BJEkNg(a)mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Dear all, the agenda of the two sessions of our BaseX Users Meetup is online [1]: SESSION I: ? 14:30 Christian Gr?n, Alexander Holupirek: Racing through the last 365 days ? 15:00 Arve Gengelbach, Sabine Teubner: How to develop RESTXQ-based web applications with BaseX ? 15:20 Andy Bunce: Adventures with BaseX web applications - RESTXQ, SVG, Angular.js and Node.js ? 15:40 Charles Foster: BaseX and XQJ, The XQuery API for Java SESSION II: ? 16:30 Gerald de Jong: BaseX at Work in Cultural Heritage ? 16:50 Cerstin Mahlow: Experiences with BaseX and XQuery for diachronic German texts ? 17:10 Dirk: Distribution and Replication in BaseX: What to expect in the future ? 17:30 Emanuele Panzeri: Flexible structural constraints in XQuery Full-Text Another thank you to our speakers; see many of you on Friday! Christian BaseX Team, [1] http://lanyrd.com/2013/basex-users-meetup-xml-prague

1 0

Re: [basex-talk] SAX Serializer
by Michael.Hedenus-EXT＠continental-corporation.com 06 Feb '13

06 Feb '13

Dear Christian, thanx! That's fine for me. I wondered how expensive it might be to instantiate a Serializer. One problem remains: In SAXSerializer line 253 the initializiation of Attr is missing. This leads to NPE. Fix: private Atts decls = new Atts(); If there are more problems I'll be happy to report them to you :D Mit freundlichen Grüßen/Best regards Dr. Michael Hedenus Software Developer Powertrain Engine Systems CSW ETV RGB T2 PIXEL GmbH Im Gewerbepark C15, 93059 Regensburg, Germany Telefon/Phone: +49 941 790-6362 Telefax: +49 941 79013-90771 E-Mail: michael.hedenus-ext(a)continental-corporation.com www.continental-corporation.com ______________________________________________________________________ Continental Automotive GmbH, Siemensstr. 12, 93055 Regensburg, Germany Geschäftsführer/Managing Directors: Helmut Matschi, Gérard Cordonnier, Harald Stuhlmann Sitz der Gesellschaft/Registered office: Hannover Registergericht/Commercial registry: Hannover, HRB 59424, USt-Id. Nr. DE814950663 _______________________________________________________________________ Proprietary and confidential. Distribution only by express authority of Continental AG or its subsidiaries.

2 1

SAX Serializer
by Michael.Hedenus-EXT＠continental-corporation.com 06 Feb '13

06 Feb '13

Dear Christian, it's very great that you've incorporated the SAXSerializer. But you've overdone it a bit. The setItem() method and the parse() methods are required. I've written a JUnit-Test to demonstrate the application of the SAXSerializer with JAXB. In line 49 there should be the method setItem, which you have removed. The JAXB unmarshaller is going to invoke parse(String) which now throws an exception with an 'unimplemented' note. So please re-enable the parse()-methods and re-introduce the setItem()-method. package basex.test.sax; import java.io.File; import javax.xml.bind.JAXBContext; import javax.xml.transform.Source; import javax.xml.transform.sax.SAXSource; import junit.framework.Assert; import org.basex.core.Context; import org.basex.core.cmd.CreateDB; import org.basex.io.serial.SAXSerializer; import org.basex.io.serial.Serializer; import org.basex.query.QueryProcessor; import org.basex.query.value.item.Item; import org.junit.Test; public class SAXSerializerTest { @Test public void unmarshallJAXBObjectWithSAXSerializer() throws Exception { File temp = getTemp(); JAXBContext jaxbContext = JAXBContext.newInstance (DomainObject.class); // create XML File input = new File(temp, "input.xml"); jaxbContext.createMarshaller().marshal(new DomainObject( "Object1", 42), input); // create DB System.setProperty("org.basex.path", temp.getAbsolutePath()); Context context = new Context(); new CreateDB("test1", input.getAbsolutePath()).execute(context); // get object from DB QueryProcessor queryProcessor = new QueryProcessor( "//domain-object[@name='Object1']", context); Item item1 = queryProcessor.iter().next(); // write out to see that item is here Serializer serializer1 = queryProcessor.getSerializer(System.out); serializer1.serialize(item1); serializer1.close(); SAXSerializer saxSerializer = new SAXSerializer(); SAXSource saxSource = new SAXSource(saxSerializer, null); // this is needed!!! saxSerializer.setItem(item1); DomainObject domainObject1 = jaxbContext.createUnmarshaller().unmarshal(saxSource, DomainObject.class ).getValue(); queryProcessor.close(); Assert.assertEquals(42, domainObject1.getValue()); } private File getTemp() { File temp = new File("d:/temp/basex"); //System.getProperty("java.io.tmpdir"); temp.mkdirs(); return temp; } } The code is attached to this mail.

2 1

BaseX as web application in servlet container
by marco fregonese 06 Feb '13

06 Feb '13

Hello, Is anyone there who can explain to me why in BaseX76.war (or previous versions) there are two WEB-INF directories each with a web.xml file inside? ~/BaseX76/WEB-INF/classes/WEB-INF/ Which web.xml file needs to be edited to configure BaseX as web application in Tomcat properly? Thanks. PS: I deployed BaseX75.war and 76 in Tomcat and they work after editing web.xml but I had to edit index.html and restxq.xqm as well to see style.css and basex.svg. Maybe it depends on my OS (Ubuntu) or my browser (Firefox), I don't know. Thank you.

2 2

Agenda XMLPrague Users Meetup
by Christian Grün 06 Feb '13

06 Feb '13

Dear all, the agenda of the two sessions of our BaseX Users Meetup is online [1]: SESSION I: · 14:30 Christian Grün, Alexander Holupirek: Racing through the last 365 days · 15:00 Arve Gengelbach, Sabine Teubner: How to develop RESTXQ-based web applications with BaseX · 15:20 Andy Bunce: Adventures with BaseX web applications - RESTXQ, SVG, Angular.js and Node.js · 15:40 Charles Foster: BaseX and XQJ, The XQuery API for Java SESSION II: · 16:30 Gerald de Jong: BaseX at Work in Cultural Heritage · 16:50 Cerstin Mahlow: Experiences with BaseX and XQuery for diachronic German texts · 17:10 Dirk: Distribution and Replication in BaseX: What to expect in the future · 17:30 Emanuele Panzeri: Flexible structural constraints in XQuery Full-Text Another thank you to our speakers; see many of you on Friday! Christian BaseX Team, [1] http://lanyrd.com/2013/basex-users-meetup-xml-prague

1 0

Re: [basex-talk] Problem with DOM LS serialization
by Michael.Hedenus-EXT＠continental-corporation.com 06 Feb '13

06 Feb '13

Dear Christian, I've no idea why DOM/LS still doesn't work, but with the SAXSerializer the problem is no more. When the SAXSerialier works query result can easily converted into any DOM using a simple ContentHandler implementation: /** * Constructs a DOM from SAX events. * Original idea by Florent Georges. */ public class SaxToDomHandler implements ContentHandler { private final DocumentBuilder documentBuilder; private Document document; private Node current; public SaxToDomHandler(DocumentBuilder documentBuilder) { this.documentBuilder = documentBuilder; } /** * Returns the created document. */ public Document getDocument() { return document; } @Override public void startDocument() throws SAXException { document = documentBuilder.newDocument(); current = document; } @Override public void startElement(String uri, String name, String qName, Attributes attrs) { Element element = document.createElementNS(uri, qName); for (int i = 0; i < attrs.getLength(); i++) { String nsURI = attrs.getURI(i); String qname = attrs.getQName(i); String value = attrs.getValue(i); Attr attr = document.createAttributeNS(nsURI, qname); attr.setValue(value); element.setAttributeNodeNS(attr); } current.appendChild(element); current = element; } @Override public void endElement(String uri, String name, String qName) { current = current.getParentNode(); } @Override public void endDocument() throws SAXException { current = current.getOwnerDocument(); } @Override public void characters(char[] ch, int start, int length) { String string = new String(ch, start, length); current.appendChild(document.createTextNode(string)); } @Override public void ignorableWhitespace(char[] ch, int start, int length) { characters(ch, start, length); } @Override public void processingInstruction(String target, String data) { current.appendChild(document .createProcessingInstruction(target, data)); } @Override public void setDocumentLocator(Locator locator) { //NOP } @Override public void startPrefixMapping(String prefix, String uri) throws SAXException { //NOP } @Override public void endPrefixMapping(String prefix) throws SAXException { //NOP } @Override public void skippedEntity(String name) throws SAXException { //NOP } }

1 0

Xquery over all collections
by pw＠themail.co.uk 06 Feb '13

06 Feb '13

Hello List I am wanting to query all collections in BaseX 7.5 without hard coding the names of each collection in my xquery. I can list the collections with db:list() but am struggling to get something like let $r := (collection('A'), collection('B'), collection('C'))/xml/indicator[code='myCode'] I can use db:list() to get all documents in all collections in this way: let $q := for $a in (db:list()) let $e :=string-join( $a, ',') return $e let $z := for $x in $q return db:open($x) for $r in $z return $r Can anyone please suggest a way of using db:list and other functions in xquery to perform a query on all collections. Cheers Peter

2 1

BaseX 7.6: The XMLPrague Edition
by Christian Grün 05 Feb '13

05 Feb '13

Hi all, we are excited to announce Version 7.6 of BaseX -- the XMLPrague Edition -- which provides some fresh new features that will further boost your productivity: DATABASE LOCKING: - updates on different databases can now be executed in parallel and won't lock your read-only queries anymore: http://docs.basex.org/wiki/Transaction_Management XQUERY - when errors are raised, the full stack trace is now returned - the EXPath Geo Module, Fetch Module and HTML Module have been added: http://docs.basex.org/wiki/Module_Library - the Validation, XSLT, Database and Profiling Module have been updated GUI - error messages are now clickable and linked with the text editor - trace/profiling output is redirected to the info view in realtime Have fun with our new release! Looking forward to your feedback, Christian BaseX Team, 2013

1 0

Re: [basex-talk] Problem with DOM LS serialization
by Michael.Hedenus-EXT＠continental-corporation.com 05 Feb '13

05 Feb '13

Dear Christian, thank you for quickly attacking the problem! But sorry, but the problem is not fixed.I get the same error. I have a general note. I have implemented a special serializer which implements org.xml.sax .XMLReader. This is used to directly dispatch the query result to JAXB and to created objects. I can now extend this technique to generate a new DOM by implementing a SAX ContentHandler which generates a DOM. Unfortunately the serializer API is not documented nor stable (it changed from 7.3 to 7.5). I propose to add a standard SAX serializer to BaseX. This would be a very useful extension. Here is my implementation: import static org.basex.util.Token.XMLNS; import static org.basex.util.Token.startsWith; import static org.basex.util.Token.string; import static org.basex.util.Token.substring; import java.io.IOException; import java.util.HashMap; import java.util.Map; import org.basex.io.serial.Serializer; import org.basex.query.value.item.Item; import org.xml.sax.ContentHandler; import org.xml.sax.DTDHandler; import org.xml.sax.EntityResolver; import org.xml.sax.ErrorHandler; import org.xml.sax.InputSource; import org.xml.sax.SAXException; import org.xml.sax.SAXNotRecognizedException; import org.xml.sax.SAXNotSupportedException; import org.xml.sax.XMLReader; import org.xml.sax.ext.LexicalHandler; import org.xml.sax.helpers.AttributesImpl; /** * Bridge to translate BaseX items to SAX events. * The parse() methods does the following: * <ol> * <li>notify startDocument()</li> * <li>serialize the item</li> * <li>notify endDocument()</li> */ public class FragmentSerializer extends Serializer implements XMLReader { /** * The item to be serialized */ private Item item; private ContentHandler contentHandler; private EntityResolver entityResolver; private DTDHandler dtdHandler; private ErrorHandler errorHandler; private LexicalHandler lexicalHandler; public FragmentSerializer() { } public Item getItem() { return item; } /** * Sets the item to be serialized. */ public void setItem(Item item) { this.item = item; } ////////////////////////////////////////////////// // XMLReader ////////////////////////////////////////////////// @Override public ContentHandler getContentHandler() { return contentHandler; } @Override public boolean getFeature(final String name) { return false; } @Override public Object getProperty(final String name) { return null; } public void parse() throws SAXException { parse(""); } @Override public void parse(final InputSource input) throws SAXException { parse(""); } @Override public void parse(final String id) throws SAXException { try { contentHandler.startDocument(); item.serialize(this); contentHandler.endDocument(); } catch (final Exception ex) { throw new SAXException(ex); } } @Override public void setContentHandler(final ContentHandler c) { contentHandler = c; } public void setLexicalHandler(final LexicalHandler l) { lexicalHandler = l; } @Override public void setEntityResolver(EntityResolver entityResolver) { this.entityResolver = entityResolver; } @Override public EntityResolver getEntityResolver() { return entityResolver; } @Override public void setDTDHandler(DTDHandler dtdHandler) { this.dtdHandler = dtdHandler; } @Override public DTDHandler getDTDHandler() { return dtdHandler; } @Override public void setErrorHandler(ErrorHandler errorHandler) { this.errorHandler = errorHandler; } @Override public ErrorHandler getErrorHandler() { return errorHandler; } @Override public void setFeature(final String name, final boolean value) throws SAXNotRecognizedException, SAXNotSupportedException { throw new SAXNotRecognizedException(); } @Override public void setProperty(final String name, final Object value) throws SAXNotRecognizedException, SAXNotSupportedException { throw new SAXNotRecognizedException(); } ////////////////////////////////////////////////// // Serializer ////////////////////////////////////////////////// private final HashMap<String, String> attributes = new HashMap<String, String>(); private NSDecl namespaces; @Override protected void startOpen(byte[] n) throws IOException { attributes.clear(); this.namespaces = new NSDecl(this.namespaces); } @Override protected void attribute(byte[] n, byte[] v) throws IOException { String value = string(v); String prefix = null; if (startsWith(n, XMLNS)) { if (n.length == 5) { prefix = ""; } else if (n[5] == ':') { prefix = string(substring(n, 6)); } } if (prefix != null) { namespaces.put(prefix, value); } else { String name = string(n); attributes.put(name, value); } } @Override protected void finishOpen() throws IOException { try { AttributesImpl attrs = new AttributesImpl(); for (Map.Entry<String, String> e : attributes.entrySet()) { String rname = e.getKey(); String[] qname = qname(rname); String ns = namespaces.get(qname[0]); String lname = qname[1]; attrs.addAttribute(ns, lname, rname, null, e.getValue()); } String rname = string(elem); String[] qname = qname(rname); String ns = namespaces.get(qname[0]); String lname = qname[1]; contentHandler.startElement(ns, lname, rname, attrs); // System.out.println("{" + ns + "}" + lname); // for (int i = 0; i < attrs.getLength(); i++) // { // System.out.println(" {" + attrs.getURI(i) + "}" + attrs.getLocalName(i) + "=" + attrs.getValue(i)); // } } catch (final SAXException e) { throw new IOException(e.getMessage()); } } public String[] qname(String rname) { String prefix = ""; String lname = rname; int i = rname.indexOf(':'); if (i > 0) { prefix = rname.substring(0, i); lname = rname.substring(i + 1); } return new String[] { prefix, lname }; } @Override protected void finishEmpty() throws IOException { finishOpen(); finishClose(); } @Override protected void finishClose() throws IOException { try { String name = string(elem); contentHandler.endElement("", name, name); this.namespaces = namespaces.getParent(); } catch (final SAXException e) { throw new IOException(e.getMessage()); } } @Override protected void finishText(byte[] text) throws IOException { try { String s = string(text); final char[] c = s.toCharArray(); contentHandler.characters(c, 0, c.length); } catch (final SAXException e) { throw new IOException(e.getMessage()); } } @Override protected void finishComment(byte[] comment) throws IOException { if (lexicalHandler != null) { try { String s = string(comment); final char[] c = s.toCharArray(); lexicalHandler.comment(c, 0, c.length); } catch (final SAXException e) { throw new IOException(e.getMessage()); } } } @Override protected void finishPi(byte[] n, byte[] v) throws IOException { //ignored } @Override protected void atomic(Item i) throws IOException { //ignored } } class NSDecl { private final NSDecl parent; private Map<String, String> decls; public NSDecl(NSDecl parent) { this.parent = parent; } public NSDecl getParent() { return parent; } public void put(String prefix, String uri) { if (decls == null) { decls = new HashMap<String, String>(); } decls.put(prefix, uri); } public String get(String prefix) { String ns = null; for (NSDecl c = this; c != null; c = c.parent) { if (c.decls != null) { ns = c.decls.get(prefix); if (ns != null) { break; } } } return ns != null ? ns : ""; } }

2 1

Surplus Assets for Sale
by Shawna Sumerlin 04 Feb '13

04 Feb '13

Do you have any surplus assets, commercial equipment or machinery that you are looking to sell? Salvex handles the sale of all types of assets on an international basis for major oil companies, insurance and asset recovery departments. If you have anything available, please let us know. If you'd like to learn more about our global enterprise solutions, where you can redeploy your assets internally, manage your asset sales and keep track of projects, please contact us at sales(a)salvex.com, or visit our website www.salvex.com. You can also view our current listings. Regards, Shawna Sumerlin Salvex, Inc. 723 Main St. Ste. 600 Houston, TX 77002 713-229-9000 - Phone 973-556-1328 - Fax shawna(a)salvex.com - E-mail www.salvex.com - Web Site THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL TO WHOM IT IS ADDRESSED AND CONTAINS INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. IF YOU ARE NOT THE INTENDED RECIPIENT, OR THE EMPLOYEE OR AGENT RESPONSIBLE FOR DELIVERING THIS MESSAGE TO THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED THAT ANY UNAUTHORIZED DISCLOSURE, DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, OR ARE NOT SURE WHETHER IT IS PRIVILEGED, PLEASE IMMEDIATELY NOTIFY US BY REPLY E-MAIL AT cwilson(a)salvex.com THANK YOU.

1 0