[xquery-talk] Xquery seems to fail when querying on oracle SYNONYM.
guy Van Iseghem
gvaniseghem at yahoo.com
Tue Jul 26 01:45:08 PDT 2005
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/1b1d5c2b/attachment.htm
More information about the talk
mailing list