Requirement is there are 6 tables.
Depends on the input parameter we need to perform DML operations on the tables.
Is there any way to build VO(Based on EO) dynamically linked to a table and performs DML.
If this is possible we pass table name as parameter, and perform DML on that Table.
While creating Entity Object EO, it will allow you to select only one data base object ( table ) at design time .
How ever you can insert record into different tables using Prepared statement .
Please Let us know clearly what exactly your requirement is ?
Requirement is we are having 6 different tables.
User have choices like update/delete/Insert on selected table among 6 tables.
Depending on this user choice, we need to perform DML on the selected table.
This is possible with single EO?
as per your suggestion, we use the prepared statement.
Hi JP ,
It is not possible with a single EO , how ever from controller class you can call a Database procedure that performs
DML operation for 6 different table .
As shushant said you can make use of CallableStatement .