On Sat, 2009-06-20 at 02:14 +0300, Burak Arslan wrote:
> Gene Amtower wrote:
>
> > On Fri, 2009-06-19 at 18:15 +0300, Burak Arslan wrote:
> >
> > > Gene Amtower wrote:
> > >
> > > > I'd really like to be able to have an RPC server for these
> > > > applications that is accessed through the modplsql module. I
> > > > think I could create the RPC server in an Oracle package using
> > > > the guidelines for writing an RPC server and based on the
> > > > existing PHPRPC server approach, but I wonder if anyone has
> > > > already looked at doing this in Oracle.
> > > >
> > >
> > > what rpc protocol(s) does mod_plsql support ?
> >
> >
> > Burak,
> >
> > Your question is just short enough to be vague to me 0- I'm not sure
> > if you mean data protocols or connection protocols.
> >
> > If you mean connection protocols, modplsql is just a module loaded
> > into the Apache daemon environment, so it supports whatever the
> > Apache server supports. I think it would have the same capabilities
> > that we have with our PHPRPC system on the Qooxdoo project,
> > providing http GET/POST support to the Qooxdoo client libraries.
> > The requests themselves are just passed on to the Oracle procedural
> > environment by the modplsql module, so any details of the
> > communication are going to depend on the Oracle environment rather
> > than the modplsql module itself.
>
>
> so mod_plsql is oracle's response to php? heh :)
Maybe more appropriately, PL/SQL (the embedded Oracle programming
language) is Oracle's response to PHP, and mod_plsql just provides the
gateway from the Internet to the embedded procedural language within the
database environment. I don't know when PL/SQL began, but it's been
around since at least 2000 as a part of Oracle 8i, which is when I
started developing in Oracle.
PL/SQL stands for Procedural Language / SQL, which means it's a union of
the two. I can write procedures and functions with control structure
and embed the SQL statement in plain language right within the code
statements. The query statements can include variables from the code,
and the code can read the row/column results by query variable names.
Besides writing implicit queries this way, you can also construct a
query command string and run explicit queries much like in PHP.
The Oracle database provides a large number of utility code packages for
a variety of purposes, including XML handling, output control, and
various internal database manipulations. Unfortunately, the latest
version doesn't seem to have JSON support, but I've found an add-on code
package that adds that capability to the existing functionality. Of
course, since it already has XML support, the only missing piece might
be the SOAP component you mentioned. I don't know if the other Qooxdoo
backends have that type of support, so it might not be necessary to
include it in my Oracle backend.
The real power of Oracle is that it handles extremely large datasets
with ease and aplomb. The PL/SQL code is actually compiled on first
use, and all later calls to the compiled code packages runs it in native
Oracle code, as compared to a raw interpreted language.
For large-scale application development, the performance just can't be
beat. But I really want to be able to leverage the Qooxdoo framework
within my Oracle projects, which is the reason for my interest in an RPC
server in Oracle.
Gene
>
> anyway i was trying to ask about an rpc protocol it might be
> supporting, something like jsonrpc, xmlrpc, soap, etc. which work over
> any transport layer including http. qooxdoo supports a few important
> rpc protocols.
>
> i was asking because i'd imagine there would be an adapter for soap
> protocol from oracle, (probably something outside mod_plsql) in which
> case you can use my contrib that implements it. maybe i should have
> mentioned it in the first mail, sorry about that.
>
> it's not yet part of mainstream qooxdoo (yet?) but it's been working
> in our dev environment w/o problems so far. it's more mature than a
> beta quality code, but i think it needs more testing.
>
> hope you find it useful,
>
> best regards,
> burak
>
>
>
> ------------------------------------------------------------------------------
> Are you an open source citizen? Join us for the Open Source Bridge conference!
> Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
> Need another reason to go? 24-hour hacker lounge. Register today!
> http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
> _______________________________________________ qooxdoo-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
------------------------------------------------------------------------------
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
_______________________________________________
qooxdoo-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
