OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » The embedded pl/sql gateway versus Apex listener deployed to Glassfish

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » The embedded pl/sql gateway versus Apex listener deployed to Glassfish (DB11.2.0.3, Apex 4.2.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

The embedded pl/sql gateway versus Apex listener deployed to Glassfish [message #580089]

Wed, 20 March 2013 04:58

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

The embedded gateway is really easy to set up. The Apex external listener, perhaps deployed to Glassfish, is more of a hassle. I'm not considering the Apache-plus-modplsql option at the moment, though Apache will be needed on the DMZ.
From the DBA's point of view, the embedded gateway does sometimes have performance issues, possibly due to the shared configuration. From the developer's point of view, is there any preference?

Thank you for any insight.

Report message to a moderator

Re: The embedded pl/sql gateway versus Apex listener deployed to Glassfish [message #580091 is a reply to message #580089]

Wed, 20 March 2013 05:46

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm most probably not the one who should be responsible for a decision you make (because there are just 2 Apex developers over here, with up to puny 10-20 concurrent users) so, as you guess, any option we choose doesn't make much difference.

Anyway: I've used embedded gateway previously (Apex 3.2 was my first version); now we're on Apache HTTP Server with mod_plsql (Apex 4.1 and 4.2).

I didn't notice any difference but, as I said, my experience is close to no experience.

Report message to a moderator

Re: The embedded pl/sql gateway versus Apex listener deployed to Glassfish [message #580127 is a reply to message #580091]

Wed, 20 March 2013 10:55

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Thanks for getting back to me, LF. I guess no-one has any strong opinions.

I'm having real problems with Apex listener 2.0.1 (released March 5, would you believe), just hit a bug that MOS says is fixed in 2.0.2. Problem is, 2.0.2 doesn't exist yet.

Report message to a moderator

Re: The embedded pl/sql gateway versus Apex listener deployed to Glassfish [message #580334 is a reply to message #580127]

Fri, 22 March 2013 17:11

krisrice
Messages: 1
Registered: March 2013

Junior Member

What's the issue you hit?

Report message to a moderator

Re: The embedded pl/sql gateway versus Apex listener deployed to Glassfish [message #580348 is a reply to message #580334]

Sat, 23 March 2013 03:59

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

Problem was bug number 16461737. Why do you ask?

Report message to a moderator

Re: The embedded pl/sql gateway versus Apex listener deployed to Glassfish [message #583339 is a reply to message #580348]

Mon, 29 April 2013 15:32

andrew again
Messages: 2577
Registered: March 2000

Senior Member

The most common comments on https://forums.oracle.com/forums/forum.jspa?forumID=137 , are that EGP is difficult to trace issues with as it's pretty much a black box, and not really suitable for "production" sites (because it's only designed to have basic functionality). I've been using EGP for years without issue.

Report message to a moderator

Previous Topic:	Invoking PL/SQL through the embedded gateway
Next Topic:	Insert into BLOB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 11:07:44 CST 2025