Hi, > I'm not sure, but I believe if the object is no longer referenced in > memory, the file will be deleted.
I delete some records (each of those record have image file) then issue commit but lob files are not deleted even after I close my application using System.exit(0). So no references to files, I hope ! Files are deleted only after I dis-connect DB from H2 web console. I do not perform any modifications in web console, but only view (to check) records. > Did you try the system property "h2.lobInDatabase"? Even in this case, > space is not immediately freed (the database file doesn't shrink > immediately), but free disk space is immediately re-used. I have not set any property. Blob data contains around 20/50k Images, so not keeping in database. I am less bothered about database shrink for now but disk space. I am using Windows XP SP3, if that is of any help. Thanks and warm regards, Nitin -- 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.
