detail.php
OW2 Forge: Detail: 303806 Xquery fails when having only Oracle SYNONYMS

Advanced - Powered by Google


   
Log In
New Account
  
 
Home
My Page
Project Tree
Project Openings
XQuare
          
 
 
Summary
Forums
Tracker
Lists
Tasks
Docs
News
CVS
Files
SVN
                    
 

Tracker: Bugs

Submit New | Browse | Admin | ExportToXml

[ #303806 ] Xquery fails when having only Oracle SYNONYMS

Date:
2005-07-26 09:29
Priority:
8
Submitted By:
x (guy)
Assigned To:
Nobody (None)
Category:
bridge
State:
Open
Summary:
Xquery fails when having only Oracle SYNONYMS

Detailed description:
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)

Add A Comment:

Please login

Followup

Message
Date: 2005-07-26 11:22
Sender: srouges
Logged In: YES 
user_id=740

Hi again,

Same remark as for the "update bug". Until you are
sure this
is a bug, please use the help forum. If you this is not one
but you consider the software should be improved, there is a
"feature request" tracker.

I'm not sure but, unless you specify it in the the JDBC URI
or configuration file (see the API and XQuery guides), the
user's default schema is used to find the tables or
synonims. Check this is correct with you "normal"
user.

Bye,

Stephane

Attached Files:

Name Description Download
No Files Currently Attached

Changes:

Field Old Value Date By
resolution_idNone2005-07-26 11:22srouges
priority52005-07-26 09:29guy

Copyright © 1999-2008, OW2 Consortium | contact | You have a difficulty, a problem ? Please report an issue using your OW2 forge account credentials