_docs_en.utf8.txt

非常棒的java数据库

@advanced_1276_td
A security vulnerability where an application generates SQL statements with embedded user input.  See also: <a href="http://en.wikipedia.org/wiki/SQL_injection">Wikipedia: SQL Injection</a>

@advanced_1277_td
Watermark Attack

@advanced_1278_td
Security problem of certain encryption programs where the existence of certain  data can be proven without decrypting.  For more information, search in the internet for 'watermark attack cryptoloop'

@advanced_1279_td
SSL/TLS

@advanced_1280_td
Secure Sockets Layer / Transport Layer Security.  See also: <a href="http://java.sun.com/products/jsse/">Java Secure Socket Extension (JSSE)</a>

@advanced_1281_td
XTEA

@advanced_1282_td
A block encryption algorithm.  See also: <a href="http://en.wikipedia.org/wiki/XTEA">Wikipedia: XTEA</a>

@build_1000_h1
Build

@build_1001_a
Portability

@build_1002_a
Environment

@build_1003_a
Building the Software

@build_1004_a
Using Maven 2

@build_1005_a
Translating

@build_1006_h2
Portability

@build_1007_p
This database is written in Java and therefore works on many platforms. It can also be compiled to a native executable using GCJ.

@build_1008_h2
Environment

@build_1009_p
A Java Runtime Environment (JRE) version 1.4 or higher is required to run this database.

@build_1010_p
To build the database executables, the following software stack was used. Newer version or compatible software works too.

@build_1011_li
Windows XP

@build_1012_li
Sun JDK Version 1.4

@build_1013_li
Apache Ant Version 1.6.5

@build_1014_li
Mozilla Firefox 1.5

@build_1015_li
Eclipse Version 3.2.2

@build_1016_li
YourKit Java Profiler

@build_1017_h2
Building the Software

@build_1018_p
On the command line, go to the directory src and execute the following command:

@build_1019_p
You will get a list of targets. If you want to build the jar files, execute:

@build_1020_p
To create a jar file with the JDBC API and the classes required to connect to a server only, use the target jarClient:

@build_1021_p
The other targets may be used as well.

@build_1022_h2
Using Maven 2

@build_1023_h3
Using a Central Repository

@build_1024_p
You can include the database in your Maven 2 project as a dependency. Example:

@build_1025_p
New versions of this database are first uploaded to http://hsql.sourceforge.net/m2-repo/ and then automatically synchronized with the main maven repository; however after a new release it may take a few hours before they are available there.

@build_1026_h3
Using Snapshot Version

@build_1027_p
To build a 'snapshot' H2 .jar file and upload it the to the local Maven 2 repository, execute the following command:

@build_1028_p
Afterwards, you can include the database in your Maven 2 project as a dependency:

@build_1029_h2
Translating

@build_1030_p
The translation of this software is split into the following parts:

@build_1031_li
H2 Console: src/main/org/h2/server/web/res/_text_*.properties

@build_1032_li
Error messages: src/main/org/h2/res/_messages_*.properties

@build_1033_li
Web site: src/docsrc/text/_docs_*.utf8.txt

@build_1034_p
The conversion between UTF-8 and Java encoding (using the \u syntax), as well as the HTML entities (&#..;) is automated by running the tool PropertiesToUTF8. The web site translation is automated as well, using <code>ant docs</code> .

@changelog_1000_h1
Change Log

@changelog_1001_h2
Next Version (unreleased)

@changelog_1002_li
Very large SELECT DISTINCT and UNION EXCEPT queries are now supported,  however this feature is disabled by default. To enable it, set  the system property h2.maxMemoryRowsDistinct to a lower value, for example 10000.

@changelog_1003_li
A error is now thrown when trying to call a method  inside a trigger that implicitly commits the current transaction,  if an object is locked.

@changelog_1004_li
Unused LOB files were deleted much too late.  Now they are deleted if no longer referenced in memory.

@changelog_1005_li
ALTER SEQUENCE and ALTER TABLE ALTER COLUMN RESTART can now be used inside a transaction.

@changelog_1006_li
New system property h2.aliasColumnName. When enabled, aliased columns  (as in SELECT ID AS I FROM TEST) return the real table and column name in  ResultSetMetaData.getTableName() and getColumnName(). This is disabled by  default for compatibility with other databases (HSQLDB, Apache Derby, PostgreSQL,  some version of MySQL). In version 1.1 this setting will be enabled.

@changelog_1007_li
When using encrypted databases, and using the wrong file password,  the log file was renamed if the database was not already open. Fixed.

@changelog_1008_li
Improved performance when using lob files in directories  (however this is still disabled by default)

@changelog_1009_li
H2 Console: autocomplete didn't work with very large scripts. Fixed.

@changelog_1010_li
Fulltext search: new method SEARCH_DATA that returns the column  names and primary keys as arrays.

@changelog_1011_li
New experimental optimization for GROUP BY queries if an index can be used  that matches the group by columns. To enable this optimization, set the system  property h2.optimizeGroupSorted to true.

@changelog_1012_li
When using multi-version concurrency (MVCC=TRUE), duplicate rows could appear in the result set when running queries  with uncommitted changes in the same session.

@changelog_1013_li
H2 Console: remote connections were very slow because getHostName/getRemoteHost was used.  Fixed (now using getHostAddress/getRemoteAddr.

@changelog_1014_li
H2 Console: on Linux, Firefox, Konqueror, or Opera (in this order) are now started if available.  This has been tested on Ubuntu.

@changelog_1015_li
H2 Console: the start window works better with IKVM

@changelog_1016_li
H2 Console: improved compatibility with Safari (Safari requires keep-alive)

@changelog_1017_li
Random: the process didn't stop if generating the random seed using the standard  way (SecureRandom.generateSeed) was very slow. Now using a daemon thread  to avoid this problem.

@changelog_1018_li
SELECT UNION with a different number of ORDER BY columns did throw an ArrayIndexOutOfBoundsException.

@changelog_1019_li
When using a view, the column precision was changed to the default scale for some data types.

@changelog_1020_li
CSVWRITE now supports a 'null string' that is used for parsing and writing NULL.

@changelog_1021_li
Some long running queries could not be cancelled.

@changelog_1022_li
Queries with many outer join tables were very slow. Fixed.

@changelog_1023_li
The performance of text comparison has been improved when using locale sensitive  string comparison (SET COLLATOR). Now CollationKey is used with a LRU cache.  The default cache size is 10000, and can be changed using the system property  h2.collatorCacheSize. Use 0 to disable the cache.

@changelog_1024_li
UPDATE SET column=DEFAULT is now supported.

@changelog_1025_h2
Version 1.0.67 (2008-02-22)

@changelog_1026_li
New function FILE_READ to read a file or from an URL. Both binary and text data is supported.

@changelog_1027_li
CREATE TABLE AS SELECT now supports specifying the column list and data types.

@changelog_1028_li
Connecting to a TCP server and at shutting it down at the same time could cause a Java level deadlock.

@changelog_1029_li
A user now has all rights on his own local temporary tables.

@changelog_1030_li
The CSV tool now supports a custom lineSeparator.

@changelog_1031_li
When using multiple connections, empty space was reused too early sometimes. This could corrupt the database when recovering.

@changelog_1032_li
The H2 Console has been translated to Dutch. Thanks a lot to Remco Schoen!

@changelog_1033_li
Databases can now be opened even if trigger classes are not in the classpath. The exception is thrown when trying to fire the trigger.

@changelog_1034_li
Opening databases with ACCESS_MODE_DATA=r is now supported. In this case the database is read-only, but the files don't not need to be read-only.

@changelog_1035_li
Security: The database now waits 200 ms before throwing an exception if the user name or password don't match, to slow down dictionary attacks.

@changelog_1036_li
The value cache is now a soft reference cache. This should help save memory.

@changelog_1037_li
CREATE INDEX on a table with many rows could run out of memory. Fixed.

@changelog_1038_li
Large result sets are now a bit faster.

@changelog_1039_li
ALTER TABLE ALTER COLUMN RESTART and ALTER SEQUENCE now support parameters (any expressions).

@changelog_1040_li
When setting the base directory on the command line, the user directory prefix ('~') was ignored.

@changelog_1041_li
The DbStarter servlet didn't start the TCP listener even if configured.

@changelog_1042_li
Statement.setQueryTimeout() is now supported.

@changelog_1043_li
New session setting QUERY_TIMEOUT, and new system property h2.maxQueryTimeout.

@changelog_1044_li
Changing the transaction log level (SET LOG) is now written to the trace file by default.

@changelog_1045_li
In a SQL script, primary key constraints are now ordered before foreign key constraints.

@changelog_1046_li
It was not possible to create a referential constraint to a table in a different schema in some situations.

@changelog_1047_li
The H2 Console was slow when the database contains many tables. Now the column names are not shown in this case.

@changelog_1048_h2
Version 1.0.66 (2008-02-02)

@changelog_1049_li
There is a new online error analyzer tool.