Package org.h2.samples

Standalone sample applications.

See:
          Description

Class Summary
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.
 

Package org.h2.samples Description

Standalone sample applications.