Using sample HR application, executing GET fails (http://app.limbo.lv/apex/dev/mflow/hr/employees/) generates debug output - see below.
Obviously MFLOW is correct user, I just do not know how to supply password. Anyone can help with some ideas ?
Interestingly enough at some moments it seems working, however mostly not. Probably depends on which exact session in pool gets reused, if session happens to have corect username it works, if not - fails. Just hypothesis. Anyway WHERE can I specify password for user which to access?
Sincerely
Maris
------------------------------------------------------------------------
Request Path passes syntax validation
Mapping request to database pool: PoolMap [_failed=false, _lastUpdate=1404580651471, _pattern=/dev/, _poolName=ora12-dev, _regex=null, _type=BASE_PATH, _workspaceIdentifier=null, _serviceName=null]
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
Dispatching as tenanted request, with base: http://app.limbo.lv/apex/dev/mflow/, target: hr/employees/, tenant: TenantPrincipal [name=MFLOW]
hr/employees/ matches: hr/employees/ score: 0
Choosing: oracle.dbtools.rt.resource.templates.jdbc.JDBCResourceTemplateDispatcher as current candidate with score: Score [handle=JDBCURITemplate [scopeId=null, templateId=16210102858825705|22222423285388094, uriTemplate=hr/employees/], score=0, scope=SecurityConfig [constraint=none, realm=NONE, logonConfig=NONE], 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=16210102858825705|22222423285388094, uriTemplate=hr/employees/], score=0, scope=SecurityConfig [constraint=none, realm=NONE, logonConfig=NONE], originsAllowed=[], corsEnabled=true] for: GET hr/employees/
Choosing: oracle.dbtools.rt.jdbc.entity.JDBCTenantDispatcher as current candidate with score: Score [handle=oracle.dbtools.rt.jdbc.entity.TenantDispatcherBase$TenantTarget@209d7383, score=1, scope=SecurityConfig [constraint=none, realm=NONE, logonConfig=NONE], originsAllowed=[], corsEnabled=true]
Chose oracle.dbtools.rt.jdbc.entity.JDBCTenantDispatcher as the final candidate with score: Score [handle=oracle.dbtools.rt.jdbc.entity.TenantDispatcherBase$TenantTarget@209d7383, score=1, scope=SecurityConfig [constraint=none, realm=NONE, logonConfig=NONE], originsAllowed=[], corsEnabled=true] for: GET mflow/hr/employees/
mflow/hr/employees/ is a public resource
hr/employees/ is a public resource
Using generator: oracle.dbtools.rt.json.query.JSONQueryGenerator
Performing JDBC request as: MFLOW
Error during evaluation of resource template: ORA-01017: invalid username/password; logon denied
WebException [statusCode=500, reasons=[Error during evaluation of resource template: GET hr/employees/, SQL Error Code: 1,017, SQL Error Message: ORA-01017: invalid username/password; logon denied
]]