Blaine Simpson wrote:
> Read step 4 of "Init script Setup Procedure" in the UNIX Quick Start 
> chapter of the
> HSQLDB User Guide.
> 

Well, quick and accurate. Thank you!
Now my configuration looks like this:

server.properties
-----
server.database.0=file:/var/lib/hsqldb/db1
server.urlid.0=localhost

server.database.1=file:/var/lib/hsqldb/jdo/jdo
server.dbname.1=jdo
server.urlid.1=jdo
-----

sqltool.rc
-----
urlid localhost
url jdbc:hsqldb:hsql://localhost
username sa
password

urlid jdo
url jdbc:hsqldb:hsql://localhost/jdo
username sa
password
-----

and the server displays notifications about starting two instances,
'localhost' and 'jdo' both upon start and shutdown. Oh, joy!

IIRC I've really tried to put the offending line "server.urlid.1=jdo"
in 'server.properties' file. But now I recall that at the same time
I've never put the "urlid jdo" section in the 'sqltool.rc' file...

Now, after I've made both changes I don't really have to fix anything.
So, my work is done. :-)


But I'd like to point out WHY did this happen. I skipped reading the
"UNIX Quick Start" and read only "Advanced Topics" instead. If you
look in the page:

http://hsqldb.org/doc/guide/ch04.html

there is a "Table 4.1. Hsqldb URL Components" with examples from
the 'server.properties' (on the grey background).
There is no warning, nor _any_ "server.urlid.X=..." line.
Should this example had such "server.urlid" entries, I wouldn't
bother you probably at all, because I'd assume that they are
needed (as it really is).

Even better, putting a yellow "Important" or red "Warning" box
below with explanation why "server.urlid" is required (preferably
with a link to the "UNIX Quick Start") would shorten the time
I needed to resolve this problem.

My suggestion is to improve that part of hsqldb documentation,
for the good of all users. This way such issues would be reduced
to the minimum in the future.

Note:
After using Gentoo for several years I may say that I know that
reading the fine documentation is best. This time I've just read
a wrong part of it (or missed the important part maybe).
Of course This Should Never Happen (TM). But still.

Thanks again for your time and valuable help!

Best regards,
Wiktor Wandachowicz


Registered Linux user #390131 (http://counter.li.org)


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers

Reply via email to