Skip to content

H
h2database
切换分支/标签
查找文件
Normal viewHistoryPermalink
faq.html 6.3 KB
Newer Older
Thomas Mueller's avatar
--no commit message
35e27cd5
 
Thomas Mueller committed
1 2 3 
<?xml version="1.0"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
Thomas Mueller's avatar
--no commit message
483d9103
 
Thomas Mueller committed
4 
Copyright 2004-2007 H2 Group. Licensed under the H2 License, Version 1.0 (http://h2database.com/html/license.html).
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
5 6 
Initial Developer: H2 Group
-->
Thomas Mueller's avatar
--no commit message
35e27cd5
 
Thomas Mueller committed
7 8 
<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>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
9 
Frequently Asked Questions
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
10 
</title><link rel="stylesheet" type="text/css" href="stylesheet.css" />
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
11 12 13 14 15 16 
<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>Frequently Asked Questions</h1>
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 
<a href="#known_bugs">
    Are there any known bugs? When is the next release?</a><br />
<a href="#open_source">
    Is this Database Engine Open Source?</a><br />
<a href="#query_slow">
    My query is slow</a><br />
<a href="#create_database">
    How to Create a New Database?</a><br />
<a href="#connect">
    How to Connect to a Database?</a><br />
<a href="#database_files">
    Where are the Database Files Stored?</a><br />
<a href="#size_limit">
    What is the Size Limit (maximum size) of a Database?</a><br />
<a href="#reliable">
    Is it Reliable?</a><br />
<a href="#gcj">
Thomas Mueller's avatar
--no commit message
b09fd536
 
Thomas Mueller committed
34 
    Is the GCJ version stable? Faster?</a><br />
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
35 36 

<br /><a name="known_bugs"></a>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
37 
<h3>Are there any known bugs? When is the next release?</h3>
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
38 
<p>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
39 40 
Usually, bugs get fixes as they are found. There is a release every few weeks.
Here is the list of known and confirmed issues as of
Thomas Mueller's avatar
--no commit message
0be76a43
 
Thomas Mueller committed
41 
2007-08-02:
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
42 
</p>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
43 
<ul>
Thomas Mueller's avatar
--no commit message
0be76a43
 
Thomas Mueller committed
44 45 
<li>Some problems have been found with right outer join. Internally, it is converted to left outer join, which
    does not always produce the same results as other databases when used in combination with other joins.
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
46 
</li></ul>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
47
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
48 
<br /><a name="open_source"></a>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
49 
<h3>Is this Database Engine Open Source?</h3>
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
50 
<p>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
51 52 
Yes. It is free to use and distribute, and the source code is included.
See also under license.
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
53 
</p>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
54
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
55 56 57 58 59 60 61 62 63 
<br /><a name="query_slow"></a>
<h3>My query is slow</h3>
<p>
Slow SELECT (or DELETE, UPDATE, MERGE) statement can have multiple reasons.
Follow this checklist:
</p>
<ul>
<li>Run ANALYSE (see documentation for details).
</li><li>Run the query with EXPLAIN and check if indexes are used (see documentation for details).
Thomas Mueller's avatar
--no commit message
b09fd536
 
Thomas Mueller committed
64 
</li><li>If required, create additional indexes and try again using ANALYZE and EXPLAIN.
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 
</li><li>If it doesn't help please report the problem. 
</li>
</ul>

<br /><a name="create_database"></a>
<h3>How to Create a New Database?</h3>
<p>
By default, a new database is automatically created if it does not yet exist.
</p>

<br /><a name="connect"></a>
<h3>How to Connect to a Database?</h3>
<p>
The database driver is <code>org.h2.Driver</code>,
and the database URL starts with <code>jdbc:h2:</code>.
To connect to a database using JDBC, use the following code:
</p>
<pre>
Class.forName("org.h2.Driver");
Thomas Mueller's avatar
--no commit message
1b68cfa3
 
Thomas Mueller committed
84 
Connection conn = DriverManager.getConnection("jdbc:h2:~/test", "sa", "");
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
85 
</pre>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
86
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
87 88 89 
<br /><a name="database_files"></a>
<h3>Where are the Database Files Stored?</h3>
<p>
Thomas Mueller's avatar
--no commit message
1b68cfa3
 
Thomas Mueller committed
90 91 92 
When using database URLs like jdbc:h2:~/test, the database is stored in the user directory.
For Windows, this is usually C:\Documents and Settings\&lt;userName&gt;.
If the base directory is not set (as in jdbc:h2:test), the database files are stored in the directory where the application is started
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
93 94 95 96 97 98 99 100 101 102 103 104 105 
(the current working directory). When using the H2 Console application from the start menu, this is [Installation Directory]/bin.
The base directory can be set in the database URL. A fixed or relative path can be used. When using the URL
jdbc:h2:file:data/sample, the database is stored in the directory data (relative to the current working directory).
The directory must exist. It is also possible to use the fully qualified directory (and for Windows, drive) name.
Example: jdbc:h2:file:C:/data/test
</p>

<br /><a name="size_limit"></a>
<h3>What is the Size Limit (maximum size) of a Database?</h3>
<p>
The theoretical limit is currently 256 GB for the data. This number is excluding BLOB and CLOB data:
Every CLOB or BLOB can be up to 256 GB as well. The size limit of the index data is 256 GB as well.
</p>
Thomas Mueller's avatar
--no commit message
32b6da0e
 
Thomas Mueller committed
106 107 108 109 
<p>
The maximum file size for FAT or FAT32 file systems is 4 GB. So if you use FAT or FAT32, the 
limit is 4 GB for the data. 
</p>
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
110 111 

<br /><a name="reliable"></a>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
112 
<h3>Is it Reliable?</h3>
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
113 
<p>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
114 115 116 117 
That is not easy to say. It is still a quite new product. A lot of tests have been written,
and the code coverage of these tests is very high. Randomized stress tests
are run regularly. But as this is a relatively new product, there are probably
some problems that have not yet been found.
Thomas Mueller's avatar
--no commit message
4fc52e91
 
Thomas Mueller committed
118 
Areas that are not 100% tested:
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
119 
</p>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
120 
<ul>
Thomas Mueller's avatar
--no commit message
4fc52e91
 
Thomas Mueller committed
121 
<li>Platforms other than Windows XP and the Sun JVM 1.4 and 1.5
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
122 123 124 125 126 127 128 129 130 131 132 133 
</li><li>Data types BLOB, CLOB, VARCHAR_IGNORECASE, OTHER
</li><li>Cluster mode, 2-Phase Commit, Savepoints
</li><li>Server mode (well tested, but not as well as Embedded mode)
</li><li>Multi-Threading and using multiple connections
</li><li>Updatable result sets
</li><li>Referential integrity and check constraints, Triggers
</li><li>ALTER TABLE statements, Views, Linked Tables, Schema, UNION
</li><li>Not all built-in functions are completely tested
</li><li>The Optimizer may not always select the best plan
</li><li>24/7 operation and large databases (500 MB and up)
</li><li>Wide indexes with large VARCHAR or VARBINARY columns and / or with a lot of columns
</li></ul>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
134
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
135 
<p>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
136 
Areas considered Experimental:
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
137 
</p>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
138 139 
<ul>
<li>ODBC driver and the GCJ native version on Windows
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
140 141 
</li><li>Linear Hash Index
</li><li>Compatibility modes for other databases (only some features are implemented)
Thomas Mueller's avatar
--no commit message
d536591a
 
Thomas Mueller committed
142 
</li><li>The ARRAY data type and related functionality.
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
143 
</li></ul>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
144
Thomas Mueller's avatar
--no commit message
cd697858
 
Thomas Mueller committed
145 146 147 148 149 150 151 152 153 
<br /><a name="gcj"></a>
<h3>Is the GCJ version stable? Faster?</h3>
<p>
The GCJ version is not as stable as the Java version.
When running the regression test with the GCJ version, sometimes the application just stops
at what seems to be a random point without error message.
Currently, the GCJ version is also slower than when using the Sun VM.
However, the startup of the GCJ version is faster than when using a VM.
</p>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
154 155 

</div></td></tr></table></body></html>