https://answers.axonivy.com/questions/1779/how-can-i-persist-a-file-as-blob<p>Hi,</p> <p>i am using the primefaces fileupload widget, so users can upload attatchment files. right now, i save the files on the filesystem and i persist the path to the file in the database.</p> <p>is there a way to save files as BLOB in relational database?</p> <p>Thank you for your answers!</p>enTue, 31 May 2016 12:59:23 -0400https://answers.axonivy.com/questions/1779/how-can-i-persist-a-file-as-blob/1787<p>Yes, it's possible, e.g. by using JPA (aka Ivy Persistence). You have to write the JPA class by yourself (instead of using the persistence editor) so that you can use the @Lob annotation on the field.</p> <p>BUT: If there is no real requirement (e.g. transaction support) to store files in the database, the filesystem is a good choice. It’s a common question, the question <a href="http://programmers.stackexchange.com/questions/150669/is-it-a-bad-practice-to-store-large-files-10-mb-in-a-database">is-it-a-bad-practice-to-store-large-files-10-mb-in-a-database</a> on stackexchange could help.</p>Flavio SadeghiTue, 31 May 2016 12:59:23 -0400https://answers.axonivy.com/questions/1779/how-can-i-persist-a-file-as-blob/1787