Re: Oracle-Web Integration Newbie...

From: Jeff Kalchik <jeff_kalchik_at_spam-me-not.mw.3com.com>
Date: Thu, 18 Mar 1999 17:28:40 GMT
Message-ID: <36f136fb.818369@news.usr.com>

On Wed, 17 Mar 1999 18:29:26 GMT, Steven Parker <sparker_at_wash.inmet.com> wrote:

>Hi,
>
>I have just installed Oracle 8.0.5 on Linux. I want to access the
>database via the WebServer, Apache. I had planned on using CGI PERL
>scripts with ODBC connections, but Oracle does not have an ODBC driver
>for Linux....
>
>So, I guess some choices are Application Server, Web Application
>Server....
>
>I want to use Apache as my webserver, so does anybody have any ideas of
>how I can access the database via the Web while keeping Apache as my
>webserver? Are there any PERL modules, ect that will allow me to make
>CGI scripts to connect to the database?
>
>Any help in this matter is much appreciated. I am new to Oracle....
>
>Thanks,
>
>Steve
>

Use the Perl DBI/DBD::Oracle modules. I haven't tried the Linux versions yet (downloaded but not installed yet), but the DBI/DBD integration is working pretty well under HP-UX.

Be forewarned: process fork time and database login times will be comparatively expensive for CGI activity. If you've got a high-activity web site, take a look at things like mod_perl for persistent connections.

comp.infosystems.www.servers.unix is another good place to look for performance tips after you get the basic Oracle connections working.

Oh, and look up CGI.pm as well........

---

Jeff Kalchik
Views expressed are my own, not my employers. Received on Thu Mar 18 1999 - 11:28:40 CST