We are accessing the Berkeley DB through the Java API deployed in a
tomcat container.
I ran a xquery (deployed in tomcat) on Windows XP which threw the
exception:
com.sleepycat.dbxml.XmlException: Error: SequenceType matching failed:
the sequence contains more than one item [err:XPTY0004],
file:///<--->:116:18,
errcode = XPATH_EVALUATION_ERROR
at com.sleepycat.dbxml.dbxml_javaJNI.XmlResults_hasNext(Native
Method)
at com.sleepycat.dbxml.XmlResults.hasNext(XmlResults.java:45)
There was a problem in the xquery, where I was trying to do an "order
by" on an attribute that had multiple values.
However this query in Berkeley DB (2.3.10) on CentOS Linux (Linux
2.6.9-42.0.3.ELsmp #1 SMP Fri Oct 6 06:28:26 CDT 2006 x86_64 x86_64
x86_64 GNU/Linux) crashed the container!!
I do not quite understand as to why an xquery would bring down the
container. I removed the "order by" clause from the xquery and
everything work fine.
Any help on debugging such issues is really appreciated.
Thanks,
Suresh