John Flack On MVC Development Using PL/SQL

September 29th, 2004 by Mark Rittman

A couple of years ago I helped put together a
discussion forum
application using the PL/SQL Web Toolkit. We released two versions of it and
put it up on sourceforge,
and for a while it was used as the internal discussion board within our company.

If you’re familiar with PL/SQL, using the Web Toolkit is
actually quite fun, and it’s pretty easy to put together database-driven
applications without too much overhead or initial work. Sometimes, however,
rather than coding absolutely everything from scratch, it’s good to have a
framework to work within, and some method of separating the presentation code
from the underlying application logic, and I was therefore interested to read a
recent Amis Blog
posting about a ‘Model-View-Controller’ approach for coding PL/SQL web
applications.

The article refers to a paper by John Flack entitled "MVC
Development in PL/SQL" and is available for download from the ODTUG
website. According to the paper introduction:

"I

Posted in Oracle Database |

Comments

  1. Yves Bergeron Says:

    September 30th, 2004 at 10:10 pm

    Hi,
    We the help of a Quebec government agency, we developed an open source pl/sql Struts. So, we can use a MVC architecture based on a pseudo-Struts through mod_plsql.
    We use XML DB to store our struts-config.xml. The view part is built with the help of Stamps (previously known as HTT). Our Stamps templates are also kept in XML DB.
    We use the mod_plsql DAD configuration parameters to specify the location of struts-config.xml for our different applications (modules).
    If needed, I can send you (french) documentation on this pl/sql struts framework.
    Yves Bergeron
    TELUS Solutions d’affaires.

  2. Mark Says:

    October 4th, 2004 at 10:19 pm

    Hi Yves,
    That’d be really interesting, but as it’s in French I doubt I’d be able to use it? If it’s easy to understand or it’s translated into English, I’d be keen to read it.
    Thanks
    Mark