posted 14 years ago
Hi,
We have Same DAO implementation for different business,differenting using BUSINESS_PREFIX will use repsective tables to process.We need to seperate logic having individual DAO implemetations for each business unit.Please provide a solution.
<bean id="programPrioritizationDAO" class="com.test.JdbcProgramPrioritizationDAOImpl">
<property name="dataSource" ref="dataSource"/>
</bean>
Sample Query in DAO Implemetation
"SELECT "+Constants.BUSINESS_PREFIX+"GET_PPO_CDE_STATUS(?,'PPO_STATUS')AS PRIORITIZATION_STATUS FROM DUAL";
Depending upon the business ,Constants.BUSINESS_PREFIX will be replaced to use the corresponding tables to fecth the data
.
Thanks,
Srini