• Support for remote debugging of PLSQL and Java Stored Procedure using JDeveloper 9.0.3+. Now you can debug your application running into the server side, with step by step functionality, breakpoints and local/global variable editing tools.
• New DAD parameters are available to configurate remote debugging information ( debugHost/debugPort).
• XForms Wrapper accepts HTTP POST XML request.
• ESI invalidator Server accepts invalidation messages with no parameters or cookies to invalidate all the pages that match with the given URI.
• New ESI Invalidator Server implementation using HSQL in memory database, it provides a more scalable solution for complex websites.
• CMS upload scripts uploads the source with debugging information.
• Using new functionalities of ESI support now live area header are cacheable and Cocoon cache system will store multiples version of the same page which have personalized attributes such as username/password, cookies and so on.
• Upload utilities includes timing information about the rebuild operation of the Oracle Text index.
• A new CMS component provides RSS feed from OTN or SourceForge(TM) web site.
• DBPrism CMS includes Cocoon 2.0.4 production release.
• DBPrism CMS/Cocoon prepackage application included comments on cocoon.xconf file with the information about how to use Oracle XML parser V2 as default parser for Cocoon2, it will increase the performance around a 20%.
• prism.properties file now is loaded by context from /WEB-INF/ directory, for security reason this directory is good place to put database sensitive information.
• The stylesheets where refactored by funcionality and reused by inclusion.
• Correct bug which append null values when ht_buf is 2*256 bytes length into mod_plsql emulation.
• Support for uploading CMS document in native format (document-v10.dtd) or OpenOffice 1.0. With this functionality users can upload OpenOffice Writer document using the CMS frontend application.
• CMS Upload utility and DBPrism CMS Addin for Oracle JDeveloper also can upload OpenOffice 1.0 Writer documents.
• A new CMS Addin Wizard will help users in a creation of the CmsConfig.xml file for the DBPrism CMS Upload Addin by selecting the database target on the System navigator.
• DBPrism CMS sources where refactored into three categories, Core support, Client utilities, Extensions and FronEnd.
• DBPrism CMS provides Scheduled operation for publishing or deleting pages at an specific time, using DBMS_JOB database package.
• New look & feel has been added to the CMS.
• CMS install scripts allows user decide which dabatases users are used for cms_owner and cms_user_sec, so you can install multiples repository owners sharing the same cms_user_sec schema.
• Correct problem of JDeveloper Addin of null setting of the g_id column on the pages table.
• Due to internal bugs into the Oracle JVM, upload OpenOffice requires patchset 9.2.0.3.

Download, Disponible formats: DBPrism Zip DBPrism Tar.gz CMS Zip CMS Tar.gz

• DBPrism/Cocoon CMS and examples requires a separate download, to keep DBPrism distribution smaller.
• Bugs corrected 626985, 626993, 651560 and 663279, see SourceForge web site more details.
• Feature request implemented 626981, see SourceForge web site for more details
• New parameter added, global.flexibleRequest, see Parameter document on Documentation section.
• New CMS Addin for JDeveloper 9.0.3 and viewlet demostration about how to install and configure, see document CMS Addin and section CMS for more detail.
• DBPrism CMS now provides multiples groups for each users.
• Cocoon documentation is no longer included into DBPrism CMS upload, now uses Cocoon docs as is.
• DBPrism CMS is packed with new directory layout to provide an automatic deploy using JDeveloper 9.0.3 wizards.
• Install scripts uses "cms" as connect string for the target database.
• DBPrism CMS includes a simple workflow for documents to be public.
• DBPrism CMS provides functions to view and retrieve document version history.
• DBPrism CMS and Cocoon examples uses Cocoon 2.0.3-production.
• DBPrism CMS Frontend has support for creating pages using templates.
• DBPrism CMS Frontend has support for preview and edit versionned pages.
• DBPrism CMS Frontend includes Xopus integration (experimental), Xopus is a browser based in-place wysiwyg XML editor.

Download, Disponible formats: Zip Tar.gz

• Jxtp Toolkit was optimized for reducing End-Of-Call Migration resources into Oracle Database JVM.
• DBPrism is now hosted at SourceForge web site.
• DBPrism CMS was optimized for reducing End-Of-Call Migration resources into Oracle Database JVM.
• DBPrism CMS changes his URL naming convention to provide better response time with invalidation messages using regular expresion.
• A new implementation of External Cache Invalidation Server implements Regular expresion in advanced invalidation messages.
• global.lang and global.country parmaters has been added to quickly override JVM system parameters, see Document -> Parameters -> Global section for more details, thanks to Daniel Muller for this sugestion and feedback.
• DBPrism included a Connection Cache implementation for using JNDI Datasources look at Documentation -> Parameters -> Resource Manager for more details.
• Correct problem of loading CmsConfig.xml by CMSAddin into win32 platform.
• Correct problem of calling to default page.
• Prevent that malicious user may directly access oracle database server information or write cross-site script attack by adding DAD exclusion_list parameter. Look at http://otn.oracle.com/deploy/security/pdf/ias_modplsql_alert.pdf for more information. PLSQL mode.
• Correct bad username and password information with perPackage authentication. Java and PLSQL mode.
• DBPrism CMS includes support for a subset of XForms tags implemented with Xalan extension and DBPrism XFormsWrapper which converts standard HTTP parameters into a post XML representation.
• DBPrism CMS includes a simple Frontend application for editing content metadata, look at http://localhost:8888/dbprism/ldoc/Home.html.
• DBPrism CMS includes a Unix like security layer, look at the CMS Security Section for more detail.
• Correct minors formating problem on Jxtp toolkit.

Development Snapshot, Disponible formats: Zip Tar.gz

• mod_plsql support tested with HP Applications Server 8.1 (HP-AS), install instruction comming soon.
• Add support for loading prism.properties file through jndi:/ context, corrects problem with Tomcat 4.0.x.
• Correct problem of passing Content-Length header to Cocoon on DBPrismGenerator.
• DBPrism CMS and Java Stored Procedures demos are configured using sub sitemap.
• producerarg parameter on global section of prism.properties is no longer valid.
• New Adding for JDeveloper 9irc, to upload document into the CMS repository.
• Date syntax for cookies is unified betwen Java toolkit and PLSQL toolkit.
• Toolkit 4x support now is the default value for PLSQL adapters.
• A News feed component using content agreggation was added using Moreover (TM) source.
• A fine grain triggers are added to invalidate in separate steps header information or content data.
• XML documentation is in process of restructuration.
• DBPrism Generator for Cocoon2 provides parallel content agregation functionality.
• DBPrism CMS is built on top of Cocoon2's content agregation.
• DBPrism Generator includes an External Cache invalidator to replace Oracle Web Cache functionality. DB Prism CMS uses Cocoon2 internal Cache to speed up the content generation and includes an External Cache Invalidator XSP page to syncronize the content with the database, look at CMS Section for more details.
• dbprism.ear file includes Cocoon 2.0 production release.
• Correct problem with Cookie syntax (date format) according to owa_cookie 8.1.7, thanks to Wilson (WPenha@americel.com.br).
• Producer for Cocoon 1.x is no longer valid.
• Jserv is no longer suported.
• Correct minor bugs in upload/download functionality for Oracle Lite support.
• Tested with Oracle Lite 9i release 5.0.
• Correct bug in CgiVar array, thanks to Martin (Martin.Groinig@trivadis.com).

Disponible formats: Zip Tar.gz

• XML documentation includes more sections
• document-v10.dtd includes SVG entities, then DB Prism CMS can store and search SVG images inside the XML content, look at CMS-Tables document as an example.
• Jxtp Toolkit for Oracle 8i/9i uses BLOB instead of CLOB to transfer XML content from the database side to DB Prism engine
• New DBPrismGenerator which works with Cocoon 2 Architecture
• CMS was rewrite using Cocoon 2 architecture
• New deployment file dbprism.ear which works with Oracle 9iAS Object Container for J2EE (OC4J)
• Document with step by step information for installing DB Prism / Cocoon 2 on OC4J
• CMS integration with Oracle Web Cache
• DB Prism mod_plsql demos are pre-configured for OC4J packaging
• DB Prism XML demos with Java Stored procedures and DB Prism / Cocoon CMS are pre-configured for OC4J packaging and Cocoon 2 architecture

Disponible formats: Zip Tar.gz

• New JspWrapper which works with <jsp:include> <jsp:forward> tags off JSP Pages
• Correct problem of dynamic login with Oracle Connection Caching scheme
• Correct problem of REMOTE_USER cgi variable when using DAD with hard coded database username and password
• New CGI enviroment vars to be compatible with iAS mod_plsql gatewary, like Authorization, REQUEST_PROTOCOL and so on
• New deployment file dpls.ear for Oracle 9iAS Object Container for J2EE (OC4J)
• Corrects error reporting when a transaction timeout is greater than Manager.timeout
• Parameters which aren't in procedure definition throws an exception
• Support for Oracle 9i databases, compat 9ijava and 9iplsql, thanks to

Disponible formats: Zip Tar.gz

• New look and feel in DB Prism web site, optimized for speed
• CMS Includes an interface for generating dynamic content like a Search Engine or FAQ list, look at CMS Dynamic section for more details
• XML Transactional Demo written in PLSQL, look at source in oi directory of this distribution
• Oracle Java Xml Toolkit for 8i/9i databases corrects the problem of bad charaters translation of temporary CLOB
• CMS can import and saves DTD into the database
• CMS includes a pre-processing of html sources with JTidy, to directly upload document in html form
• CMS includes a Search Engine which uses AltaVista (TM) query syntax
• CMS upload utility can extract header information from document-v10.dtd to the Content metadata of table pages, look the Cocoon link to see as an example how DB Prism CMS can manage and show stylebook documents.
• New options for prism.properties, it needs to add Manager.class parameter which is mandatory
• New Distribution file PrismNoJTA.jar which works with jdbc drivers 1.x
• Corrects problem of Jxtp toolkit with 8.1.7 databases
• Supports for native Oracle Connection Caching and JTA
• Better synchronizacion support with Connection Cache and JDBC 1.1 drivers
• Corrects bug of do not dicrease connection in use with lossing connections
• Corrected bug NLS support sent by Sergei Naumov
• Corrected bug html buffered corrupt with high worlkload sent by Albert Borrull i Preixens (aborrull@sgosoft.com) and Albert Aymerich
• Corrected litle inconsistence with flexible parameter support sent by Charly Schmid

Disponible formats: Zip Tar.gz

• Support for OWS 3.x, OAS 4.x and Web DB toolkits without any modifications
• Full compatibility with Oracle IAS 1.0 mod_plsql
• Upload Download functionality for Oracle 8i and Oracle Lite
• DB Prism / Cocoon CMS was written using Java Stored Procedure
• CMS includes a Java Client application to upload the content
• CMS Upload Client application use an XML file to configure the site
• CMS permits reference to documents directly by a file system url
• CMS permits give a stylesheet at importing time for converting differents xml sources to document-v10.dtd of the CMS representation
• Java Xml Toolkit now include full support for uploading/downloading
• New demos for Oracle 8i and Lite with Java Stored Procedure
• UML Information was updated

Disponible formats: Zip Tar.gz

• ResourceManager is improve in reallocate connection modified by Rober E. Parrot
• Java Store procedures support is unified in Oracle 8i and Oracle Lite (same Adapter)
• Xml Toolkit Procedures is in version 1.0.1
• Java Xml Toolkit now include full support for Header setup and Cookies
• HeaderProcessor has support for multiples pi tags and correct syntax of Cookie Spec modified by Lev Epshteyn
• New Java Stored Procedures Demos for Oracle Lite and Oracle 8i using SQLJ and Oracle XML Query
• CMS now include Dynamic Document reference tag in importing time
• CMS now permit static snapshot in the file system for improving performance
• CMS now permit document print mode off full article
• Update how to configure DB Prism under windows NT & Apache/Jserv by Daryl Collins
• Correct Problem of maximum ora-1000: opened cursor
• DAD Connection information now include parameter for setting StateLess packages
• Oracle 8i and 7x Adapter now inherit from PLSQL Adapter
• Correct problem of reserved word as parameters names (PLSQL Adapter) reported by Carlos Arias Rodriguez

Disponible formats: Zip Tar.gz

• Correct problem of closing cursor after getting column data (8i and 7x adapters)
• Correct problem of page lenght under transactions (8i adapter)
• Correct problem of arguments larger than 4096 chars of length (7x and 8i)
• Correct problem of getting binary data from DB (ej: images or sounds)
• Update DB Prism Internals
• Include CMS (Content Management System) (this software)

Disponible formats: Zip Tar.gz

• Correct problem with high workload
• Testing with JMeter to view performance spec. Results are comming soon Emulating Oracle Web Server 4Kbytes page size / 6 concurrent users: 200ms average => 14 Million pages a week
• Integrate with cocoon (Hello World example): 342 bytes XML data (From DB producer - DB Prism) 763 bytes XSL data (static file - 4 templates) 350 bytes HTML output 190ms average => 18 Million pages a week On a Sun Ultra-250 server/ two processor 512Mb ram /Solaris 8/ JDK 1.2
• Update Rational Rose UML Model

Disponible formats: Zip Tar.gz

• Tested with Cocoon 1.7.3
• Add installer with InstallAnyWere
• Correct several bugs in ResourceManager which affect transaction support
• Add Documentation about Prism Internals and Design
• Add ConnectionWrapper to permit that XSP Pages reuse connection from Resource Manager
• ExcelFormatter is not included. Cocoon 1.7.3 permit reuse the TextFormatter with differents mime types
• Demos on-line at http://cocodrilo.exa.unicen.edu.ar/servlets/plsql/demo.startup

Disponible formats: Zip Tar.gz

• Initial version
• Add support for Oracle Lite databases with Java Stored Procedures
• Complete Re-design with Design Patterns
• New toolkit in Java to generate XML tags in Java Stored Procedures
• Tested with Cocoon 1.7.2
• Support for toolkit of OAS 4.x (only at level of htp & htf packages)
• Documentacion and Specifications in UML

Disponible formats: Zip Tar.gz