If you want your LOB's to be stored outside the DB file, you need to set
the system property
-Dh2.lobInDatabase=false
which you'll need to put on the command line startup up the database.
On 2013-01-11 16:22, Matt Kelly wrote:
Hi,
I have a table which stores image files in BLOBs. No matter what I
try, the data is always stored in place. I have tried column types
BLOB and BLOB(100000000), and I have set MAX_LENGTH_INPLACE_LOB to
256. Originally the column was just BLOB but I wondered whether what
causes them to be placed in separate files is the explicit precision
of the type rather than the actual size of the value, hence changing
it to 100000000. Since this is clearly greater than 256 all of them
should be stored separately but this is not what's happening. I'm
assuming that the BLOB precision and MAX_LENGTH_INPLACE_LOB are both
in bytes, is that correct? Is there something I'm missing here? I did
wonder if perhaps the DB would only start to store BLOBs in separate
files if its total size had exceeded some threshold but I can't find
anything about this in the documentation.
Thinking that there was something wrong with the DB, I created a new
one using the H2 console. I created a table with a primary key and a
BLOB(100000000), set MAX_LENGTH_INPLACE_LOB to 256 and inserted a
693KB JPEG using FILE_READ. I then inserted a 4.27MB PNG with the same
approach. Both images were stored in place.
Here is my DB URL: jdbc:h2:[the path] --
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/T40MT4tSne8J.
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.
--
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.