Oracle Server - mod_plsql x apache x websphere

Author

mod_plsql x apache x websphere

mRangel

2005-11-22, 9:23 am

Dear friends,

First of all, allow me to say that browsing through this forum is a
great learning experience, thank you all. Now to the question: :-)

We have some PSP pages within our application, which we run using OAS
in some places and using the apache that comes with Oracle DB 9i in
other places. A new customer has a policy that says that their
application server has to be IBM's websphere. Does anybody knows if:

1. Is it possible to attach mod_plsql to a standard or non-oracle
Apache ? If so, what happens in terms of licensing ?

2. Is websphere based on apache ?

Thanks in advance.
Marcus Rangel

Frank van Bortel

2005-11-22, 8:23 pm

mRangel wrote:
> Dear friends,
>
> First of all, allow me to say that browsing through this forum is a
> great learning experience, thank you all. Now to the question: :-)
>
> We have some PSP pages within our application, which we run using OAS
> in some places and using the apache that comes with Oracle DB 9i in
> other places. A new customer has a policy that says that their
> application server has to be IBM's websphere. Does anybody knows if:
>
> 1. Is it possible to attach mod_plsql to a standard or non-oracle
> apache ? If so, what happens in terms of licensing ?
>
> 2. Is websphere based on apache ?
>
> Thanks in advance.
> Marcus Rangel
>
Dump that customer...

1: No - although you mention no versions, I once tried to use
the mod_plsql (version 3.0.8, iirc) with a standard Apache,
because I was fed up with the holes in the outdated 1.3.12
Oracle supplied... It's a no-go (basically because apache was
compiled with a newer, incompatible, release of a C compiler).

Later versions of mod_plsql have additional functionality, that
relies on the changed/added functionality of apache by Oracle.

So, I would not bet on it to work, ever.

I have seen some open source mod_plsql replacements, though.

2: No - or it would be called apache by IBM. :)

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

HansF

2005-11-22, 8:23 pm

Avoid the challenge - move up to 10gR2 and use DBMS_XDB and DBMS_EPG
which totally eliminates apache and mod_plsql whhile providing the same
capability.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting replies guarantees I won't respond. ***

Mark C. Stock

2005-11-22, 8:23 pm

"HansF" <News.Hans@telus.net> wrote in message
news:pan.2005.11.22.19.47.06.232279@telus.net...
> Avoid the challenge - move up to 10gR2 and use DBMS_XDB and DBMS_EPG
> which totally eliminates apache and mod_plsql whhile providing the same
> capability.
>
>
> --
> Hans Forbrich
> Canada-wide Oracle training and consulting
> mailto: Fuzzy.GreyBeard_at_gmail.com
> *** Top posting replies guarantees I won't respond. ***
>

yeah, but....

runs on same machine as RDBMS instance, right? that would seem to be a
limitation in some apps.

++ mcs

HansF

2005-11-22, 8:23 pm

On Tue, 22 Nov 2005 14:54:56 -0500, Mark C. Stock wrote:

>
> "HansF" <News.Hans@telus.net> wrote in message
> news:pan.2005.11.22.19.47.06.232279@telus.net...
>
> yeah, but....
>
> runs on same machine as RDBMS instance, right? that would seem to be a
> limitation in some apps.
>
> ++ mcs

1) It's closer - it runs IN the RDBMS instance.

2) Allows you to have a WebSphere in front of the database-specific
interaction, which seems to alleviate other limitations.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting replies guarantees I won't respond. ***

Bob Jones

2005-11-24, 3:23 am

> Dear friends,
>
> First of all, allow me to say that browsing through this forum is a
> great learning experience, thank you all. Now to the question: :-)
>
> We have some PSP pages within our application, which we run using OAS
> in some places and using the apache that comes with Oracle DB 9i in
> other places. A new customer has a policy that says that their
> application server has to be IBM's websphere. Does anybody knows if:
>
> 1. Is it possible to attach mod_plsql to a standard or non-oracle
> apache ? If so, what happens in terms of licensing ?
>
> 2. Is websphere based on apache ?
>
> Thanks in advance.
> Marcus Rangel
>

You can run all your PSP on Apache. WebSphere does not support PSP nor is it
based on Apache. It just uses apache as a front end.

Why would you want to use a proprietary language for web development anyway?
PHP and JSP are much more portable and powerful.

Sponsored Links