Re: how to link Apache and Oracle?

On Fri, 20 Feb 2004 21:05:08 GMT, Hans Forbrich <hforbric_at_yahoo.net> wrote:

>nowayjose_at_telus.net wrote:
>> On Fri, 20 Feb 2004 20:15:20 GMT, Hans Forbrich <hforbric_at_yahoo.net>
>> wrote:
>>
>> No worries, Hans, I am not easily offended. You are right, I wasn't
>> telling all. Here is the whole deal. I know Oracle database, I have
>> been a DBA for over 8 years and I am four times Oracle certified. I
>> have a client that is asking me to build an application and it's
>> infrastructure. The infrastructure is easy, DB in the backend, all the
>> application logic in PL/SQL stored procedures, Apache on the web tier,
>> firewall between them. I am also Red Hat Certified Engineer, so all
>> the sysadmin and firewall tasks are second nature to me. My only
>> problem is that I need to link the web tier to the database. I know
>> enough Perl to write DBA and Unix admin scripts but my CGI skills are
>> 10 years out of date. I am not afraid to learn Perl methods for
>> connecting to Oracle db, but I was wondering if PHP was easier to use
>> and learn. The application must be secure, so I need to use SSL and
>> somehow preserve session info. Cockies?
>>
>> The application that I need to write is a very simple OLTP system, all
>> I need is to authenticate the users, let them enter the information in
>> several forms and log them out.
>>
>> Hope this time I am clear enough :)
>>
>> K.
>
>Much clearer. I notice you are also on telus.net (forbrich@ for me) -
>if near Edmonton we could discuss this over coffee/beer.
>
>Sad that you are stuck in the mid/back-tier split that way, and that you
>can not get Oracle AS (especially 10g). A lot of your requirements are
>already completed in the AS, although 9iAS is a pain to install.
>
>CGI is not the way to go. I recommend Perl for several reasons: it's
>included in the web-stuff that comes along wth Oracle which might make
>migration easier at a later date; DBI/DBD is included and that pretty
>well wraps up the connectivity issue; there are a pile of Perl-aware
>people, but in my experience a lot less PHP aware people.
>
>Personally I'd prefer PSP (PLSQL Server Pages).
>
>JSP (Java Server Pages, not Java Stored Procs) basically embedds Java
>snippets in an HTML template than uses some J2EE container, such as
>the OC4J that's part of Oracle, to translate the page into Java servlets
>on first access.
>
>Ultimately the app you will be writing could probably be handled by
>Oracle's HTMLDB capability and that is included as part of the database.
> Suggest you look at http://marvel.oracle.com when you have a chance.
>
>/Hans
>forbrich at telusplanet dot net

I'm in Vancouver... after all this trouble it seems that instead of doing this project I will be supporting Oracle Apps in Victoria for the next couple of months. I have been supporting iAS as DBA but didn't do much development. Besides, Oracle Apps still have 9iAS R1. I will play with 10g and 9iAS R2 as soon as I can. Perl also sounds good since I already use it for other stuff and have all the books/manuals I need.

Question, if I use Perl doesn't it mean that I will be writing CGI scripts? Perhaps I am more out of date than I think...

Perhaps we can talk about it over coffee or beer. I am a consultant and travel quite a bit, mostly in BC, but sometimes in Alberta, Ontario and Quebec.

my telus id is 'kgordin'

Thanks, Hans!

K. Received on Fri Feb 20 2004 - 19:06:56 CST