Hi,
You didn't tell us the database URL you use, but it looks like you use
NIO, something like jdbc:h2:nioMapped:~/test.
When using the "nioMapped:" prefix, files larger than 2 GB are not
supported currently. This is not well documented (the only place it is
documented is FileObjectDiskMapped.jav
Hi,
> I was running my app overnight using 1.2.138 and came back to it to
> see a bunch of errors that say "Timeout Trying to lock table".
Did you also see other error message in the .trace.db file?
Using MVCC usually solves such problems, but I wonder why you need to
use transactions that longe
On Jun 24, 5:37 pm, Thomas Mueller
wrote:
> Hi,
>
> > Unfortunately the database is continously growing
>
> Is just the database file growing (the .h2.db file), or is the
> directory .lobs.db growing, or both?
Thats the interesting part. h2.db is growing. There is no .logb.db. I
didnt set h2.lo
And here the output of the SCRIPT TO
SCRIPT
-
SET CLUSTER
'';
SET
Hi,
Could you run the "Recover" tool against your database and send the
result, or (even better) send or upload the database file somewhere so
I can analyze it?
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this gro
I also did some more experiments playing with the lob-settings.
System.setProperty("h2.defaultMaxLengthInplaceLob", "512");
This forces the system to write the lobs dir - my messages really are
smaller then the 4k default.
The behaviour is like this:
- h2.db still grows, of course much smaller
Hi,
> I want to create this predefined schema and data
> using some visual tool
H2 doesn't come with such a tool, but there are many tools available,
for example DbVisualizer: http://www.dbvis.com/ - for other tools see
http://h2database.com/html/links.html "Database Frontends / Tools".
Missing o
Hi,
> Perhaps there is some transaction log
> somewhere which doesnt get ever cleaned out ?
It sounds like. Could you run the "Recover" tool against your database
(when it's about 10 MB big or so) and send the result, or (even
better) send or upload the database file somewhere so I can analyze
it
Hi,
> Not exactly sure what you are aiming for, but how about javascript? That's
> already written and understood with lots of research going into JIT
> interpreters for it.
Yes. There is a "Scripting Engine" (javax.script) binding for
JavaScript in Java 6. There are a few disadvantages: it req
Hi Thomas,
The URL we're using is jdbc:h2:nioMapped:${jboss.server.data.dir}${/}
h2${/}
localDB;LOCK_MODE=3;CACHE_SIZE=262144;TRACE_LEVEL_FILE=0;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE.
We're using nioMapped because it had the best performance in our
tests.
However, the problem here is that we've got th
Sure,
Here you go:
http://www.vegh.ch/abamessagingserver.h2.zip
I killed my server after two testruns, so the autocompact didnt run
after a regular shutdown.
I am glad you are looking into this !
Thanks
Alex
On Jul 2, 11:48 am, Thomas Mueller
wrote:
> Hi,
>
> > Perhaps there is some transact
Hi,
> Could you please clarify real behavior of SCRIPT statement with MVCC mode as
> well. Is it a
> mistake in the roadmap and in fact SCRIPT statment provides transactionally
> consistent backup?
Yes, the SCRIPT statement does provide a transactionally consistent
backup. I have removed this e
Hi,
I don't know what the problem could be... Could you possibly debug the
application and find out what "paramInt" is when the error occurs?
Just set a breakpoint on the line "throw new
IllegalArgumentException()".
Regards,
Thomas
--
You received this message because you are subscribed to the
For what it's worth, I too just edit text files.
Visual tools tend to ignore things like source control, and are lousy at
doing "diffs" between versions of a single database.
On Fri, Jul 2, 2010 at 9:42 PM, Thomas Mueller wrote:
> Hi,
>
> > I want to create this predefined schema and data
> > u
I have no idea. However, with a little extra work you could set it up such that
the feature is available on 1.6 but not on earlier versions. Personally, I
wouldn't think that is unreasonable. If it is one's choice to live on legacy
software then he must accept that there are prices to pay for t
Hi. I was looking through and trying to access ConnectionInfo class
source code from my own application codes and noticed that there was
this "Properties info" parameter. I wasn't sure what to put in the
"info" parameter and just put "null" in it and it the system threw me
a "SEVERE: null" error. W
How do I get the "info" parameter if I have a JDBC url ?
On Jul 3, 11:52 am, Thotheolh wrote:
> Hi. I was looking through and trying to access ConnectionInfo class
> source code from my own application codes and noticed that there was
> this "Properties info" parameter. I wasn't sure what to put
I felt that what we need is just a standalone official "migrate.jar"
or a compact package of tools downloadable on the H2 website. As long
as the H2 file storage format doesn't change, then the migrate tool
would not be updated and allow cross migration between different
formats of H2 storage if ev
On Thu, Jul 1, 2010 at 10:23 PM, Thomas Mueller
wrote:
> Hi,
>
>> For some obscure reason the 2d-indexing (getMultiDimensionResult,
>> interleave,...)
>> only accept positive numbers.
>
> How could this be fixed? One solution is to "normalize" the values so
> that they are between 0 and the maximu
19 matches
Mail list logo