DBPrism - DBPrism Demos ::-

DBPrism at work

PLSQL XML, OAS/iAS compatibility and Transaction Support
Java Stored Procedures support XML / Cocoon2 / Oracle's XSU integration

How to install XML Demo App. (PLSQL)

You must have installed Oracle packages htp, Oracle 8.1.7.+ includes it into sys's schema.
Install xtf and xtp packages. See Install toolkit document on this section.
Install demo package using ant install-plsql-demo , this task will use demo username and password stored on common.xml file.
Check the existence of sample DAD on prism.xconf file.
Start Jetty with ant run.
With a browser launch PLSQL Demo Page using the url http://localhost:8888/ and enjoy DBPrism.

Click Here

How to install XML Demo App. (Java)

You must have installed Oracle XDK 9.0.2+, Oracle 8.1.7.+ includes XDK 9.0.0 into sys's schema, upgrade it first.
Install DBPrism Java XML Toolkit procedure. See Install toolkit document on this section.
Install DBPrism Java Demos using ant install-demo8i .
Download DBPrism CMS distro, and go to the directory sites/www.dbprism.com.ar/.
Start Jetty with ant run.
With a browser launch Java Demo Page using the url http://localhost:8888/xmlj/DEMOj.startup and enjoy DBPrism/Cocoon.

Click Here

DBPrism - JSP integration

DBPrism 1.2.1+ includes demos of DBPrism - JSP integration, this are preconfigured with OC4J/Tomcat servlet container.

forward.jsp runs directly with the configuration of dpls zone because <jsp:forward> directive makes a new request to /dpls/jsp/demo.forward plsql example. Unlike <jsp:forward>, <jsp:include> directly pass his request to the plsql example, then DBPrism will receive an url like this http://server:port/dpls/examples-jsp/forward.jsp , in this url DBPrism needs an special configuration changing the parameter global.behavior=1 . Behavior equal to 1 means that DBPrism extracts examples-jsp as DAD name.

Click Here ( source)

JSP Include functionality is another example, click here to see it ( source)

Proxy user support and JAAS/SSO support

Latest DBPrism distribution support JAAS and SSO authentication using JDBC Connection proxy user support. A new DAD parameter is defined to this purpose ( useProxyUser=true) also JTADBPrismConnectionCacheImpl is the connection cache used to support proxy user.
To test this functionality follow these steps to create a proxy user for the above demo:

Connect as SYS and execute:
SQL> create user jetty identified by jetty;
SQL> alter user jetty grant connect through scott;
SQL> grant create session,create synonym to jetty;
Connect as SCOTT and execute:
SQL> grant execute on demo to jetty;
SQL> grant all on quote to jetty;
Connect as JETTY and execute:
SQL> create synonym demo for scott.demo;
SQL> create synonym quote for scott.quote;
Start Jetty with ant run.
With a browser launch PLSQL Demo Page using the url http://localhost:8888/secure/demo.startup is the same demo but you has to provide jetty/jetty as user name and password to gain access to resource.

Proxy user support gets the list of valid users from the web server environment and uses this user name to active the JDBC proxy user support. For more information you can see this page. The sample list of users is located at conf/demoRealm.properties for the Jetty demo, but you can use any JAAS or SSO authorization method which provides a valid req.getUserPrincipal() or req.getRemoteUser().