[xquery-talk] Xquery seems to fail when querying on oracle
SYNONYM.

This looks like a product-specific question. At the very least you need to
tell us which XQuery implementation you are using. Probably you should
direct the enquiry to a product-specific mailing list.
Michael Kay
http://www.saxonica.com/
_____
From: talk-bounces at xquery.com [mailto:talk-bounces at xquery.com] On Behalf Of
guy Van Iseghem
Sent: 26 July 2005 08:45
To: talk at xquery.com
Subject: [xquery-talk] Xquery seems to fail when querying on oracle SYNONYM.
All,
Xquery seems to fail when querying on oracle SYNONYM.
My development database model consist of 2 users.
An administator user which has created the ROUTING_PARAMETERS table with an
identical SYNONYM. And a normal user which only have rights to query on this
SYNONYM. When executing the xquery below with the administrator everything
works fine although if I execute this using the normal user I receive the
exception below. I have tested in sqlplus and the normal user can query on
this view.
Any help will be appreciated.
Guy
for $rp in collection("ROUTING_PARAMETERS")/ROUTING_PARAMETERS
return
<ROUTING_PARAMETERS>
{ $rp/KEY }
{ $rp/VALUE }
{ $rp/TYPE }
</ROUTING_PARAMETERS>
org.xquark.xml.xdbc.XMLDBCException: Could not find path : collection
("*:ROUTING_PARAMETERS")/child::ROUTING_PARAMETERS - encountered at line 1 ,
column 45
at org.xquark.extractor.runtime.QueryFactory.parseXQuery
(QueryFactory.java:342)
at org.xquark.extractor.runtime.QueryFactory.createCompiledQuery
(QueryFactory.java:87)
at org.xquark.extractor.runtime.ExtractorStatement.executeXQuery
(ExtractorStatement.java:176)
at org.xquark.extractor.runtime.ExtractorStatement.execute
(ExtractorStatement.java:100)
at org.xquark.extractor.runtime.ExtractorStatement.executeQuery
(ExtractorStatement.java:109)
at org.xquark.servlet.bridge.XQBridgeServlet.execQuery
(XQBridgeServlet.java:159)
at org.xquark.servlet.bridge.XQBridgeServlet.doGet
(XQBridgeServlet.java:61)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run
(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet
(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet
(ServletStubImpl.java:315)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run
(WebAppServletContext.java:6718)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs
(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs
(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet
(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execute
(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://xquery.com/pipermail/talk/attachments/20050726/8148f066/attachment-0001.htm