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.

Reply via email to