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 that error with a ~50MB
file. We have a process getting the messages from JMS constantly, so
the file never grows so much.
Right now I have a machine using version 1.2.138 to test (I've saw
that there were changes in the code of the classes that appear in that
stack). So tell me if there's more info that I could give you to fix
this.
Thanks for the help!
On Jul 2, 9:40 am, Thomas Mueller <[email protected]>
wrote:
> 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.java, "// TODO support files over 2
> GB by using multiple buffers"). You should get an error message "File
> over 2GB is not supported yet", but it seems this mechanism is also
> not working as expected. I will try to better document it and make
> sure it throws a better error message.
>
> I suggest to try without using the "nioMapped:" prefix. I don't think
> this will slow down processing for large files; please tell us if it
> does. An alternative is to use the "split" file system in addition to
> "nioMapped". The database URL would then be
> jdbc:h2:split:nioMapped:~/test - see
> alsohttp://h2database.com/html/advanced.html#file_system- or use "nio:"
> instead.
>
> New documentation: nioMapped: file system that uses memory mapped
> files (faster in some operating systems). Please note that there
> currently is a file size limitation of 2 GB when using this file
> system. To work around this limitation, combine it with the split file
> system: split:nioMapped:test
>
> Regards,
> Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
