You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

Tutorial Project and Screencast

I have created a small tutorial video to describe the simplest configurations of ERAttachment framework. Hopefully once you get your feet wet, the additional configurations possible won't be so daunting. See the Official ERAttachment Package Summary/Overview

The tutorial video refers to the following application that demonstrates how to use the ERAttachment Framework to store a Person entity's photo.

Oracle and ERAttachment Table Creation

If you are using Oracle with ERAttachment, the table creation will fail because one of the attributes is called "size" and this is a reserved word in Oracle DB. To fix that problem, add this to your Properties :


If you want to use ERAttachment without using ERXApplication, you need to register the request handler in your Application class with :


MySQL and ERAttachmentData BLOB size

The prototype for is 'blob', and the blob proto for MySQL is BLOB when it should really be LONGBLOB. In MySQL a BLOB is on 65K+, a MEDIUMBLOB is up to 64MB and a LONGBLOB is up to 4GB. FrontBase, for example, has only one type, BLOB for binary large objects and it is defined as 4GB (4^32 bytes). So if you don't want to think about it, then use LONGBLOB in MySQL. If you want to limit the size of what someone can upload and 64MB is the biggest attachment you ever want to be accepted into the database, use MEDIUMBLOB.

Changing the migration-generated tables is easy, for example:




Meanwhile, when this patch gets applied, new users of blob prototype for new table SQL generation will be saved anguish and debugging grief!

  • No labels