Hi every one, I have developed a lot of EJBs which mapped to a database called TestA. Now the DBA has changed the database setting. Database TestA does not exist any more. They created a database called TestB. How can I switch all my mapping from TestA to TestB? The table names and columns are not changed. Thank you very much in advance! It is very urged for me! Thanks again.
Hi Kyle, Thank you very much for your kind help. The article you recommended is really helpful. But it is not my case. I was using a database called "V2003" with a schema called "APPL" when I first developed the EJB. But now we are switching to a database called "TEITS" with the same schema also called "APPL". All the tables are not changed. The following is what I have done in WSAD4: 1. I deleted the old connection called "TEI" which using the old database "V2003" in data perspective. 2. I created a new connection also called "TEI" using the new database "TEITS". 3. I inputed the schema "TEI.APPL" into my ejbModule containing the EJBs. After this finished, all the files in the folder "..\ejbModule\META-INF\Schema\" changed from "TEI_V2003_XXX.XXX" to "TEI_TEITS_XXX.XXX". 4. I modified the file "Map.mapxmi". I changed all "V2003" into "TEITS". 5. I opened "TEI.conxmi", which showed that it had changed the database, useid and password from the old database to the new database. 6. I modified the datasource in the server by changing to the new database "TEITS". 7. I switched to the "J2EE" perspective, extended the "EJB Modules", selected the "TeiEJB". I opened it with "EJB extension editor" and changed the datasource binding to the new one. 8. In "J2EE" perspective, I selected "Open with/Mapping editor". But I can not open the EJBs in mapping editor, and got an error Database or EJB JAR file is null. Unable to open map editor Can you help me?
Hi Davy Hu, I am doing the same thing, switching between the two different databases and also different Schema names. I do not know how to re-map the Entity Beans to the new database? Did you get the answers? Thanks