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.
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/deploy.sh 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.
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.