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.
