Hmmm. Everyone that I know of use the same database schema names in test, qa, prod, but simply point the jdbc data source to different database instances in the test, qa, and prod app servers. This is what we do. We are able to pre-bind all security, ejb, and datasource refs prior to installing the ear file in test. We then use the same, unchanged earfile in each environment.
John Zerbe - Mellon Financial Corp. Information Technology Solutions - Middleware Team Phone: 412-234-1048 E-Mail:[EMAIL PROTECTED] AIM: 153-1315 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 11:12 AM To: [EMAIL PROTECTED] Subject: cmp - Schema name in generated select statment In our environment, the schema name changes between different environments (Development, QA, Production). The problem is that we have a mandate to finsh QA testing, and to move the EAR file directly to Production for deployment. Does nayone know of any way to change shema name without re-mapping or otherwise manipulating code for CMPs in the EJB 1.x environment? (We use Webspher App Server 4.x). Has this been addressed in the EJB 2.0 spec / implementation? =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help". DISCLAIMER: The information contained in this e-mail may be confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator. ==========================================================================To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
