I created all entity bean with a userid id USER1, and tested when I moved my code to another application server in different box, I am not able to deploy the bean and having a problem saying the userid not exist the reason is , the application server is pointing to different database with different user id saying USER2, how to do mapping of my entity to that USER2 instead of USER1.
Hi Meyyappan, You didnt mention which version of WebSphere you are using and which tool are u using for developement of Entity Beans. As far as WAS3.5 is concerned we developed our Entity Beans using VAJ3.5 so if we had a change of schema then all you had to do in VAJ was open the database schema browser and then remove the hardcoded schema name in the Qualifier textbox. This way during deployment time the schema name will not clash as given in the Datasource. So even if you have a different database with a different schema name but with the same table structure ( as previous schema ) you can deploy your entity bean by just pointing your datasource to that database and schema ( you can use any userid and pwd, all that matters is the schema name). About WAS4.0, we are using WSAD for development and deployment of Entity Beans and I am also looking for how to change the schema name through WSAD. I also posted a question regarding this but nobody answered. Though there is one solution to it, the schema mapping is stored in schema.dbxmi - so there we can change the name of the schema but thats something very raw, i hope someone will find a right solution for it soon.
Thanks and Regards<br />Balbir Singh<br />Sun Certified Java Programmer<br />IBM Certified Administrator for WebSphere4.0