No, that is for webservice.
I eventually moved this to default.xml config file. It works. But logically I feel it should only be for certain users. Anyway for now can live with this option. Hope to find right solution in up coming release.
So, can you talk about what your actual problem is? Otherwise I know of no changes in these features for upcoming releases.
There as mod-pl sql application which need to migrate to ORDS.
Over there they use (in mod-pl-sql entry) plsqlbeforeprocedure. This we need to handle here in ORDS.
But preprocess only work when have it defined in default.xml.
Which means all other application affected. So I cannot use this in default.xml.
When use for specific user XML config, it is not invoked. i.e preprocess.
Crazy!!! Or is it possible ?? Or is it a bug?
So you need two ords, one for your old mod app, and one for your other REST bits.
It is quiet straight forward.
i AM HAVING THIS ENTRY IN <USERID>.XML
<entry key="procedure.preProcess">PROCEDURE NAME</entry>
But it is not working.
But there is this global config which is default.xml.
When I move this "preProcess" this is invoking that procedure as expected. But since it is global - there are other ORDS application which is also been forced to look for this procedure. That means all other ORDS application do no work. So no choice - cannot have this as global param.
Only required for that particular ONE application. That is the reason I want this "preProcess" to load for on that particualr <USERID>.xml. But then it is not working. Any chance this can be fixed to work only for particular user?
If you want me to explain further - can we have a webex session?
I'm being reminded what you're trying to do should work - if you config a pool xml to have this defined, it should be working.
if not, it's a bug - please contact My Oracle Support and open a SR
Any reason you can't simply use 2 ords setups?
$ cp ords.war legacy.war $ java -jar legacy.war configdir /tomcat/ apr. 05, 2019 3:05:49 PM INFO: Set config.dir to /tomcat/ in: /tomcat/setup_ords184/legacy.war $ mkdir /tomcat/legacy $ cp -r /tomcat/ords/* /tomcat/legacy/ $ vi /tomcat/legacy/defaults.xml #add the preprocess $ cp legacy.war /tomcat/tomcat8/webapps
after that your normal/new services work fine with /ords/* and your legacy will work on /legacy/*
There as mod-pl sql application which need to migrate.
Over there they use plsqlbeforeprocedure. This we need to handle here in it’s.
But preprocesseor only work when have it defined in default.xml
Which means all other application affected. So cannot use.
When use for specific user XML config, it is not invoked.
Crazy!!! Or is it possible ??
It's possible. It's supposed to work that way.
If it's not, share your config, code and/or open a SR with MOS
Trying this option.
Will update it is fully working soon.
As of now - setup done successfully and first round testing done.
ok good to hear,
I know it works for other stuff. (haven't been using preprocess). I use this for a few of our systems, where I need to use separate configs and I simply find the ords route configurations too complex compared to having multiple ords installations per a single Tomcat.
Yes, this solution is right choice - as of now - since preprocess only works in default.xml which is overall config for entire ords folder !
As Jeff told - not sure if this is a bug or they want to review.. I submitted this in oracle support - they never respond at all.
What's your Service Request number?
Not responding at all isn't acceptable.