tag:blogger.com,1999:blog-21122514.post6781242436943628715..comments2024-03-23T11:05:13.046+01:00Comments on Dimitri Gielis Blog (Oracle Application Express - APEX): Moving to the Oracle APEX ListenerDimitri Gielishttp://www.blogger.com/profile/16295721159626839167noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-21122514.post-4143445660230197922013-04-24T11:02:18.966+02:002013-04-24T11:02:18.966+02:00Hello Brian,
You can add your own custom headers...Hello Brian, <br /><br />You can add your own custom headers extending HttpServletRequest. Use this class in a filter and add it to the apex.war. <br /><br />Hope it helps, <br /><br />LuisLuishttps://www.blogger.com/profile/10423029085521344774noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-44118257319651281892013-04-22T15:56:09.648+02:002013-04-22T15:56:09.648+02:00Hello Dimitri,
Nice post and nice presentation t...Hello Dimitri, <br /><br />Nice post and nice presentation too (http://2012.ukoug.org/default.asp?p=9339&dlgact=shwprs&prs_prsid=7046&day_dayid=62), thanks!<br /><br />I am trying to configure the PL/SQL validation, like: http://krisrice.blogspot.com.ar/2013/01/apex-listener-plsql-validations.html but my function is never executed!!!<br /><br />Any advice on this?<br /><br />Thanks in advance, <br /><br />LuisLuishttps://www.blogger.com/profile/10423029085521344774noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-48566047247670261332013-03-14T18:34:26.028+01:002013-03-14T18:34:26.028+01:00Does APEX Listener support passing CGI variables f...Does APEX Listener support passing CGI variables from Apache to the PL/SQL environment like mod_plsql did using the <b>PlsqlCGIEnvironmentList</b> parameter in the <b>dads.conf</b> file?Briannoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-70322282456801719652013-02-03T16:28:29.089+01:002013-02-03T16:28:29.089+01:00I'm not the right person to compare Glassfish ...I'm not the right person to compare Glassfish vs Oracle Weblogic as I only used Glassfish so far.<br /><br />For your points:<br />-) Cost; Glassfish has a community edition which is free. So hard to beat if you don't care about official Oracle support.<br />-) Deployment of an APEX application is identical, as your APEX app is basically metadata in the database.<br />Adding files on the webserver is kinda the same on both environment.<br />-) Efficiency is hard... I don't like to say this is more efficient than that, I think it depends your use case, application, load etc. So I always recommend to do test cases and some load testing (with JMeter for ex.).<br />Most efficiency in APEX applications is not on the webserver, but in the database though. <br /><br />Hope that helps,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-48217107878464192112012-12-22T01:47:26.303+01:002012-12-22T01:47:26.303+01:00Which one is better option and why?
1) Apex Listen...Which one is better option and why?<br />1) Apex Listener + Glassfish<br />2) Apex Listener + Oracle web logic server<br />Point to compare<br />Cost<br />Deployment <br />efficiencyAnonymoushttps://www.blogger.com/profile/10103479484148224573noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-739174315441084512012-08-21T08:30:03.292+02:002012-08-21T08:30:03.292+02:00Hi JP,
If you do your configuration like this:
DB...Hi JP,<br /><br />If you do your configuration like this:<br />DB -> Glassfish + APEX Listener -> Apache Reverse Proxy (+ mod_ntlm)<br /><br />You can still use your current single sign on configuration. Concerning the DAD's in the APEX Listener; in 2.0 you configure the connection to the database. New in 2.0 is that you can configure multiple connections. With SQL Developer 3.2 you will find it a bit easier than doing everything command line.<br /><br />Hope that helps,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-17299699528357239432012-08-20T20:28:28.747+02:002012-08-20T20:28:28.747+02:00Hi, Dimitri -
Thanks for your analysis. For year...Hi, Dimitri -<br /><br />Thanks for your analysis. For years we've been running our Apex and htp.p generated web applications using mod_plsql on a 32-bit 10gR2 database and the OHS that accompanied it. We used mod_ntlm as our single-sign-on solution.<br /><br />I've been trying to experiment with 64-bit 11gR2 and Apex 4.1 running against Apex 2 running on Glassfish 3. I've been unsuccessful at finding a replacement for mod_ntlm for our single-sign-on solution. Also, I understand that there are no Data Access Descriptors used with Apex Lister. But I haven't found any examples of how to set up the Apex Listener in a way that our applications can be configured to run against their respective parsing database schemas. In other words, how do you replace the DAD functionality in Apex Listener? We'd be grateful for any advice or reference sources that you can point us toward. Thanks!Anonymoushttps://www.blogger.com/profile/01787459164433031824noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-34537637484821460462012-08-09T15:31:20.880+02:002012-08-09T15:31:20.880+02:00Hi Buzz,
I don't really see it as Apache vs A...Hi Buzz,<br /><br />I don't really see it as Apache vs APEX Listener, but more mod_plsql vs APEX Listener.<br /><br />The APEX Listener works on Glassfish and Weblogic so if you find a plugin for Glassfish and Weblogic you are ok or you can do it like us with an Apache Reverse Proxy in front of the APEX Listener (running on top of Glassfish).<br /><br />Hope that helps,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-31732710394800793782012-08-09T15:27:47.677+02:002012-08-09T15:27:47.677+02:00What about NTLM? Right now mod_ntlm works on Apac...What about NTLM? Right now mod_ntlm works on Apache. I haven't seen a great solution for Apex Listener yet - what do you suggest for people who need Single Sign On but want to move to the listener?Buzz Killingtonnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-70229933888610925772012-08-09T12:23:14.848+02:002012-08-09T12:23:14.848+02:00Fateh.cis; to route your domain to different apps ...Fateh.cis; to route your domain to different apps you have a couple of choices:<br />- the APEX Listener 1.x doesn't support multiple routings yet, but<br />- you can do it with a plugin in Glassfish<br />- or we use an Apache Reverse Proxy in front of our Glassfish so we can create Virtual hosts and redirects <br />- With the APEX Listener 2.x it will be possible to route the different domains to different APEX apps, so you don't need a plugin for Glassfish or the Apache Reverse ProxyDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-79321331966628838932012-08-09T09:53:34.222+02:002012-08-09T09:53:34.222+02:00Interesting post, Dimitri. We are currently migrat...Interesting post, Dimitri. We are currently migrating from APEX 4.1 with OHS to APEX 4.1 with GlassFish 3.1.2 and the APEX Listener. We had some problems where the APEX Listener would cause a hang when the caching folder was removed, I blogged about it here: http://matthiashoys.wordpress.com/2012/08/07/removal-of-apex-listener-cache-folder-causes-hanging-of-apex/<br /><br />Otherwise, very happy about the performance, but I must add that GlassFish in combination with APEX Listener uses more memory than OHS with mod_plsql, especially if you are using a separate GlassFish server instance for your APEX deployment (which I would recommend).Matthias Hoyshttp://matthiashoys.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-33156087799430225452012-08-09T09:45:05.508+02:002012-08-09T09:45:05.508+02:00Hello,
Thanks Dimitri,
If we deploy the listener o...Hello,<br />Thanks Dimitri,<br />If we deploy the listener on Glassfish server.<br />Then how can we map different internet domain names to different APEX Apps ???<br />I tried to create virtual servers but to no avail.<br /><br />Best Regards,<br />Fatehfateh.cishttps://www.blogger.com/profile/03869527468808610354noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-68126906789457721512012-08-09T04:24:57.498+02:002012-08-09T04:24:57.498+02:00Noons, sure happy to do a webcast, we just need to...Noons, sure happy to do a webcast, we just need to see at timing...<br /><br />Belinda, APEX 4.2 EA is using the listener, apex.oracle.com I don't know, but when 4.2 is installed there, it will for sure.Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-86642492429522606442012-08-09T03:22:33.167+02:002012-08-09T03:22:33.167+02:00Will apex.oracle.com be using the Apex Listener in...Will apex.oracle.com be using the Apex Listener in the near future?JellIThttps://www.blogger.com/profile/11786736501836082322noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-82993033624128103152012-08-09T03:18:55.969+02:002012-08-09T03:18:55.969+02:00Are there any plans for apex.oracle.com to use the...Are there any plans for apex.oracle.com to use the Apex Listener in the near future?JellIThttps://www.blogger.com/profile/11786736501836082322noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-58058255459904174872012-08-09T02:16:26.415+02:002012-08-09T02:16:26.415+02:00WOW! How timely is this! Thanks Dimitri, much appr...WOW! How timely is this! Thanks Dimitri, much appreciated! <br /><br />We're about to chose an alternative to mod-plsql in Apache due to the difficulty in getting it after 10gr2. <br />The Apex Listener was one of the options considered recently but we knew of no one using it. <br />Now I do!<br />Is there any chance of getting hold of your presentation or better yet, having you do a webcast presentation for our SydneyOracle Meetup user group? <br />I'd love the opportunity to present this to them!Noonshttps://www.blogger.com/profile/04285930853937157148noreply@blogger.com