Thanks for the quick response Noel, that worked perfectly. Can't believe I 
missed it in the documentation.

On Friday, January 11, 2013 2:34:33 PM UTC, Noel Grandin wrote:
>
> 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]<javascript:>. 
>
> > To unsubscribe from this group, send email to 
> > [email protected] <javascript:>. 
> > 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 view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/ehy2pMzhDzAJ.
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