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

[Michael Kay]

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