Hi,I am also trying to use multiple data source in my portal(7.2CE). So i did following things :-step 1: created a service builder.step 2: Defined entity in service.xmlstep 3: Defined the external source in portal-ext.properties
step 4:build servicestep 5: Made ext-spring.xml in META-INF folder of servicebuilder-service.step 6: Utilized the service in a mvcPortlet class.The problem that it is creating is that it is using the default database defined in the portal-ext.properties and not the one which is defined as "external", i.e it is searching for the table in default database and gives an error stating that "defaultDatabase.table doesn't exist "
I hope someone has the solution for it.Thank you in advance.