Hi Friends,

Need urgent help.

I working on a project where there will be multiple ear ,each for one application.

There are 4 project and 4 ears and one common util war file which will be shared by all ears.

Problem is : 3 of the projects will use same database tables. I am using hibernate ORM mapping for database table.

Q1. In the above scenario db access table are 90% common in 3 projects. Should I go for instead of 3 ears club into 1 EAR and current 3 project as a 3 module in 1 club ear or per project one ear?

Pls suggest me the approach and advantage and disadvantages of the approach.

Q2 : Should I put the data-beans and table mapping files (e.g account.hbn.xml) & hibenate.cfg.xml file in common war(centralized or shared) or replicate the copies of all beans mapping xml and beans classes in every ear.

If you suggesting to use the centralized/shared data configuration approach then how EAR 's jvms will handle Transaction for every ear.

I am using Websphere app server6.1, hibernate3 and db2 8.0

Waiting for your interesting replies.

Thanking you in advance.

Navin.