Various documentation errors

[GoogleCodeExporter]

1. In the "Tutorial" page, at some point it is claimed that a file 
called .h2.server.properties is created in the user's home upon server 
start. That's not the case, at least not on Linux, with solely the TCP 
server started.

2. In the "Advanced Topics" page, there's a ;ist of properties that can 
be set as Java system properties (via -D). Among them 
is "h2.runFinalizers", but running "SELECT * FROM 
INFORMATION_SCHEMA.SETTINGS" tells something about "h2.runFinalize".

3. The documentation should state very clearly which settings are 
specific to the server (org.h2.tools.Server command line), which of them 
apply to a database, which of them apply to the first connection to a 
database and which of them apply to any connection.
Also, please make it clear whether the property names and values are case 
sensitive or not (in which cases).

4. Could you add some cross links between the Google H2 groups and the 
Google H2 project home? It would be very helpful since these facilities 
are not integrated unfortunately.

Thanks.

Original issue reported on code.google.com by sulf...@gmail.com on 20 Nov 2007 at 10:09

[GoogleCodeExporter]

Original comment by thomas.t...@gmail.com on 20 Nov 2007 at 10:48

• Changed state: Accepted
• Added labels: Priority-High
• Removed labels: Priority-Medium

[GoogleCodeExporter]

1. 
The .h2.server.properties is currently only used for the Console. However, at 
some
later time, it may contain other settings as well. To avoid invalidating the 
Japanese
translation I will keep the documentation at the moment. I don't think it's 
'wrong'
because it's under the topic 'Starting and Using the H2 Console'.

2. 
Thanks! Will be fixed in the next release

3. 
The command line settings are a bit confusing, if possible I like to simplify 
things
but not sure how.

> The documentation should state very clearly which settings are 
> specific to the server (org.h2.tools.Server command line), 
I did that now.

> which of them apply to a database, 
Not sure what you mean here.

> which of them apply to the first connection to a database 
None. Not sure what you mean here.

> and which of them apply to any connection.
All. Not sure what you mean here.

> Also, please make it clear whether the property names and values are case 
sensitive or not (in which cases).

All are case sensitive. I added that to the docs.

Original comment by thomas.t...@gmail.com on 21 Nov 2007 at 9:08

[GoogleCodeExporter]

> 4. Could you add some cross links between the Google H2 groups and the 
Google H2 project home?

I'm not sure yet if people should really file bug reports. I think having one 
central
communication port is simpler. However it may make sense if I file bug reports 
so
that people easier understand open issues.

Is there a way to get notification about new bugs files here? I couldn't find 
it yet.

Original comment by thomas.t...@gmail.com on 21 Nov 2007 at 9:10

• Changed state: Fixed

[GoogleCodeExporter]

> Is there a way to get notification about new bugs files here? I couldn't find 
it 
yet.
I don't know either since I never owned a project on Google.

About the settings types:
By settings that apply to the database vs. connections, I'm actually referring 
to 
their scope: if a setting is persisted in the database then it will act on all 
connections, thus applies to the database (conceptually). 

Example of a setting that applies to the first connection to a database: 
IFEXISTS.

Original comment by sulf...@gmail.com on 22 Nov 2007 at 5:43