quickstart.html 3.7 KB
Newer Older
1 2
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
3
Copyright 2004-2011 H2 Group. Multiple-Licensed under the H2 License, Version 1.0,
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
and under the Eclipse Public License, Version 1.0
(http://h2database.com/html/license.html).
Initial Developer: H2 Group
-->
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head><meta http-equiv="Content-Type" content="text/html;charset=utf-8" /><title>
Quickstart
</title><link rel="stylesheet" type="text/css" href="stylesheet.css" />
<!-- [search] { -->
<script type="text/javascript" src="navigation.js"></script>
</head><body onload="frameMe();">
<table class="content"><tr class="content"><td class="content"><div class="contentDiv">
<!-- } -->

<h1>Quickstart</h1>
<a href="#embedding">
    Embedding H2 in an Application</a><br />
<a href="#h2_console">
    The H2 Console Application</a><br />

Thomas Mueller's avatar
Thomas Mueller committed
24
<h2 id="embedding">Embedding H2 in an Application</h2>
25 26 27 28
<p>
This database can be used in embedded mode, or in server mode. To use it in embedded mode, you need to:
</p>
<ul>
29 30 31
<li>Add the <code>h2*.jar</code> to the classpath (H2 does not have any dependencies)
</li><li>Use the JDBC driver class: <code>org.h2.Driver</code>
</li><li>The database URL <code>jdbc:h2:~/test</code> opens the database <code>test</code> in your user home directory
32
</li><li>A new database is automatically created
33 34
</li></ul>

Thomas Mueller's avatar
Thomas Mueller committed
35
<h2 id="h2_console">The H2 Console Application</h2>
36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
<p>
The Console lets you access a SQL database using a browser interface.
<br />
<img src="images/console.png" alt="Web Browser - H2 Console Server - H2 Database" />
<br />
If you don't have Windows XP, or if something does not work as expected,
please see the detailed description in the <a href="tutorial.html">Tutorial</a>.
</p>

<h3>Step-by-Step</h3>

<h4>Installation</h4>
<p>
Install the software using the Windows Installer (if you did not yet do that).
</p>

<h4>Start the Console</h4>
<p>
54
Click [Start], [All Programs], [H2], and [H2 Console (Command Line)]:<br />
Thomas Mueller's avatar
Thomas Mueller committed
55
<img class="screenshot" src="images/quickstart-1.png" alt="Screenshot: start H2 Console" /><br />
56
A new console window appears:<br />
Thomas Mueller's avatar
Thomas Mueller committed
57
<img class="screenshot" src="images/quickstart-2.png" alt="Screenshot: H2 running" /><br />
58
Also, a new browser page should open with the URL <a href="http://localhost:8082" class="notranslate">http://localhost:8082</a>.
59 60 61 62 63 64
You may get a security warning from the firewall. If you don't want other computers in the network to access the database
on your machine, you can let the firewall block these connections. Only local connections are required at this time.
</p>

<h4>Login</h4>
<p>
65
Select [Generic H2] and click [Connect]:<br />
Thomas Mueller's avatar
Thomas Mueller committed
66
    <img class="screenshot" src="images/quickstart-3.png" alt="Screenshot: login" /><br />
67 68 69 70 71
    You are now logged in.
</p>

<h4>Sample</h4>
<p>
72
Click on the [Sample SQL Script]:<br />
Thomas Mueller's avatar
Thomas Mueller committed
73
    <img class="screenshot" src="images/quickstart-4.png" alt="Screenshot: click on the sample SQL script" /><br />
Thomas Mueller's avatar
Thomas Mueller committed
74
    The SQL commands appear in the command area.<br />
75 76 77 78
</p>

<h4>Execute</h4>
<p>
79
Click [Run]<br />
Thomas Mueller's avatar
Thomas Mueller committed
80
<img class="screenshot" src="images/quickstart-5.png" alt="Screenshot: click Run" /><br />
81 82
On the left side, a new entry TEST is added below the database icon.
The operations and results of the statements are shown below the script.<br />
Thomas Mueller's avatar
Thomas Mueller committed
83
<img class="screenshot" src="images/quickstart-6.png" alt="Screenshot: see the result" /><br />
84 85 86 87
</p>

<h4>Disconnect</h4>
<p>
88
Click on [Disconnect]:<br />
89
<img src="images/icon_disconnect.gif" alt="Disconnect icon" /><br />
90
to close the connection.
91 92 93 94 95 96 97 98 99 100
</p>

<h4>End</h4>
<p>
Close the console window.
For more information, see the <a href="tutorial.html">Tutorial</a>.
</p>

<!-- [close] { --></div></td></tr></table><!-- } --><!-- analytics --></body></html>