I am using dbxml 2.5.13 on both Mac OS X and Solaris and having segmentation faults when executing an xquery that uses fn:doc-available within an xquery function used inside a where clause. I've tried restructuring the query to avoid using a nested function but the problem persists. Oddly, I wrote a ...
I'm running on Linux for zSeries.I created the database "sample":db2 "create database sample using CODESET UTF-8 TERRITORY US"and tried to run the db2sampl_XML.db2 script, and got:SQL16196N XML document contains an element "customerinfo" that is notcorrectly specified. Reason code = "37" SQLSTATE=22 ...
During our stress performance test of OSB 10.3g we experience that the JDBC Connection Pool can disable itself, if many statement executions ends in some kind of exceptions (like TimoutException). As i understand this "disabling" is normal behavior, and eventually it will enable itself again after s ...
I want to test OSB installation on RHEL 4. Can I test install it of a single serverwith no tape media (to be substituted by disk or dummy tape). I just want to testthe feel on how to install it. ...
I am trying to execute the below sample XQuery. Eclipse designer does not show any error. However on executing the XQuery, I get the following error "Error executing the XQuery transformation: line 7, column 2: {err}FORG0005: expected exactly one item, got 0 items". Appreciate your help. xquery vers ...
Hi, I'm trying to replace the body in the OSB with a xquery but its seems i have a typing issue somewhere.....or namespaces but I can't figure it out. The error I get is:OSB Replace action failed updating variable "body": Error parsing XML: {err}XP0006: "element {http://www.w3.org/200 ...
greetings,i was finallly able to install the OSB on my server but after i finished the installation ik couldn't get to the web tool of the OSB. i looked through the log file but it was showing an error regarding SSL, also if someone can actually tell me how to configure the enterprise manager for th ...
Can any body provide XQuery transformation between schema A and Schema B, I am getting issues while creating the transformation. Sample Scenario================Source Schema A contains schema for details Table.Target Schema B contains schema for Header and Details.As you can see Schema A doesnt cont ...
In the below XQ, I am trying to learn making calls to local functions. I have tweaked my earlier XQ, which had a local variable defined [in xf:getCost() function] as XPath to Quantity. Now, I have modified the XQ to make a call to xf:getQty() from xf:getCost(), to get the desired Quantity.On executi ...
Need help in transformation of the below input to a proxy service <soapenv:Body xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <InputParams> <queryParams> <quer:query-params xmlns:quer="http://www.example.org/QueryParams"> <param name=" ...
I'm building a OSB Service to interact with the Google Stock API and here's what I have:Oracle Service Bus 11.1.1.5. on WLS 10.3.5.Business Service that has the following configuration: Service Type: Messaging ServiceRequest Message Type: NoneResponse Message Type: TextProtocol: httpHTTP Request Met ...
Using an older version of DB2 9.5 (from 2007) without fix 1...Getting slow performance with xquery statements (xmlexists part the where clause). Have a generic table called Element with an XML column called CONFIGURATION. The total amount of data currently in the table is 40328 records. The Element ...
i am newbie to xquery. i am having this problem with my simple xquery. I am using eXist XML DB and using this query in PHP to retrieve result. this is my xml database file. <class><result><student>abc</student><grade>4</grade></result><result><stude ...
I'm very new to XQuery and need help.I have xml document eg<catalog><author><name> Tom Brown</name><book>example</book><book>example2</book></author> <author><name> John Smith</name><book>example3</book><book>e ...
I am trying to use heredoc to introduce XQuery strings (then to apply urlencode before submitting querystring as a SOAP parameter)Following the rules here ..http://www.php.net/manual/en/language.types.string.php#language.types.string.syntax.heredocI can get simple strings to go into heredoc ..but mo ...
Is it possible to create a UDF in java to perform a specific task, for example, modify a string and return that value to be used in an xquery.For example:[b]Urlify.java:[/b]codepublic static String urlifyString(String toUrlify) throws Exception{return urlify(toUrlify); //modifies a string, eg. remov ...
I am to make a php file that queries an xml file with the php class Xquery_lite.I've found much about xquery in general, but little together with php.I've downloaded the class and it works (xquery_lite) from:http://sourceforge.net/projects/phpxmlclasses/Instructions/API for the class:http://phpxmlcl ...
I want to test if the value of an xml node is numeric.When I execute the XQuery:XQUERYlet $n := 'test string'return xs:string(fn:number($n)) = 'NaN'It works well. But if I change it to:XQUERYlet $n := '12'return xs:string(fn:number($n)) = 'NaN'I get an error : QName=err:FORG0001. SQLSTATE=10608I am ...
I'm just trying to test my understanding here...I know that I can publish XML from relational (non-XML) data using SQL/XML (via XMLELEMENT, XMLAGG, etc). But can I do the same thing from with just pure XQuery? It seems to me that all of the XQuery functions require data of type XML to start with. Is ...
Is it possible to create a UDF in java to perform a specific task, for example, modify a string and return that value to be used in an xquery.For example:[b]Urlify.java:[/b]codepublic static String urlifyString(String toUrlify) throws Exception{return urlify(toUrlify); //modifies a string, eg. remov ...
I want to test if the value of an xml node is numeric.When I execute the XQuery:XQUERYlet $n := 'test string'return xs:string(fn:number($n)) = 'NaN'It works well. But if I change it to:XQUERYlet $n := '12'return xs:string(fn:number($n)) = 'NaN'I get an error : QName=err:FORG0001. SQLSTATE=10608I am ...
I'm a newbie to using XQuery and the XQuery Update Facility in DB2 v9.5, and need assistance in accomplishing one task. I have a two column table, CREATE TABLE TEST.REQ (REQUEST_ID BIGINT, REQUESTED_ELEMENTS XML);. I'm trying to use the XQuery Update Facility to update the value of the displayName n ...
I have been trying to get the explain plan to use and index but it won't.This sql uses the index:explain plan for select 1 from "Test547_TAB"where extractValue(OBJECT_VALUE,'/test/xxx') = '1234'But this doesn't:select 1 from "Test547_TAB",XMLTable('for $e in /test where $e/xxx = "1234" return $e'PAS ...
I am using XQuery in the following Oracle release .... Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionI need to produce an XML result from a relational query and have a namespace on the output. However, I am finding that the namespace attribute that I define at the "root" ends ...
Does Oracle's support for XQuery cater for searching across namespaces ?According to this link, XQuery allows this - but does Oracle ?"XQuery adds a third wildcard node test, *:local-name, which matches all names with the given local name and any namespace. "http://www.awprofessional.com/articles/ar ...
I found this problem when using native XQuery function or XQJ inside the Oracle JVM.The problem seem to affect only when using fn:collection function and an xpath string which declare an specific namespace.Here a simple test case:SELECT XMLQuery('declare namespace acl = "http://xmlns.oracle.com/xdb/ ...
Hi, I have noticed that some xquery expressions return unordered results with DBXML.If you want to try, I have put a simple PHP script with 2 queries here: http://nmg.upc.es/~enric/test.phpand an small xml file here: http://nmg.upc.es/~enric/test.xmlThe first query returns ordered results but the se ...
I have a file with xquery function declarations and I'm trying to use it. Below is the query:import module namespace ns = "my.com" at "file://absolute path/test.xqm";ns:test ( "00000000001" )Parser returns the error: External access not allowedWhere the problem is?Also, is it possible to save querie ...
How does XQuery determine in a value is null? I have the following test on a VARCHAR2(6 BYTE) field and no matter what I do it doesn't seem to work. I want the code to do something if the field is null. I've tried all the combinations of else if($c_cat eq " ") that I can think of. else if($c_cat eq ...
In XML DB developer guide, it says Oracle XDB has contains(), matches() etc functions to use with Xquery, but I couldn't make it work, e.g. SQL> create table TEST(recid varchar(10), xmlrec XMLTYPE);Table created.SQL> insert into TEST values('01','<row><c1>01test</c1></row ...
I have a rather large XQuery statement generating a report (four level of nested joins). On the lowest level, there is an if statement. When I try to use string-length in the test, I am getting an error:ORA-01704: string literal too longThe query works fine if I have a different test condition, and ...
EXTREMELY SLOW XQUERY PERFORMANCE AND SLOW DOCUMENT INSERTS. Resolution History 12-JUN-07 15:01:17 GMT### Complete Problem Description ###A test file is being used to do inserts into a schemaless XML DB. The file is inserted and then links are made to 4 different collection folders under /public. Th ...
I've been trying to get an XQuery to work against an XMLType view based on a registered schema that I created and haven't gotten it to work correctly. I wanted to find an example which doesn't use any oracle functions but haven't found one yet. Does anyone have an example of this? Seems like most of ...
I was wondering what is the correct classes to use when attempting to create a web service that will do an xquery against an XMLType view I created.I haven't been able to get code to work when using classes and query format like:/* XQuery code snippet 1 */Connection conn = DriverManager.getConnectio ...
i am newbie to xquery. i am having this problem with my simple xquery. I am using eXist XML DB and using this query in PHP to retrieve result. this is my xml database file. <class><result><student>abc</student><grade>4</grade></result><result><stude ...
I am currently learning XML and XQuery and i have to write an XQuery that returns data from an XML file based on several constraints. My problem is that i cant seem to get my data to return in a format that conforms to the XSD schema. The XML database is structured a bit like this:XML:<DB>< ...
I have to query one document with a lot of similar elements.Elements can have relationships among each other defined by a link between "id" and "href" attributes.<ele1 id="0815"><ele2><ele3 href="1234" /></ele2><name><string>a name</string></name></ ...
I used the following code to test the XQuery Update public static void testInsert(XmlManager xmlManager) { XmlQueryExpression expr = null; XmlTransaction txn = null; try { TransactionConfig tc = new TransactionConfig(); tc.setSnapshot(true); txn = xmlManager.createTransaction(null, tc); XmlQueryCont ...
I used document below:<root>...<name>some text</name>...</root>The scenario is as below:3467 documents in the containerSelect the document whoes name node's content equals to some text. Use two ways, one is XQuery, and the other is use XmlIndexLookup directly. The XQuery I us ...
I have the simplest xquery on the containerdeclare variable $id external;declare variable $container external;collection($container)//*[@id = $id]yet printing the query plan from Java and printing the query plan from the command shell I see that Java is not using the index. The Java query plan says ...
I am implementing xquery (well XQJ) with berkeley database and am testing my queries with the command prompt. In particular;openContainer test.dbxmlsetVariable doc <test>test</test>query 'declare variable $doc external; fn:put(xqilla:parse-xml($doc), "test.xml")'the xquery expression abo ...
I'm very new to XQuery and need help.I have xml document eg<catalog><author><name> Tom Brown</name><book>example</book><book>example2</book></author> <author><name> John Smith</name><book>example3</book><book>e ...
I'm using Oracle Berkeley DB XML 2.4.13 and PHP 5.2.6 on Debian GNU/Linux. I have quite a long XQuery function which I would like to place in separate file. The function returns elementswhich have value in certain attribute. It works well when declared in the query in the same file, butseems to lose ...
how to mount drive or library on OSB 10.2.0.3.0. My Tape library is DELL TL-2000 with windows 2003 (but the windows identify it as IBM TotalStorage 3575 library and IBM ULT3580-TD3 drive).The Library and drive are detected by windows and no red or yellow mark on the device manager.I try to read the ...
I have installed Oracle 10.2 and OSB on a Windows 2003 (R2) test machine. I have OSB working and can backup using the RMAN command line to submit backups to tape and it all works fine. However I am unable to run it from EM using the "Oracle Secure Backup Device and Media" link. When I selected this ...
I think I'm on a bit of a long shot with this one unfortunately, but I am trying to implement an OSB solution on a production HACMP cluster. The configuration would look as follows:OSB Admin & Media Host : Windows 2003 x86 (Host: FPTXOSB01)OSB Clients : Server 'pserver1' is node 1 in an HACMP cl ...
I just recently upgraded from Oracle 10g R1 to R2 (10.2.0.4) on AIX 5L. Has anyone already installed and configured OSB Express 10.2 in AIX 5L (64-bit)? I just installed OSB 10.2 in AIX 5L (5.3) and configured it based from the 10.2 OSB install guide. However, the sbt library found in my OSB home is ...
I have some xml documents as the following: <?xml version="1.0" encoding="UTF-8"?><sm:be-canali xmlns:sm="http://www.oracle.com/serviceManager/output"><sm:evento-ordine><sm:evento><sm:cod-evento>003</sm:cod-evento><sm:ts-evento>2005-08-08 15:40:20.679</sm ...
I have two documents (sample.xml and test.xml) in a example.dbxml. I use the following conditional Xquery : query 'for $p in collection("exampleData.dbxml") where $p/Bookstore/Book/book_id eq 1 return for $y in collection("exampleData.dbxml")/sampleDocument return insert nodes <b4>inserted chi ...
I have the following XML file: <Fuzzy> <Rule> <rule_ID>1</rule_ID> <event>insert</event> <happen>after</happen> <condaction>collection('test.dbxml')/Bookstore/Book</condaction> </Rule> </Fuzzy> I use the following code to execut ...