Re: connect databases via http

On febr. 1, 17:37, "shakespeare" <what..._at_xs4all.nl> wrote:
> "Donkey Hot" <s..._at_plc.is-a-geek.com> schreef in berichtnews:Xns9A37B6015C393SH15SGybs1ysmajw54s5_at_194.100.2.89...
>
>
>
> > "shakespeare" <what..._at_xs4all.nl> wrote in
> >news:47a3371e$0$85796$e4fe514c_at_news.xs4all.nl:
>
> >> "Ana C. Dent" <anaced..._at_hotmail.com> schreef in bericht
> >>news:HtGoj.41493$Wt7.7180_at_newsfe14.phx...
> >>> prunoki <hegyv..._at_ardents.hu> wrote in news:f8c01d18-c872-4a00-9fa6-
> >>> 33e7491f4..._at_e25g2000prg.googlegroups.com:
>
> >>>> Hi,
>
> >>>> Do you know of any means to connect two Oracle 10g databases via
> >>>> http or https without using a middle tier (php, java, whatever...)?
> >>>> One db here, one db there and the traffic have to go through company
> >>>> firewalls. No proxys would be standing in the way, we get direct
> >>>> connectivity via http. It would be very nice to be able to query the
> >>>> other database somehow directly from pl-sql.
>
> >>>> Regards,
>
> >>>> Krisztian
>
> >>> Oracle RDBMS does not speak hhtp or https.
>
> >>> So the short answer is, "NO!".
>
> >> This is not completely true, the oracle listener can also accept http
> >> requests, and listen to port 80. A database can be contacted through
> >> http without having a http server.
> >> If the above functionality can be built with that... I doubt it. One
> >> could perform procedure/function calls over http...
>
> >> Shakespeare
>
> > I doubt the Oracle listener can "Talk" http, while certainly can be
> > configured to use http port (80) instead of the default.
>
> > But anyway, if the corporation needs this, it certainly can open Oracle
> > default port in it's firewalls. Which is dangerous.
>
> > No matter what the port is, it's dangerous. I would not open my Oracle
> > server to the internet, no matter how "unbreakable" is might be in Larry
> > Ellison's head.
>
> I guess your right, listening is not talking....
>
> Shakespeare

I have found something:

One can use utl_http on the querying side (try select utl_http.request ('http://www.google.com') from dual, if I can recall it correctly). The other side can be an Apache using mod_plsql to call pl/sql procedures to generate the answer. In my case the answer can be an XML, which the querying side can process easily. As far as I can see it could be done this way, more or less like a web service.

Krisztian Received on Fri Feb 01 2008 - 12:23:00 CST