...| Home | Documentation...
Documentation > Parameters > ConnectionCache >
Global > DAD > ConnectionCache >
+ Home ...
+ Download
> Documentation
+ DBPrism Content Management System
+ DBPrism - Apache Cocoon
+ Credits
+ Legal
 
+ Documentation
+ Frequently Asked Questions
+ Readme
+ Demos
+ Changes
+ Thigs To Do
+ Toolkits
+ JavaWebServer
+ Tomcat
+ Installing DBPrism/Cocoon2 on OC4J
+ Installing DBPrism on Cocoon2/OC4J/Linux: Introduction
+ Apache/JServ on NT
+ Resin
+ Parameters
+ Internals
 
+ links
+ Yahoo.groups
+ OTN
+ OSCOM.org
 
Moreover news
+ IBM speeds Java on mainframes (CNET Asia)
+ Middle-aged mainframe converts to Java (ZDNet UK)
+ IBM speeds Java on mainframes (ZDNet)
+ IBM speeds Java on mainframes (CNET)
+ All Buttons (JavaBoutique)
+ Drag-and-Drop Editor Out for Linux Devs (Internet News)
+ Using Program Parameters in Java (JavaBoutique)
+ Sun pledges to cooperate with Microsoft (AP via Seattle Post Intelligencer)
+ Sun pledges to cooperate with Microsoft (Boston Globe)
+ Bitter legal feud ends with payment, Sun cuts 3,300 more jobs (China Post)
+ Sun and Microsoft settle (Chicago Sun-Times)
+ Microsoft to pay $1.6 billion, settle with Sun Microsystems (Baltimore Sun)
+ Visualize Hoovers Data With Anacubis (ResearchBuzz via ResearchBuzz)
+ Sun and BEA advance Java app offerings (Computer Weekly)
+ Sun wants to lift its Java profile (ZDNet UK)
+ 'Smack the Pingu' on Your Mobile Phone! (PA News via The Scotsman Online)
+ Third Generation Mobile Phone Game from Nihon Enterprise (Japan Corp)
+ Comment: Free but shackled - the Java trap (Sydney Morning Herald)
+ Sun plots Java comeback (CNET Asia)
+ Veritas and BEA vow to love Java together (The Register)
+ Microsoft and Sun's settlement will yield web services benefits and support for Java (Computer Weekly)
+ Sun plots Java comeback (CNET)
+ Sun plots Java comeback (ZDNet)
+ Sun enables new wave of mobile Java services (Sunday Times South Africa)
+ Sun Releases Sun Java Studio 6 (Techfocus)
+ Sam Pitrodas Telecom Firm Sets Up India Centre (Financial Express)
+ Multi Player Mobile Gaming (BBC)
+ Combining SOAP and JavaMail (Java Pro)
+ Draw Applet (JavaBoutique)
+ IBM dedicates module to Java on mainframes (CNET)
 
+ OTN News
+ View Live Customer Webcast Demos of Enterprise Manager 10g Grid Control
+ Oracle Database 10g for Windows Now Available for Download
+ Download New Oracle 10g JDBC Drivers
+ JDeveloper 10g Reviewed in Internet.com's Java Boutique
+ Java Developer's Journal Readers Name Oracle Products "Best" in Two Categories
+ New OracleAS Portal Extension for Macromedia Dreamweaver
+ Learn from the Experts During Java Week
+ Download Oracle Database 10g
+ New OracleAS Web Cache How-To Documents
+ Learn About SQL 2003 Support in Oracle Database 10g
+ New: Quick Installation Guide for RAC on Oracle Database 10g SE (Windows)
+ Oracle Forms Diagnostic Techniques
+ Introduction to JavaServer Faces
+ Prepare for Oracle Database 10g
+ New Tutorial: Learn JSP 2.0
+ Learn Best Practices for Consolidating Oracle on Linux Deployments
+ What's New in PL/SQL in Oracle Database 10g?
+ New Oracle 10g JDBC Samples
+ New Tech Tip: Using HttpUnit in Oracle JDeveloper 10g
+ Oracle 10g Supports Microsoft Windows Media Streaming Services and Windows Media File Format (ASF)
+ New Books at Oracle 10g Book Center
+ Tech Tip: Using JSTL SQL in Oracle JDeveloper 10g Preview
+ New Technical Article Series: The Hitchhiker's Guide to PHP
+ New Enterprise Manager 10g Grid Control Hands-on Tutorial
+ OC4J 10g (10.0.3) Developer Preview 2 Now Available
+ Download the New Oracle JDeveloper Application Migration Assistant (AMA) Search Rules for WebLogic Migrations
+ Learn Oracle in 2 Days
+ Download the new Oracle XDK 10g Production Release
+ Explore New JDBC 10g How-To's
+ New Oracle 10g JDBC Sample: CachedRowSet
+ New RowSet Implementation Tutorial Series
+ Download 2003 ODTUG Conference Papers
+ New Tutorial: Understanding TLD Caching in JSPs
+ Deploy the New J2EE 1.4 Adventure Builder Reference Application to OC4J
+ Download New Servlet Advanced Sample Applications
+ New: Oracle XDK 10g Unicode Support and XSLT Extension Sample App
+ New Oracle Application Server ProcessConnect End-to-End Samples
DBPrism at SourceForge
Built with Cocoon2
Documentation
 
DBPrism Connection Cache
Common
Name  Values  Default Value  Explanation 
Manager.class  A valid fully qualified class name  com.prism.utils.JdbcDBPrismConnectionImpl  A valid class name which implements a particular Connection Cache Algorithm. This parameter is mandatory from DBPrism 1.2.0+ . There are three Connection Cache implementations available in this version: com.prism.utils.JdbcDBPrismConnectionCacheImpl, com.prism.utils.JndiDBPrismConnectionCacheImpl and com.prism.oracle.JTADBPrismConnectionCacheImpl.  
Name  Values  Default Value  Explanation 
Manager.timeout  A valid integer in second   600  Timeout off unused connection in second, after this the connection is closed  

Transaction Support
Name  Values  Default Value  Explanation 
Manager.TxEnable  true/false  false  Enable/Disable Transaction support by url demarcation  
Name  Values  Default Value  Explanation 
Manager.TxNames  A space separated list of transaction names  empty  List of space separated TX names. For example "fly demo".  

Transaction Definitions
Name  Values  Default Value  Explanation 
txName.BeginURI  a valid URI  empty  URL who acts as a begin of the transaction, ej: /servlet/plsql/demo_pkg.Begin_URL  
Name  Values  Default Value  Explanation 
txName.CommitURI  a valid URI  empty  URL who acts as a commit of the transaction, ej: /servlet/plsql/demo_pkg.Commit_URL  
Name  Values  Default Value  Explanation 
txName.RollBackURI  a valid URI  empty  URL who acts as a rollback of the transaction, ej: /servlet/plsql/demo_pkg.RollBack_URL  
Name  Values  Default Value  Explanation 
txName.BelongTo  a ; separeted list of valid URI  empty  URIs who belong to the transaction, ej: /servlet/plsql/demo_pkg.*;/servlet/plsql/demo_otherpkg.*  
Name  Values  Default Value  Explanation 
txName.TimeOut  a valid positive number  500  Time out in second after the transaction is automatically rolled back  
Using the Resource Manager, you associate URIs with the operations on
transactions (begin, commit, and rollback). When a user invokes one of these URIs,
the corresponding transaction operation is performed by the ResourceManager.
These URIs can be mapped to stored procedures that
display appropriate pages to the user. For example, the begin transaction URI
could display to the user a list of items to add to his or her shopping cart, the
commit transaction URI could display to the user a list of purchased items, and
the rollback transaction URI could display to the user a page that asks if he wants
to drop the existing shopping cart and start another one.

Between the begin and the commit or rollback URI, the user invokes other URIs that
call procedures to perform some action on the database. These procedures might or
might not belong to a transaction. If the URI belongs to a transaction, the actions
performed by that procedure would be committed or rolled back when the transaction
ends. If the URI does not belong to the transaction, it is not affected by the
transaction, and Prism treats it as a regular request (changes made by that URI are
committed upon completion).
URIs belonging to a transaction usually invoke procedures
within a package.

The sequence of URIs for a stored procedures within the database when invoked
would look like the following:

-- begin a transaction
http://host:port/servlet/demo/test.txn_begin

-- the first operation in the transaction
http://host:port/servlet/demo/test.txn_update1

-- the second operation in the transaction
http://host:port/servlet/demo/test.txn_update2

-- some more operations

-- commit the transaction
http://host:port/servlet/demo/test.txn_commit

utils.JdbcDBPrismConnectionCacheImpl formerly ResourceManager
Name  Values  Default Value  Explanation 
Manager.minconnections  A valid integer value from 0 to n  Minimal numbers of active connections to a database  
Name  Values  Default Value  Explanation 
Manager.maxconnections  A valid integer value from minconnections to n  20  Maximun numbers of active connections to a database  

oracle.JTADBPrismConnectionCacheImpl

Note This Connection Cache implementation has indepent parameters for every DAD definition defined into DAD section.

Name  Values  Default Value  Explanation 
Manager.dad.MinLimit  A valid integer value from 0 to MaxLimit  Minimal numbers of active connections for this dad.  
Name  Values  Default Value  Explanation 
Manager.dad.MaxLimit  A valid integer value from 0 to n  20  Maximal numbers of active connections for this dad.  
Name  Values  Default Value  Explanation 
Manager.dad.LoginTimeout  A valid integer value from 0 to n  60  How many seconds wait for adquiring a particular connection.  
Name  Values  Default Value  Explanation 
Manager.dad.CacheScheme  A valid cache scheme  FixedWait  OracleConnectionCacheImpl class supports three connection cache schemes. Dynamic In this scheme, you can create new pooled connections above and beyond the maximum limit, but each one is automatically closed and freed as soon as the logical connection instance that it provided is no longer in use. FixedNoWait In this scheme, the maximum limit cannot be exceeded Requests for connection when the maximum has already been reached will return an error page. FixedWait Same as the "fixed with no wait" scheme except that a request for a new connection will wait if the limit for the number of connection has been reached. In this case, the connection request waits until another client releases a connection.  

oracle.JndiDBPrismConnectionCacheImpl

Note This Connection Cache implementation provides a simple way to use JNDI datasources defined into [OC4J_HOME]/config/data-sources.xml file. DBPrism will try to lookup a DataSource defintion for every DAD defined into global.alias parameter.

NoteAbout parameters into DAD section

Name  Values  Default Value  Explanation 
dad.dbusername/dad.dbpassword  Any valid string for username and password  empty string  This parameter is unused by this Connection Cache implementation, but if you left it in blank DBPrism will try to connect in dynamic mode, that is DBPrism will prompt the username and password through a browser popup. In the other hand using dynamic mode DBPrism will force to the JNDI DataSources to work in dedication connection mode affecting the performance. To use username and password defined into JNDI Datasources fills dad.username and dad.password with any string values.  
Name  Values  Default Value  Explanation 
dad.connectString  Ignored  Ignored  DBPrism ignores this parameter due to its defined into the DataSource parameter.  

NoteThis implementation do not support Transactions, it is planed for production release.




Global > DAD > ConnectionCache >
Last Update: 2003-08-07 09:42:03.0| webmaster@dbprism.com.ar
Search | Use AltaVista (TM) query syntax<<
Quick Links<<
(C) 2003 - DBPrism ~ DBPrism CMS | Marcelo F. Ochoa | TANDIL ~ Argentina