File attachment using Adf faces, EJB3 and Oracle XE database Part I
Usecase: I want to associate files with employees (PERSON). I will have employees(PERSON) with their associated files which will hold the more information for that employees (PERSON) like (employee’s picture, list of his dependant, his Resume etc) My ERD will have PERSON and ATTACHMENT tables, and a join table between PERSON and ATTACHMENT that is PERSON_ATTACHMENT. The relation between PERSON AND ATTACHMENT is ONE TO MANY, A single employee (PERSON) can have many attachments. Step # 1 Creating tables in Oracle database XE Let’s first create the Tables in Oracle XE Database. Open your Oracle Database XE by clicking on “Startup” select “Oracle Database 10g Express Edition” and then click on “Go to Database Home page” Login to Oracle Database XE. Creating PERSON Table PERSON table PERSON table also create sequence for PERSON table PERSON table Create Attachment table with three columns "ATTACHMENT_ID", "FILE_CONTENT" ...