[prev in list] [next in list] [prev in thread] [next in thread]
List: hsqldb-user
Subject: Re: [Hsqldb-user] HSQL database size limit reached
From: Guillaume Eynard Bontemps <g.eynard.bontemps () gmail ! com>
Date: 2012-11-22 14:25:32
Message-ID: CAH9L9AB71bt8p_GZh=v+T-QE65-weHnOC9JjL3vgRouMHzriEw () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Ok thanks for the advice, I actually just needed to open the database to
see what was inside. But I will use the version 2.2.9 of HSQL from now.
2012/11/22 Fred Toussi <fredt@users.sourceforge.net>
> 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 <fredt@users.sourceforge.net>
>
> 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!
> http://p.sf.net/sfu/zoho_dev2dev_nov
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@lists.sourceforge.net
> 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!
> http://p.sf.net/sfu/zoho_dev2dev_nov
> *_______________________________________________*
> Hsqldb-user mailing list
> Hsqldb-user@lists.sourceforge.net
> 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!
> http://p.sf.net/sfu/zoho_dev2dev_nov
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>
[Attachment #5 (text/html)]
Ok thanks for the advice, I actually just needed to open the database to see what was \
inside. But I will use the version 2.2.9 of HSQL from now.<div \
class="gmail_extra"><br><br><div class="gmail_quote">2012/11/22 Fred Toussi <span \
dir="ltr"><<a href="mailto:fredt@users.sourceforge.net" \
target="_blank">fredt@users.sourceforge.net</a>></span><br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> <div><div style="font-family:Arial;font-size:medium" \
dir="ltr"><div> <div>
<div>
Your 'solution' will cause database corruption if you start modifying the \
data!</div> <div>
</div>
<div>
Large data is not supported in 2.2.8. You must use 2.2.9 or later.</div><span \
class="HOEnZb"><font color="#888888"> <div>
</div>
<div>
Fred</div></font></span><div><div class="h5">
<div>
</div>
<div>
On Thu, Nov 22, 2012, at 14:05, Guillaume Eynard Bontemps wrote:</div>
<blockquote type="cite">
Thank you for the answer.
<div>
</div>
<div>
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.</div>
<div>
<br>
<br>
<div>
2012/11/22 Fred Toussi <span dir="ltr"><<a \
href="mailto:fredt@users.sourceforge.net" \
target="_blank">fredt@users.sourceforge.net</a>></span><br>
<blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">
Large Data support has been introduced in the latest version and allows<br>
the .data file to grow to 128 times the default maximum.<br>
<br>
If you use version 2.2.9, or the latest jar snapshot, it should open<br>
this database. Also see the Guide on the hsqldb.large_data property,<br>
which you can before the database reaches the default limit.<br>
<br>
Fred<br>
<br>
> I'm working with version 2.2.8. I just hit a problem I wasn't \
aware of,<br>
> a size limitation of the database, which seems to be 16GB in my \
version<br>
> of the software. I checked into the script file of the database, and I<br>
> have the files size parameter set to 8, so this is matching with what \
is<br> > told into the documentation.<br>
<br>
------------------------------------------------------------------------------<br>
Monitor your physical, virtual and cloud infrastructure from a single<br>
web console. Get in-depth insight into apps, servers, databases, vmware,<br>
SAP, cloud infrastructure, etc. Download 30-day Free Trial.<br>
Pricing starts from $795 for 25 servers or applications!<br>
<a href="http://p.sf.net/sfu/zoho_dev2dev_nov" \
target="_blank">http://p.sf.net/sfu/zoho_dev2dev_nov</a><br> \
_______________________________________________<br> Hsqldb-user mailing list<br>
<a href="mailto:Hsqldb-user@lists.sourceforge.net" \
target="_blank">Hsqldb-user@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/hsqldb-user" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/hsqldb-user</a></blockquote>
</div>
</div>
<div>
------------------------------------------------------------------------------</div>
<div>
Monitor your physical, virtual and cloud infrastructure from a single</div>
<div>
web console. Get in-depth insight into apps, servers, databases, vmware,</div>
<div>
SAP, cloud infrastructure, etc. Download 30-day Free Trial.</div>
<div>
Pricing starts from $795 for 25 servers or applications!</div>
<div>
<a href="http://p.sf.net/sfu/zoho_dev2dev_nov" \
target="_blank">http://p.sf.net/sfu/zoho_dev2dev_nov</a></div> <div>
<u>_______________________________________________</u></div>
<div>
Hsqldb-user mailing list</div>
<div>
<a href="mailto:Hsqldb-user@lists.sourceforge.net" \
target="_blank">Hsqldb-user@lists.sourceforge.net</a></div> <div>
<a href="https://lists.sourceforge.net/lists/listinfo/hsqldb-user" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/hsqldb-user</a></div> \
</blockquote> </div></div></div>
</div>
<div>
</div>
</div></div><br>------------------------------------------------------------------------------<br>
Monitor your physical, virtual and cloud infrastructure from a single<br>
web console. Get in-depth insight into apps, servers, databases, vmware,<br>
SAP, cloud infrastructure, etc. Download 30-day Free Trial.<br>
Pricing starts from $795 for 25 servers or applications!<br>
<a href="http://p.sf.net/sfu/zoho_dev2dev_nov" \
target="_blank">http://p.sf.net/sfu/zoho_dev2dev_nov</a><br>_______________________________________________<br>
Hsqldb-user mailing list<br>
<a href="mailto:Hsqldb-user@lists.sourceforge.net">Hsqldb-user@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/hsqldb-user" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/hsqldb-user</a><br> \
<br></blockquote></div><br></div>
------------------------------------------------------------------------------
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!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic