$ dpconf create-jdbc-table jdbc-employee employee $ dpconf create-jdbc-table jdbc-salary salary 为SQL 表中的每一列添加 JDBC 属性。 $ dpconf add-jdbc-attr jdbc-employee eid employee_id $ dpconf add-jdbc-attr jdbc-employee first firstname $ dpconf add-jdbc-attr jdbc-employee last lastnam...
Deleting an employee entry.The row in the secondary table is not deleted because the manager entries are shared. Deleting the “manager” attribute from an entry.The row in the secondary table is deleted and the foreign key (EMPLOYEE.FK_MANAGER_ID) is set toNULL. Example 23–2is-single-ro...
Example A stores a number of products in its directory. In the past, each product was associated with a support person, an employee responsible for handling all support calls for that product. In the physical data store, each product is therefore associated with asupportPersonattribute, whose va...
% dpconf create-jdbc-object-class mysql1-view person employee1 country1 phone1 uid Define the join rules between the primary table and the secondary tables. A join rule is defined on the secondary table and determines how data from that table is linked to data from the primary table. % d...