Databases Block Samples

Back

Back - to Cocoon Samples main page
Back - to Cocoon Blocks Samples main page

For the examples of this block to work, either the HSQLDB block needs to be present as well or another RDBMS backend needs to be configured. Schema information is contained in each subdirectory of samples/databases.

SQL Transformer

Documentation - Documentation for this component.
SQL Transformer - Simple example using the SQL transformer.
Nested Queries - Example with two queries nested into the third one.
XML Test - Example with inserting XML into a database and with a select statement nested into the insert statement.

XSP

Documentation - Documentation for this component.
ESQL Logicsheet - Simple example of embedding SQL in a serverpage using the ESQL logicsheet.

Modular Database Actions

This application demonstrates the use of the newer database actions that are based on Cocoon's input and output modules to read and write data from and to many more places than request attributes and parameters.

Documentation - Documentation for this component.
Manage Users and Groups - An example web-application built around database actions from the modular package which supports auto increments and more.
File Upload to Blob - A simple example demonstrating of populating a binary database column via a multipart form file upload.

Original Database Actions

These examples are created around the original database actions and the use of ESQL.

Documentation - Documentation for this component.
Manage Employees - Adds, updates and deletes Employees to the employees table.
Insert Department - Adds new Departments to the department table.
Insert Employees - Adds new Employees to the employees table.
Show Departments - Show all departments.

Tutorial

This tutorial demonstrates the use of the original database actions in conjunction with actions sets and ESQL.

Documentation - Documentation for this component.
Personnel Administrator - Start the tutorial application.