Package org.h2.samples

Standalone sample applications.

Class Summary

Class	Description
CachedPreparedStatements	This sample application shows how to cache prepared statements.
Compact	This sample application shows how to compact the database files.
CreateScriptFile	This sample application shows how to manually create an encrypted and compressed script file.
CsvSample	This sample application shows how to use the CSV tool to write CSV (comma separated values) files, and how to use the tool to read such files.
DirectInsert	Demonstrates the benefit of using the CREATE TABLE ...
FileFunctions	This sample application shows how to create a user defined function to read a file from the file system.
Function	This sample application shows how to define and use custom (user defined) functions in this database.
FunctionMultiReturn	User defined functions can return a result set, and can therefore be used like a table.
HelloWorld	A very simple class that shows how to load the driver, create a database, create a table, and insert some data.
InitDatabaseFromJar	In this example a database is initialized from compressed script in a jar file.
MixedMode	This sample program opens the same database once in embedded mode, and once in the server mode.
Newsfeed	The newsfeed application uses XML functions to create an RSS and Atom feed from a simple SQL script.
ReadOnlyDatabaseInZip	This sample application shows how to create and use a read-only database in a zip file.
RowAccessRights	This sample application show how to emulate per-row access rights so that each user can only access rows created by the given user.
SecurePassword	This example shows how to secure passwords (both database passwords, and account passwords).
ShowProgress	This example application implements a database event listener.
ShutdownServer	This very simple sample application stops a H2 TCP server if it is running.
SQLInjection	SQL Injection is a common security vulnerability for applications that use database.
TriggerPassData	This sample application shows how to pass data to a trigger.
TriggerSample	This sample application shows how to use database triggers.
TriggerSample.MyTrigger	This class is a simple trigger implementation.
UpdatableView	This sample application shows how to use triggers to create updatable views.