Re: [Hsqldb-user] HSQL database size limit reached

[Fred T. <fr...@us...>]

Your 'solution' will cause database corruption if you start modifying
the data!

Large data is not supported in 2.2.8. You must use 2.2.9 or later.

Fred

On Thu, Nov 22, 2012, at 14:05, Guillaume Eynard Bontemps wrote:

  Thank you for the answer.



I use a solution a little bit more complicated to open the database. I
got the source of hsqldb 2.2.8, modified the class DataFileCache.java
that was causing the problem, by increasing the default maximum size
limit. Then I rebuild the hsqldb jar, adding the newly compiled class
instead of the old one. With this new jar, I was able to open my
database.

2012/11/22 Fred Toussi <[1]fr...@us...>

  Large Data support has been introduced in the latest version and
  allows
  the .data file to grow to 128 times the default maximum.
  If you use version 2.2.9, or the latest jar snapshot, it should open
  this database. Also see the Guide on the hsqldb.large_data property,
  which you can before the database reaches the default limit.
  Fred
  > I'm working with version 2.2.8. I just hit a problem I wasn't
  aware of,
  > a size limitation of the database, which seems to be 16GB in my
  version
  > of the software. I checked into the script file of the database,
  and I
  > have the files size parameter set to 8, so this is matching with
  what is
  > told into the documentation.
  --------------------------------------------------------------------
  ----------
  Monitor your physical, virtual and cloud infrastructure from a
  single
  web console. Get in-depth insight into apps, servers, databases,
  vmware,
  SAP, cloud infrastructure, etc. Download 30-day Free Trial.
  Pricing starts from $795 for 25 servers or applications!
  [2]http://p.sf.net/sfu/zoho_dev2dev_nov
  _______________________________________________
  Hsqldb-user mailing list
  [3]Hsq...@li...
  [4]https://lists.sourceforge.net/lists/listinfo/hsqldb-user

-----------------------------------------------------------------------
-------

Monitor your physical, virtual and cloud infrastructure from a single

web console. Get in-depth insight into apps, servers, databases,
vmware,

SAP, cloud infrastructure, etc. Download 30-day Free Trial.

Pricing starts from $795 for 25 servers or applications!

[5]http://p.sf.net/sfu/zoho_dev2dev_nov

_______________________________________________

Hsqldb-user mailing list

[6]Hsq...@li...

[7]https://lists.sourceforge.net/lists/listinfo/hsqldb-user

References

1. mailto:fr...@us...
2. http://p.sf.net/sfu/zoho_dev2dev_nov
3. mailto:Hsq...@li...
4. https://lists.sourceforge.net/lists/listinfo/hsqldb-user
5. http://p.sf.net/sfu/zoho_dev2dev_nov
6. mailto:Hsq...@li...
7. https://lists.sourceforge.net/lists/listinfo/hsqldb-user