Hi, I saw an old post about the poor state of XA support in H2. I'm only interested in XA because I'd like to commit changes to the database and file-system atomically using H2 and XADisk: http://xadisk.java.net/
Back in the day I tried storing files directly in the database in the form of BLOB. All of them (I believe H2 included) loaded the entire BLOB into memory even when I requested a small sub-section of the file. Inevitably this lead to OutOfMemoryError. Thomas, can you please comment on the state of BLOB and XA today? Does H2 load an entire BLOB into memory or does it respect requests to only load a small subsection at a time? Another reason I think it might make sense to store files outside of the database is that I believe it reduces the probability of losing data. If all files are stored in the database and some sort of corruption occurs I risk losing all files. If binaries are stored outside the DB, I'm more likely to be able to recover files (and it's easier to do so than running a database recovery tool). What are your thoughts on this? Thanks, Gili -- 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.
