BaseX-Talk March 2010

basex-talk@mailman.uni-konstanz.de

20 participants
41 discussions

XPath or ID for node
by Perry Trolard 25 Mar '10

25 Mar '10

Dear List, I wonder if there's a method in BaseX for getting a unique identifier for a node. If I had a document in memory & was using, say, Saxon, I'd call a method on the node to return its location as an XPath string, but using XQuery in BaseX, is there a "somefn" such that for $d in $doc//date return <result path="{somefn($d}">{$d}</result> would return <result path="/root/date[5]"><date when="2010-03-25"/></result> or some such? I understand that nodes are identified internally in BaseX by their pre-order traversal index – is there a way get the pre number? If not directly from an XQuery function, perhaps in some of the Java client code? My use case is that I'd like to return elements – <date>'s, e.g. – with info about their location in the document so that later & on-demand I can get more info about certain dates – ancestor elements, &c; so, in short, I'd like to get a handle on the node for later retrieval. Thanks, Perry Trolard

2 3

xqresultsequence : retrieve item as node or string?
by Travis Webb 23 Mar '10

23 Mar '10

I have a question regarding efficiency in the xqresultsequence in the XQJ API. I've found no documentation on how this object is actually represented. Does anyone know if it is faster to request the result as a string (getItemAsString(null)) or as a DOM node (getNode())? Any info is appreciated. Thanks. -tjw

2 2

Re: [basex-talk] problems with fn:root function and comparision
by Jiří Kadlec 22 Mar '10

22 Mar '10

Hi Christian, thanks for your help. I tried using is operator instead of = and now I got expected result, but I got error with comparsion where true should be returned. i.e when I call fn:root(/test) is /test which should return true, but it returns false. I'm using same simple XML. <?xml version='1.0' encoding='UTF-8'?> <test> <nodes> <node></node> </nodes> <nodes2> </nodes2> </test> Is there something above /test some "super root"? I have checked what returns each command and the result is the same. for both, but when I check tree map window in base-x gui I found out that fn:root(/test) select my.xml and /test select test node directly. Is this a right behaviour? Thanks again for quick and helpful responses Jiri > Hi Jiří, > > "=" is a »general comparison« operator, which compares the atomized > values of your left and right operands. So-called »node comparison« > operators will give you the expected result: > > fn:root(/test/nodes) is /test/nodes > > More details in the specs: http://www.w3.org/TR/xquery/#id-node-comparisons > > Christian > > > On Fri, Mar 19, 2010 at 5:12 PM, Jiří Kadlec <jir.kadlec at post.cz> wrote: > > Hi guys, > > > > I'm having a trouble with using fn:root function. I want to check if given > XPath selects root node. So i decided to do it with following > > > > for eg. /test/nodes - is example XPath chosing non root element and i want to > check if this is root element byt running one of these statements > > > > fn:root(/test/nodes) = /test/nodes or fn:root() = /test/nodes > > > > both of these return true on following document: > > > > <?xml version='1.0' encoding='UTF-8'?> > > <test> > > <nodes> > > <node></node> > > </nodes> > > <nodes2> > > </nodes2> > > </test> > > > > when I run just first part of statement fn:root(/test/nodes) I get: > > <test> > > <nodes> > > <node/> > > </nodes> > > <nodes2/> > > </test> > > > > which is ok when I run separately /test/nodes i got this: > > <nodes> > > <node/> > > </nodes> > > > > it's also ok but when I try to compare it together I get false which is > definitelly not OK. > > i.e fn:root(/test/nodes) = /test/nodes .... returns true > > > > Am I doing something wrong or it's a bug in base-X. I have tried also last > BASE-X 6.03 and I'm having same problem. > > > > Thank you for help > > > > Jiri > > ___________________________ > > Christian Gruen > Universitaet Konstanz > Department of Computer & Information Science > D-78457 Konstanz, Germany > Tel: +49 (0)7531/88-4449, Fax: +49 (0)7531/88-3577 > http://www.inf.uni-konstanz.de/~gruen > > > >

2 1

problems with fn:root function and comparision
by Jiří Kadlec 19 Mar '10

19 Mar '10

Hi guys, I'm having a trouble with using fn:root function. I want to check if given XPath selects root node. So i decided to do it with following for eg. /test/nodes - is example XPath chosing non root element and i want to check if this is root element byt running one of these statements fn:root(/test/nodes) = /test/nodes or fn:root() = /test/nodes both of these return true on following document: <?xml version='1.0' encoding='UTF-8'?> <test> <nodes> <node></node> </nodes> <nodes2> </nodes2> </test> when I run just first part of statement fn:root(/test/nodes) I get: <test> <nodes> <node/> </nodes> <nodes2/> </test> which is ok when I run separately /test/nodes i got this: <nodes> <node/> </nodes> it's also ok but when I try to compare it together I get false which is definitelly not OK. i.e fn:root(/test/nodes) = /test/nodes .... returns true Am I doing something wrong or it's a bug in base-X. I have tried also last BASE-X 6.03 and I'm having same problem. Thank you for help Jiri

2 1

Re: [basex-talk] Well done!
by Christian Grün 18 Mar '10

18 Mar '10

Hi Erik, all of your suggestions are more than welcome – this is why I posted your answer back to the mailing list. I invite all of you to give personal feedback! > A few questions for you about basex and plans... > 1) Can a database store files other than xml? xqy/xql, images, js, css, etc? Our storage is currently limited to well-formed XML documents. > 2) Any plans to add collections or may basex does and I've overlooked it? Yes, BaseX supports collections – as long as they are flat. Databases can store multiple single documents, which can be accessed e.g. by the XQuery collection() function. See also Section 4.4 in http://basex.org/faq. > 3) ReST interface: There are two approaches, both have their benefits and I would like to see both available: > a) The rest interface allows manipulating db resources: dbs, collections, files, users, permissions, etc. (The eXist db does this.) > -The main advantage with this is an API easy to integrate into many environments > b) The rest interface allows requests to be rewritten to a delegate xquery file to handle processing the http methods. (Some other db's provide this.) > -This allows building complete applications within a database. > -Would like to see this as the base approach with (a) as an internal implementation of (b) > What are your thoughts? Interesting ideas.. Some of our current interface features are be inspired by eXist. While GET and POST can be used to send XQuery/Update requests, PUT and DELETE will allow to modify database instances. Here is a simple example how a GET request could look like: http://localhost:8080/rest/db/factbook?query=//country Additionally, we will allow to send BaseX database commands via GET and POST.. http://localhost:8080/rest/db/factbook?command=optimize This way, user management can be handled via REST as well. I'm not sure how users are modified in eXist via REST? Which other XML/REST implementations have you worked with? > 4) Any plans for webdav? This makes moving files in and out of the db easy for non-technical users. I've briefly looked at doing this with milton, apache jackrabbit, and from scratch. > 5) What do you think about using OSGI to enable plugging in db services? Bundles would be something like dbServer (the core service), tcpServer, restAdminServer, restServer, webdavServer, webAdmin, cliAdmin, monitorServer clusterServer, etc. This keeps the dbServer core code clean and small, yet allows other services to be developed and evolve independently. It also allows spinning up multiple instances of a server. For example, I could spin up multiple restServers or tcpServers on different ports to segment applications, or multiple webdav servers to partition content management per user/group rights. > 6) What do you think about moving to github? Looking for ways to grow basex community more quickly. Good suggestions.. Let's see what everyone thinks about it! > Hope you don't mind me jumping in. I see a great product whose continued and expanded development is important to this industry. You are welcome, Christian ___________________________ Christian Gruen Universitaet Konstanz Department of Computer & Information Science D-78457 Konstanz, Germany Tel: +49 (0)7531/88-4449, Fax: +49 (0)7531/88-3577 http://www.inf.uni-konstanz.de/~gruen

3 6

help required for xquery
by Ganesh K 18 Mar '10

18 Mar '10

Hello, Attached is xquery which i used. I tried using the xquery it halts with error Stopped at line 1, column 8191: [XPST0003] Expecting ">". i did try adding one more } as escaping. Need some help. I am using PHP to do so. Will try this in java later. Awaiting your quick reply. Thanks Ganesh K

2 1

Building BaseX
by Adrien Guillon 17 Mar '10

17 Mar '10

I want to build my own version of BaseX... I'm on Kubuntu 9.10 and do all my work through the command line (no eclipse for me). I ran make clean && make at the root of the project and I get a bunch of errors. This is a fresh build. What I want is to build a version of the source code with debugging enabled (-g). If there is already a way to do this please let me know. It looks like I need a stub function or something for XQJ ? Here are the errors: aj@laptopzilla:~/basex_src/clean/basex$ make test -r sourcelist || find src -regex '.*/[^./]*\.java' > sourcelist test -e bin || mkdir bin javac -sourcepath src -d bin @sourcelist src/org/basex/api/xqj/BXQDataSource.java:7: package javax.xml.xquery does not exist import javax.xml.xquery.XQConnection; ^ src/org/basex/api/xqj/BXQDataSource.java:8: package javax.xml.xquery does not exist import javax.xml.xquery.XQDataSource; ^ src/org/basex/api/xqj/BXQDataSource.java:9: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQDataSource.java:17: cannot find symbol symbol: class XQDataSource public final class BXQDataSource implements XQDataSource { ^ src/org/basex/api/xqj/BXQConnection.java:5: package javax.xml.xquery does not exist import javax.xml.xquery.XQConnection; ^ src/org/basex/api/xqj/BXQConnection.java:6: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQConnection.java:7: package javax.xml.xquery does not exist import javax.xml.xquery.XQExpression; ^ src/org/basex/api/xqj/BXQConnection.java:8: package javax.xml.xquery does not exist import javax.xml.xquery.XQMetaData; ^ src/org/basex/api/xqj/BXQConnection.java:9: package javax.xml.xquery does not exist import javax.xml.xquery.XQPreparedExpression; ^ src/org/basex/api/xqj/BXQConnection.java:10: package javax.xml.xquery does not exist import javax.xml.xquery.XQStaticContext; ^ src/org/basex/api/xqj/BXQDataFactory.java:12: package javax.xml.xquery does not exist import javax.xml.xquery.XQDataFactory; ^ src/org/basex/api/xqj/BXQDataFactory.java:13: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQDataFactory.java:14: package javax.xml.xquery does not exist import javax.xml.xquery.XQItem; ^ src/org/basex/api/xqj/BXQDataFactory.java:15: package javax.xml.xquery does not exist import javax.xml.xquery.XQItemType; ^ src/org/basex/api/xqj/BXQDataFactory.java:16: package javax.xml.xquery does not exist import javax.xml.xquery.XQSequence; ^ src/org/basex/api/xqj/BXQDataFactory.java:17: package javax.xml.xquery does not exist import javax.xml.xquery.XQSequenceType; ^ src/org/basex/api/xqj/BXQAbstract.java:14: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQAbstract.java:15: package javax.xml.xquery does not exist import javax.xml.xquery.XQItemType; ^ src/org/basex/api/xqj/BXQDataFactory.java:39: cannot find symbol symbol: class XQDataFactory class BXQDataFactory extends BXQAbstract implements XQDataFactory { ^ src/org/basex/api/xqj/BXQConnection.java:19: cannot find symbol symbol: class XQConnection final class BXQConnection extends BXQDataFactory implements XQConnection { ^ src/org/basex/api/xqj/BXQDataSource.java:27: cannot find symbol symbol : class XQConnection location: class org.basex.api.xqj.BXQDataSource public XQConnection getConnection(final Connection c) throws XQException { ^ src/org/basex/api/xqj/BXQDataSource.java:27: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataSource public XQConnection getConnection(final Connection c) throws XQException { ^ src/org/basex/api/xqj/BXQDataSource.java:31: cannot find symbol symbol : class XQConnection location: class org.basex.api.xqj.BXQDataSource public XQConnection getConnection(final String name, final String pw) { ^ src/org/basex/api/xqj/BXQDataSource.java:43: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataSource public String getProperty(final String key) throws XQException { ^ src/org/basex/api/xqj/BXQDataSource.java:59: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataSource public void setProperties(final Properties prop) throws XQException { ^ src/org/basex/api/xqj/BXQDataSource.java:64: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataSource throws XQException { ^ src/org/basex/api/xqj/BXQMetaData.java:6: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQMetaData.java:7: package javax.xml.xquery does not exist import javax.xml.xquery.XQMetaData; ^ src/org/basex/api/xqj/BXQMetaData.java:16: cannot find symbol symbol: class XQMetaData final class BXQMetaData extends BXQAbstract implements XQMetaData { ^ src/org/basex/api/xqj/BXQConnection.java:25: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public void commit() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:29: cannot find symbol symbol : class XQExpression location: class org.basex.api.xqj.BXQConnection public XQExpression createExpression() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:29: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public XQExpression createExpression() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:33: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection public XQExpression createExpression(final XQStaticContext sc) ^ src/org/basex/api/xqj/BXQConnection.java:33: cannot find symbol symbol : class XQExpression location: class org.basex.api.xqj.BXQConnection public XQExpression createExpression(final XQStaticContext sc) ^ src/org/basex/api/xqj/BXQConnection.java:34: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:44: cannot find symbol symbol : class XQMetaData location: class org.basex.api.xqj.BXQConnection public XQMetaData getMetaData() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:44: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public XQMetaData getMetaData() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:49: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection public XQStaticContext getStaticContext() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:49: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public XQStaticContext getStaticContext() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:55: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:54: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final InputStream is, ^ src/org/basex/api/xqj/BXQConnection.java:55: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:59: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final InputStream is) ^ src/org/basex/api/xqj/BXQConnection.java:60: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:65: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:64: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final Reader r, ^ src/org/basex/api/xqj/BXQConnection.java:65: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:69: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final Reader r) ^ src/org/basex/api/xqj/BXQConnection.java:70: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:75: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:74: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final String query, ^ src/org/basex/api/xqj/BXQConnection.java:75: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:83: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final String query) ^ src/org/basex/api/xqj/BXQConnection.java:84: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:88: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public void rollback() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:92: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public void setAutoCommit(final boolean ac) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:97: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection public void setStaticContext(final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:97: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public void setStaticContext(final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQItemType.java:6: package javax.xml.xquery does not exist import javax.xml.xquery.XQItemType; ^ src/org/basex/api/xqj/BXQItemType.java:7: package javax.xml.xquery does not exist import javax.xml.xquery.XQSequenceType; ^ src/org/basex/api/xqj/BXQItemType.java:18: cannot find symbol symbol: class XQItemType final class BXQItemType implements XQItemType { ^ src/org/basex/api/xqj/BXQDataFactory.java:49: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final URI uri) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:53: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory public BXQItemType createAtomicType(final int b) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:59: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final QName qn2, final URI uri) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:64: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:70: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory public BXQItemType createCommentType() throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:75: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItemType createDocumentElementType(final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:76: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:85: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItemType createDocumentSchemaElementType(final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:86: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:95: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory public BXQItemType createDocumentType() throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:101: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final QName qn2, final URI uri, final boolean n) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:107: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:111: cannot find symbol symbol : class XQItem location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItem(final XQItem v) throws XQException { ^ src/org/basex/api/xqj/BXQItem.java:14: package javax.xml.xquery does not exist import javax.xml.xquery.XQConnection; ^ src/org/basex/api/xqj/BXQItem.java:15: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQItem.java:16: package javax.xml.xquery does not exist import javax.xml.xquery.XQItemType; ^ src/org/basex/api/xqj/BXQItem.java:17: package javax.xml.xquery does not exist import javax.xml.xquery.XQResultItem; ^ src/org/basex/api/xqj/BXQItem.java:41: cannot find symbol symbol: class XQResultItem final class BXQItem extends BXQAbstract implements XQResultItem { ^ src/org/basex/api/xqj/BXQDataFactory.java:111: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItem(final XQItem v) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:122: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromAtomicValue(final String v, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:123: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:133: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromBoolean(final boolean v, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:134: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:139: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromByte(final byte v, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:140: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:145: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory final String base, final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:145: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final String base, final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:151: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:151: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:156: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromDocument(final Source s, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:157: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:162: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:162: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:169: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:169: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:174: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromDouble(final double v, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:175: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:180: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromFloat(final float v, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:181: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ 100 errors make: *** [bin] Error 1 rm sourcelist

2 3

Re: [basex-talk] Information
by Christian Grün 17 Mar '10

17 Mar '10

> i have executed the below query in php > $session->execute("insert {" . $row['UDFInformation'] . "} into > basex:db(""nhlive"")/NewDataSet"); Note that the PHP API is just a simple wrapper for BaseX commands. If you define valid XQuery expressions, they should work fine within PHP, so it's advisable to first run them in the BaseX GUI or on command-line. The following tutorials might give you a clue how to perform updates via XQuery Update: – http://xqilla.sourceforge.net/XQueryUpdate – http://www.xmlmind.com/_tutorials/XQueryUpdate/index.html Best, Christian > but no result > as per my understanding Insert is the command udinformation is the xml data > and which is being added to nhlive database after /NewDataSet. For your > reference i have attached one xml file. There will be more xml files like > this to be added in the XMLServer. > so it would be like this > 1st file content > <NewDataSet> > </NewDataSet> > 2nd file content > <NewDataSet> > </NewDataSet> > hope you getting what i am attempting to do. > > i dont have much idea of XQuery i am just learning them. If you point me > link of PHP with Xquery would be great. > > Thanks > Ganesh K > > On Wed, Mar 17, 2010 at 12:36 PM, Ganesh K <ganeshk(a)21chms.com> wrote: >> >> Hi Christian, >> Thanks for your reply, i will find some way. Mean while as you >> mentioned with regards to api. I tried converting the jar file to .Net >> using ikvm the compilation was successful without any error and got the dll, >> but when i tried to use it in .Net below two namespace were not available >> dont know is it problem of the IKVM or something else. >> 'Imports org.basex.core.proc.XQuery >> 'Imports org.basex.data.Result >> >> I also tried using the api using php now what happens i am not able to get >> the result i.e the xml structure which it contains. i shall mail u with >> attachment in short while. >> >> >> Thanks >> >> On Tue, Mar 16, 2010 at 7:05 PM, Christian Grün >> <christian.gruen(a)gmail.com> wrote: >>> >>> Dear Ganesh K, >>> >>> thanks for your update. I am sorry I can't give you more information >>> on MS SQL and PHP; it might help to look up the correspondent mailing >>> lists and forums. If you need some particular help on BaseX and its >>> APIs, we'll be glad to help out (note that we might extend our APIs if >>> more people need specific features). >>> >>> Christian >>> >>> >>> On Tue, Mar 16, 2010 at 5:29 AM, Ganesh K <ganeshk(a)21chms.com> wrote: >>> > Christian, >>> > I have tried thats how i check the php is working. >>> > Ok let me give my scenario. >>> > I got SQL Server (it might be Oracle also) since these both sucks when >>> > given xml search, thats the reason for switching for BaseX. >>> > Now i will coding in PHP which will connect to the DB >>> > (SQLServer/Oracle) and >>> > take the data and add some more xml information and pump in BaseX. Then >>> > have >>> > another PHP interface to search the nodes text or only text. >>> > I know this will not be your task but any help will help i am having >>> > trouble >>> > connecting to MSSSQLServer from Apache/PHP. >>> > Hope i was clear, if need any more information then let me know. >>> > Thanks >>> > Ganesh K >>> > >>> > On Tue, Mar 16, 2010 at 3:04 AM, Christian Grün >>> > <christian.gruen(a)gmail.com> >>> > wrote: >>> >> >>> >> Ganesh K, >>> >> >>> >> nice to hear that you successfully manage to use the PHP API. The >>> >> following example should tell you how to receive results: >>> >> >>> >> https://svn.uni-konstanz.de/dbis/basex/trunk/api/etc/php/Example.php >>> >> >>> >> If you need more help, please give us more details on your scenario. >>> >> Christian >>> >> >>> >> >>> >> On Mon, Mar 15, 2010 at 8:01 AM, Ganesh K <ganeshk(a)21chms.com> wrote: >>> >> > Dear Christian, >>> >> > Thanks for your reply, i could take some steps and proceed >>> >> > so >>> >> > finally i configured Apache and PHP and i am using that, i executed >>> >> > the >>> >> > php >>> >> > code also so the code is quite successful. But i need some help or >>> >> > guide >>> >> > on >>> >> > how to use the commands on PHP like how to get the results of the >>> >> > executed >>> >> > queries. if you could link to forum also will do .. >>> >> > >>> >> > Thanks >>> >> > Ganesh K >>> >>> ___________________________ >>> >>> Christian Gruen >>> Universitaet Konstanz >>> Department of Computer & Information Science >>> D-78457 Konstanz, Germany >>> Tel: +49 (0)7531/88-4449, Fax: +49 (0)7531/88-3577 >>> http://www.inf.uni-konstanz.de/~gruen >> > >

1 0

Set External Variable in BaseX API
by Adrien Guillon 15 Mar '10

15 Mar '10

I switched from XQJ to the BaseX API...however I do not see how to set an external variable in a query. Could you point me to the documentation on how to do this? Thanks!

2 1

Help Making Query More Efficient
by Adrien Guillon 15 Mar '10

15 Mar '10

I have what I would think is a relatively small database (~1MB) and I have full indexing turned on. I am writing a query to rank instructors based on various properties, which are determined from the database. The query is much slower than I would expect, and I'd like to ask for assistance in optimizing it. The full query is below... if you would like me to send you the XML input file I am working on I will do so. The query takes 13166ms on a high-end system. declare namespace db="http://cdf.utoronto.ca/2010/CSC301H1S/TeamYankee/TeacherSubstitution/Databa…"; declare variable $database_name as xs:string := 'substituter_db'; declare variable $course_code as xs:string := 'MAT244'; declare variable $section as xs:string := 'L0101'; declare variable $session as xs:string := 'S'; declare variable $date as xs:date := xs:date('2010-02-11'); declare variable $start as xs:time := xs:time('10:00:00'); declare variable $end as xs:time := xs:time('11:00:00'); (: --------- Declare Functions ------------- :) (: --- Compute weight based on same department --- :) declare function local:same_department_weight($instructor as element(db:instructor), $lecture as element(db:lecture)) as xs:int { let $department_id := basex:db($database_name)/db:database/db:courses/db:course_details[db:course_code eq $lecture/db:course/db:course_code]/db:department_id/text() let $weight := basex:db($database_name)/db:database/db:ranking_criteria/db:same_department/text() return if ($instructor/db:department_id eq $department_id) then xs:int($weight) else xs:int(0) }; (: --- Compute weight based on the fact they teach the same course --- :) declare function local:teaches_same_course_weight($instructor as element(db:instructor), $lecture as element(db:lecture)) as xs:int { let $weight := basex:db($database_name)/db:database/db:ranking_criteria/db:teaches_same_course/text() let $same_course := basex:db($database_name)/db:database/db:lecture_schedule/db:lecture [ db:course/db:course_code eq $lecture/db:course/db:course_code and db:instructor_id eq $instructor/db:instructor_id ] return if ( exists($same_course) ) then xs:int($weight) else xs:int(0) }; (: --- Compute weight based on the fact they have covered the course before --- :) (: --- Compute weight based on the fact they teach at the same level --- :) declare function local:teaches_at_same_level_weight($instructor as element(db:instructor), $lecture as element(db:lecture)) as xs:int { (: Courses taught by this instructor :) let $courses_taught := distinct-values ( basex:db($database_name)/db:database/db:lecture_schedule/db:lecture [ db:instructor_id eq $instructor/db:instructor_id ]/db:course/db:course_code/text() ) let $levels_taught := distinct-values( for $course_taught in $courses_taught return basex:db($database_name)/db:database/db:courses/db:course_details[db:course_code/text() eq $course_taught]/db:course_level/text() ) (: The level of the lecture the sub is for :) let $level_of_lecture := basex:db($database_name)/db:database/db:courses/db:course_details[db:course_code eq $lecture/db:course/db:course_code]/db:course_level/text() let $weight := basex:db($database_name)/db:database/db:ranking_criteria/db:teaches_at_same_level/text() return if ( exists(index-of($levels_taught, $level_of_lecture)) ) then xs:int($weight) else xs:int(0) }; (: --- Compute weight based on the total number of hours spent covering before --- :) (: --- Compute weight based on the fact this course is one they prefer to teach --- :) (: --- Compute weight based on the fact they teach in the same department --- :) (: Compute the rank of the instructor for this course :) declare function local:compute_rank($instructor as element(db:instructor), $lecture as element(db:lecture)) as xs:int { xs:int(local:same_department_weight($instructor, $lecture) + local:teaches_same_course_weight($instructor, $lecture) + local:teaches_at_same_level_weight($instructor, $lecture)) }; (: ------- Do actual Work --------- :) (: Get the lecture :) let $lecture := basex:db($database_name)/db:database/db:lecture_schedule/db:lecture [ db:course/db:course_code eq $course_code and db:course/db:section eq $section and db:course/db:session eq $session and xs:date(db:event_time/db:date) eq $date and xs:time(db:event_time/db:time/db:start) eq $start and xs:time(db:event_time/db:time/db:end) eq $end ] (: Iterate over all instructors and rank them :) let $instructors := basex:db($database_name)/db:database/db:instructors/db:instructor let $ranked_instructors := for $instructor in $instructors return <db:ranked_instructor> {$instructor} <db:rank>{local:compute_rank($instructor, $lecture)}</db:rank> </db:ranked_instructor> for $ranked_instructor in $ranked_instructors order by xs:int($ranked_instructor/db:rank) descending return $ranked_instructor

2 2

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk March 2010