APEX Listener vs OHS/mod_plsql - ORDS, SODA & JSON in the Database

Do we have any comparison info re APEX listener vs OHS/mod_plsql?
Can APEX Listener compete with OHS/mod_sql in terms of scalability, performance & HA? 

I'm surprised no one has responded to this post, as it is a good question. I'd like to expand this question further to ask:
For what tasking is Oracle targetting this listener - development? packaged demos? single platform environments? laptops? Or is this a 'serious' production-ready listener that Oracle will push/recommend to be utilized in place of OHS going forward? 

Very good question.
Does Apex Listener not generate more overhead than OHS/mod_plsql? 

I'm interested in this as well. Is their a white paper on this etc?
Martin
-----
http://www.talkapex.com 

Hi,
I havenot seen any WP on this so far, I have been lookin for it too.
However it looks like the end of mod_plsql is nearing, if one tries to extrapolate from the trend. If you take a look at the Oracle EBS R12 stack the OHS+mod_plsql has been replaced by OHS+OAF+OC4J. In forms 11g Oracle AS has given way to WSL and forms listener.
In a nutshell , there appears to be a move away from the OHS mods_plsql stack in general. And apex listener is another step in that direction too.
So though in the short run OHS mod_plsql is the more mature middle tier , the future appears to be WLS/Glassfish/OC4J + listeners.
Regards, 

I start reading about Listener and this work over OC4J layer, also can use the AJP13 and AJP14 connector with apache (and use the compression_).
I am too new with apex, but for me is more natural work with apache + J2EE (Tomcat or other Java engine). That is a new alternative to work with APEX and maybe that is because some problems happen with OHS, so far I don't have so many time with OHS and APEX to give a better answer. 

If you'll search this forum for "mod_plsql", you'll find some pertinent posts, including this one:
Re: APEX Listener as a replacement for modplsql ?

Related

Apex Listener and Native Database Web Services

I'm interested in understanding if the Apex Listener can be used to serve up Oracle native database web services. At http://www.oracle.com/technology/products/database/application_express/apex_listener/apex_listener.html it states that the Apex listener "Can be used for Application Express or any Oracle web-toolkit application". I'm not sure what constitutes as an Oracle web-toolkit application exactly. Just OWA?
Anyone know if the Apex Listener can provide an access point to native database web services?
Thanks,
Jason 
Yes this means it should work for other owa based things. We're working on more/better/funner ? things but that's still being worked on.
-kris 
"Yes this means it should work for other owa based things."
Does that include native database web services? If so, is there any material that may help understand how it can be configured to serve up the native database web services?
Thanks,
Jason 
Native Web Services are not OWA based.
-kris 
jlincoln wrote:
I'm interested in understanding if the Apex Listener can be used to serve up Oracle native database web services. Jason,
You might want to check out the Thoth Gateway (for Microsoft IIS), which can expose any PL/SQL function (or functions in a package) as a SOAP web service:
http://code.google.com/p/thoth-gateway/
More details here:
http://ora-00001.blogspot.com/2009/11/publish-plsql-as-soap-web-service.html
And Kris: Perhaps the Apex Listener can be extended with similar functionality sometime in the future? Consider this an enhancement request... :-)
- Morten
http://ora-00001.blogspot.com 
It's well underway :)
-kris 
To be clear on this, there are a lot of OWA based features which won't work
1. Flexible parameter passing
2. Basic authentication
3. Custom CGI environment passing
It would be useful if the APEX listener team could provide a statement of direction which covers whether they are ever going to implement these features and a roadmap to when they might be expected. Otherwise it leaves standard mod_plsql customers in limbo, as they don't know whether to go with
1. dbms_epg
2. OHS2
3. Apex Listener
Hopefully this is something you guys are working on, as it would make the APEX listener a real replacement for mod_plsql, which given the complexity of OHS in 11gR2 would be a bonus!

Apex Listener vs. Oracle Application Server... advantages?

Are there advantages to installing Apex Listener over using an existing Oracle Application Server instance to serve Apex applications?
We have an existing application server instance in production. Would introducing Apex Listener and the extra overhead be of any advantage?
Thanks in advance for your thoughts. 
Hello "Portal Dude",
Are there advantages to installing Apex Listener over using an existing Oracle Application Server instance to serve Apex applications?APEX Listener introduces some additional features, such as Resource Templates, but lacks some others. Some people might want to migrate from OAS to another JEE Container that doesn't come along with a OHS/mod_plsql. Depending on the JEE Container, you could use AJP for load balancing, avoiding plain HTTP through a firewall, etc.
Would introducing Apex Listener and the extra overhead be of any advantage?The "extra overhead" may be smaller than you think. If you don't need the HTTP_Server component any longer, but can just deploy APEX Listener on the OC4J of your OAS, you might even save some bytes.
For several other aspects, there have been a few posts on that topic in the past:
{thread:id=1100122}
{thread:id=1555908}
{thread:id=1594158}
If there's anything you don't find in either the posts or the documentation, don't hesitate to ask.
-Udo 
-Udo, thanks so much for your response.
We use Oracle Portal extensively to server our web sites and applications. We will need to keep this application server for Portal and some OC4J stuff, so it would seem that we would want to use it for Apex rather than the introducing the Apex Listener?
Your thoughts are appreciated.
~Chris 
Chris,
We will need to keep this application server for Portal and some OC4J stuff, so it would seem that we would want to use it for Apex rather than the introducing the Apex Listener?Well, if you don't need any of the new features there is need to migrate to APEX Listener at the moment. Everything will continue to work as it did with all currently available APEX releases with Oracle HTTP Server using mod_plsql, and there hasn't been any announcement that this is supposed to change.
-Udo
P.S.: If your question is answered, please mark this thread accordingly and any helpful or correct answer to help other users to spot relevant posts. 
Thanks again Udo....

Oracle Application Express Listener benefits

Hi everyone,
We're trying to install APEX 4.1.
Oracle Application Express Listener is it good for debugging ?
Can I have more details about the listener ?
Is it very helpful, is it a must ?
Thanks. Bye. 
Hi,
We're trying to install APEX 4.1.Go for it! ;)
Oracle Application Express Listener is it good for debugging ?What do you want to debug? You can certainly do all common APEX debugging with it.
Can I have more details about the listener ?Sure. Have you scanned the [url http://www.oracle.com/technetwork/developer-tools/apex-listener/overview/index.html]Product Overview yet? And unlike other products, the [url http://download.oracle.com/otn/java/appexpress/1.1/docs/AELIG/E21058_01.pdf]Installation and Development Guide is pretty compact, so you could take a look there as well. Especially the Preface and the chapter about Resource Templates should catch your eyes...
Is it very helpful, is it a must ?It is helpful if need a fast solution to access APEX and you either don't use another web server (e.g. OHS or EPG via XDB HTTP Server) yet, or you have some JEE Container and want to consolidate your architecture (i.e., shutdown OHS or EPG), or you just want it for curiosity. It's not a must, you can still use the "old" web server options to host your APEX if you don't need any of the new features offered by the APEX Listener.
-Udo

Best way to deploy APEX for a customer

I have a customer who has Oracle 11GR2 Standard Edition for Windows in production and I am teaching them how to use develop using APEX, but I don't quite understand how to deploy it. The Apex Listener documentation talks about OracleGlass, WLS, and OC4J, but those are all products that my client is not licensed for. There is a way to deploy the Apex Listener standalone but several threads say that should not be used for production, and I don't see a way to automate the restart of the standalone listener on Windows after a reboot; it's not a service. I read a somewhat relevant thread with comments from UDO and Kris Rice but I doesn't seem to clarify.
Is there a production-quality way to deploy the Apex Listener without having to pay for GlassFish/WLS etc... licenses?
Here's the thread with comments from Udo and Kris, but I don't think it answers the question, or I don't understand the answer:
Re: License/Cost for APEX Listener 
Hi Ron,
you can deploy APEX Listener in the so called Standalone Mode and have it licensed (and supported) with your customers 11.2 SE. As you've already mentioned, the embedded container doesn't have features like running as a service. You could add that kind of functionality with service wrappers such as nssm or srvany, as described here: {message:id=9606494}, but this scenario won't be supported by Oracle as the service wrapper is not part of their product.
If you (or effectively your customer) don't need (want to pay) support for Oracle, you don't necessarily need one of the named licensed JEE containers. You could use GlassFish Open Source Edition (which works pretty similar to the supported and documented one from the APEX Listener point of view), or even Tomcat (which has been supported by Kris during EA phase but had to be dropped officially, probably because Oracle can/will only support their own products - which I think is understandable).
I hope I could answer your license-deployment-question. If I didn't hit your point, please let me know what I need to explain better.
-Udo 
Thanks! Just wanted to be sure I was looking at this correctly.

Listener Benefits?

Hi
I am wondering if someone can list benefits of moving my intranet based APEX/Oracle Http Webserver to Apex/Apex Listener..
Is it faster?
If I spend $$ getting it switched over.. will it payback ?
Thanks
Dean 
Hi Dean,
http://www.oracle.com/technetwork/developer-tools/apex-listener/overview/index.html says:
<b>Why use the APEX Listener</b><ul> <li>Allows easy integration with Java-based middleware</li> <li>Can be used for Application Express or any Oracle web-toolkit application</li> <li>Ease of configuration</li> <li>Lightweight</li> <li>When combined with Glassfish, just unzip and you are good to go</li> </ul></div>
>
More experiences shared on http://dgielis.blogspot.in/2012/08/moving-to-oracle-apex-listener.html.
In a nutshell, Apexlistener does all that OHS does and some more.
a. Multiple DB support in ApexListener 2 is really interesting
b. ApexListener is under active development, which cannot be said of OHS.
c. Developed and deployed in Java, OHS MOD_PLSQL is C from what I remember.
d. ApexListener is free . Though you may incur licensing cost for the J2EE container if you decide to use one of the supported ones and do not have have one of them already deployed.
Do not expect any great performance improvement etc. but a better stack in the long run, IMHO.
Cheers, 
Hello Dean,
in addition to the ressources Prabodh referenced, there have been other threads on that issue, e.g. {message:id=9882947}.
I consider the fact that APEX Listener is the future web server for APEX the most important aspect. If you have your OHS environment stable and you don't need what APEX Listener offers you, you might stay where you are. If RESTful webservices are of interest for you, or some other features that are announced (e.g. FOP-pased PDF export, direct XLS import, etc.), you change to APEX Listener at any time you can afford it.
I'm not sure if your environment is so complex that you acutally have to spend a lot of money to get the change. At least, as Prabodh also mentioned, APEX Listener is already licensed with your database, so it would just be the JEE container. To start to play, you could use the so called "Standalone Mode" where APEX Listener runs on the embedded JEE Container it is bundled with.
-Udo

Categories

Resources