I deployed JForum war to my Tomcat server. During the first run, I installed the hsqldb database successfully. With severl tries, I found a bug and I wanted to see what got stored in the database. So, I tried to locate the hsqldb database file.
It's very strange to me that I could see the created hsqldb database files except the major one, the .data file. The .lck, .log and .properties are there. Can any one tell me where the .data file go?
Thanks in advance!
Michael Wu [originally posted on jforum.net by michaelwu]
FYI, HSQLDB works in a rather interesting fashion. Rather than storing the raw data on disk, it stores the scripts to recreate the database. So you're unlikely to find much more than very large script and log files at any given time. [originally posted on jforum.net by jbanes]
michaelwu wrote:But, it's really strange for me that hsqldb takes this approach. In the long run, when the database grows to certain size, restart the database may take some time!
Don't worry, you're not the only one shocked by this design. ;)
It's actually a very good design for an embedded database. It simply doesn't scale to enterprise usage. Which is why it's important to keep in mind that HSQLDB is an embedded database. It will work for testing and small forums, but it's best not to deploy it on a busy forum. 8) [originally posted on jforum.net by jbanes]
There's a hole in the bucket, dear Liza, dear Liza, a hole in the bucket, dear liza, a tiny ad: