Projects / DBPrism


DBPrism is an open source framework to generate dynamic XML from a database. It connects Oracle databases with Apache Cocoon, providing a high performance DBGenerator with functionality such as parallel content aggregation and ESI cache protocol. It also includes a powerlful database oriented CMS built on top of Apache Cocoon2 and DBPrism.

Operating Systems

Recent releases

  •  21 Jun 2003 15:14

    Release Notes: This is a maintenance release which includes a DBPrism Generator for the Apache Cocoon2 framework. It includes several enhancements, such as remote debugging using Oracle JDeveloper, and some bugfixes.

    •  16 Sep 2002 08:08

      Release Notes: This release includes 1.2.x production version of mod_plsql, although being a prerelease of the 2.0 branch. It also includes optimization improvements, new features such as connection pooling using JNDI, exclusion list of packages, Xform wrapper, new parameters, and a security layer and the front end for the CMS, and bugfixes.

      •  24 Apr 2002 17:10

        Release Notes: This new release has many improvements on the Cocoon2 generator, such as parallel content aggregation and the External Cache Invalidator Server (which supports the ESI invalidation protocol). DBPrism CMS uses the new features of the generator and includes a new addin for Oracle JDevelopor 9i for quick uploading of CMS assests directly through an XML editor. Also, minor bugs have been fixed.

        •  24 Nov 2001 13:39

          Release Notes: The XML documentation includes more sections. document-v10.dtd includes SVG entities, and DB Prism CMS can store and search SVG images inside the XML content. The Jxtp Toolkit for Oracle 8i/9i now uses BLOB. A DBPrismGenerator has been added for the Cocoon 2 Architecture. CMS was rewritten using Cocoon 2. dbprism.ear was added for J2EE (OC4J). Step-by-step documentation for installing DB Prism/Cocoon 2 on OC4J has been added. CMS has been integrated with Oracle Web Cache. DB Prism mod_plsql demos for OC4J and DB Prism XML demos with Java Stored procedures and DB Prism/Cocoon CMS for OC4J have been added.

          Recent comments

          13 Sep 2003 04:51 mochoa

          DBPrism CMS 2.0.1 released
          FYI DBPrism CMS 2.0.1 production is ready for downloading at SourceForge web site.
          See release notes at:

          Or go to the download section:

          dbprism.[war|ear] file could be made using the script $CMS_HOME/scripts/ or using the project file for Oracle JDeveloper 9.0.3.

          Viewlet Builder with install instructions and how to use the FrontEnd application are comming soon.

          14 Feb 2001 16:12 mochoa

          Cocoon integration
          DB Prism plugged into the Apache Cocoon framework is a new way for making Internet applications with technologies as XML and XSLT. Cocoon is a presentation framework based on servlet technology, so it can run in any web server supporting servlet technology. As a presentation framework it has the responsibility for serving pages requested by the user, applying first styles as the page needs and transforming static or dynamic XML content into HTML. Cocoon is also able to perform more sophisticated formatting, such as XSL:FO rendering on PDF, WML formatting for WAP-enabled devices, or direct XML serving to XML and XSL aware clients. The Cocoon project aims to change the way web information is created, rendered, and served by completely separating document content, style, and logic.
          DB Prism is plugged into the Cocoon framework for the XML creation step. It then moves the logic to the database, closely allied to the data itself. The most important characteristic of DB Prism is that unlike in other technologies, the logic of the application resides in the database as a stored procedure. The stored procedure could be written in the proprietary language or in Java. Writing stored procedure in Java with a JDBC or SQLJ call guarantees portability across different database vendors because there is a standard defined for this purpose.

          14 Feb 2001 16:10 mochoa

          Backward compatibilty for Oracle Applications
          The main motivation to work like the PLSQL Cartridge of Oracle Web Server is to allow old technologies to coexist with new ones, helping in the migration path. Using DB Prism it is possible to run applications made to work with Oracle Web Server ( OWS ( ) in the same box or the latest Oracle Internet Application Server ( IAS ( ) mod_plsql ( without any modifications.
          This kind of application includes applications designed with Oracle Designer - Web Server Generator ( or Oracle Web DB ( , and standalone applications made using the PLSQL HTP toolkit (Html Toolkit Procedures is group of related procedures or functions written in PLSQL to make application for the Oracle Web Server architecture). For further information on how these applications work, refer to the developer's manuals of these products.

          08 Jan 2001 16:31 mochoa

          DB Prism - Cocoon integration at Wrox Press
          DB Prism ( - Cocoon ( integration has a chapter in a book of
          Wrox press
          Profesional XML databases (
          This chapter named DB Prism: A Framework to Generate Dynamic XML
          from a Database" includes:

          - Cocoon architecture.
          - DB Prism architecture.
          - DB Prism class diagram.
          - DB Prism: Benefits provided to the Cocoon Framework.

          Part I. DB Prism Internals; focusing on "How to write a new Adapter":

          - Who is who?
          - Code to be taken into account.
          - DB Prism
          - DBConnection
          - DBFactory
          - SPProc
          - Common issues on writing a new Adapter.

          Part II. Putting DB Prism at work.

          - Cocoon Setup on Oracle Internet Application Server - IAS (
          - DB Prism Setup on IAS
          - Loading DB Prism examples
          - Making a Content Management System (CMS)
          - Brief introduction to a CMS
          - Design of the meta model
          - Writing the Java Code
          - Loading the Content
          - Making two different stylesheets
          - Conclusion and beyond

          This chapter is based on DB Prism 1.1.0 production.


          Project Spotlight


          A Fluent OpenStack client API for Java.


          Project Spotlight

          TurnKey TWiki Appliance

          A TWiki appliance that is easy to use and lightweight.