Skip to Main Content

How to change parsing schema for REST

MJaroMar 19 2013 — edited Mar 20 2013
Hi all,

I'm trying to test the new REST Webservice feature, but this leads to an error:

Using Apex 4.2.1.00.08, Listener 2.0.1.64.14.25 I set up a simple WebService (method: GET, format: JSON) which
querys a table.
When I try to test my webservice (using "Test" button) the following error is shown:

Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
Applied database connection info
Attempting to process with PL/SQL Gateway
Not processed as PL/SQL Gateway request
Attempting to process as a RESTful Service
Determining if request can be dispatched as a Tenanted RESTful Service
Request path has one path segment, continuing processing
No Tenant Principal established yet, continuing processing
APEX_LISTENER pool exists, continuing processing
Matching tenant exists, continuing processing
modul/template/ matches: modul/template/ score: 0
Choosing: oracle.dbtools.rt.resource.templates.jdbc.JDBCResourceTemplateDispatcher as current candidate with score: Score [handle=JDBCURITemplate [scopeId=null, templateId=1019223475312614|5204902308237886, uriTemplate=modul/template/], score=0, scope=SecurityConfig [constraint=none, realm=NONE, logonConfig=LogonConfig [logonForm=null, logonFailed=null]], originsAllowed=[], corsEnabled=true]
Determining if request can be dispatched as a Tenanted RESTful Service
Request path has one path segment, continuing processing
Tenant Principal already established, cannot dispatch
Chose oracle.dbtools.rt.resource.templates.jdbc.JDBCResourceTemplateDispatcher as the final candidate with score: Score [handle=JDBCURITemplate [scopeId=null, templateId=1019223475312614|5204902308237886, uriTemplate=modul/template/], score=0, scope=SecurityConfig [constraint=none, realm=NONE, logonConfig=LogonConfig [logonForm=null, logonFailed=null]], originsAllowed=[], corsEnabled=true] for: GET modul/template/
Choosing: oracle.dbtools.rt.jdbc.entity.JDBCTenantDispatcher as current candidate with score: Score [handle=oracle.dbtools.rt.jdbc.entity.JDBCTenantDispatcher$TenantTarget@1537060, score=1, scope=SecurityConfig [constraint=none, realm=NONE, logonConfig=LogonConfig [logonForm=null, logonFailed=null]], originsAllowed=[], corsEnabled=true]
Chose oracle.dbtools.rt.jdbc.entity.JDBCTenantDispatcher as the final candidate with score: Score [handle=oracle.dbtools.rt.jdbc.entity.JDBCTenantDispatcher$TenantTarget@1537060, score=1, scope=SecurityConfig [constraint=none, realm=NONE, logonConfig=LogonConfig [logonForm=null, logonFailed=null]], originsAllowed=[], corsEnabled=true] for: GET prx/modul/template/
prx/modul/template/ is a public resource
modul/template/ is a public resource
Using generator: oracle.dbtools.rt.json.query.JSONQueryGenerator
Performing JDBC request as: POFFICE
Error during evaluation of resource template: ORA-00942: Tabelle oder View nicht vorhanden



I see what is going wrong: "Performing JDBC request as: POFFICE". JDBC is using a wrong schema ("POFFICE").
So, my question is, how to change the parsing schema for JDBC/WebService?

Thanks a lot,

Michael
Comments
Post Details
Added on Mar 19 2013
4 comments
1,226 views