Description of the data flow of this sample:
-
an XML DOM object is produced from the database query with dbQuery tag
-
The XML DOM object is cached wth cacheXMLObj tag
-
The cached DOM object is transformed an XSL stylesheet, which can be changed
based on per user basis, with transform tag
-
The transformed HTML result can be further cached in Java Web Cache
with using its cache tag or in Oracle Web Cache
with JESI tags.
NOTE:
-
Developers should JESI tags to cache transformed HTML result in
Oracle Web Cache as much as possible to offload the java layer. We
use Java Web Cache just to illustrate the idea of caching the final HTML
result.
-
dbOpen, dbCloseQuery, dbClose tags are also needed to open/close a database
connection, close database query.