Current Position:Home > How to handlle multiple ear and common database.

How to handlle multiple ear and common database.

Update:11-30Source: network consolidation
Advertisement
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.

The Best Answer

Advertisement
How are you going to handle upgrades if a database change is needed?
If it is per application then you need to keep the code by app. If across applications then you need to keep the code separate.
  • How to handlle multiple ear and common database. Update:11-30

    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 sam

  • Sharing common libraries and ejbs between multiple ears Update:11-30

    Hi I have been going through various articles at O'Reilly and discussions at serverside (some outdated) on the packaging options in J2EE. http://www.onjava.com/pub/a/onjava/2001/06/26/ejb.html?page=2 http://www.onjava.com/pub/a/onjava/2001/07/25/ejb.

  • Using common jars containing EJBs in multiple ears Update:11-30

    I was wondering if there was an easy way to have references to jars that is contained in one ear in another ear. The main question is that if we have some EJBs that are commonly used in multiple ears then is there a way to have those common EJBs in a

  • Create multiple instance in a database Update:11-30

    is it possible to create multiple instance in a database.if possible then is it possible to activate many instance at a time.(in personal edition)Instance in Oracle refers to the Oracle database "engine" - a collection of processes using a share

  • Share http session across multiple EARs Update:11-30

    I am curious to know the following:- --> is it possible to share http session across multiple EARs running on same Weblogic application server. i.e weblogic server/Jboss --> is it possible to share http session across multiple EARs running on differ

  • How to create multiple instance on same database Update:10-11

    Hi , I would like to know how to create multiple instance on same database . I know that some people use database configuration assistant to do this but i could not figure out how they did it. Any how if some one can help me with this and can give me

  • Importance of Common Database in SAP B1 Update:10-11

    hi guys, Up to this point, its not very clear to me if it is necessary to back the Common Database of SAP business one. As per documentation, it states that Common database – includes tables for basic initialization of any new company database (for e

  • Multiple rows in a database Update:10-11

    Hi all,             I am sending one single row from one data base to anotherdata base successfully. But I am not able to send multiple rows to another database.I am using parent  and child relationship here.      Could anybody help me to solve this

  • Inserting multiple records in to database table using webdynpro abap Update:10-11

    Hi all, I have created a username inputfield,a button and a table with one coloumn. If i enter  names in the input field then the values should be displayed in that table. Even i have got the answer i am not able to insert the values in to database(z

  • Locking multiple records in a database table at a time Update:10-11

    Hi Experts,    I have a requirement to lock multiple records in the database table for writing. I have created lock object in SE11. But with this we have only 2 possibilities either lock entire table or lock a single record at a time.    My requireme