Toplink Develop in one schema deploy to another HOW TO?
447980Jun 1 2006 — edited Jun 23 2006Greetings:
I tried this over in the Toplink forum but no one there replied so I thought I would try here and see if anyone here has dealt with similar issues.
I have been doing J2EE programming for a while. In the past I used EJB's for database access. I have been trying to learn toplink and get better at working with it. I think i have a good handle on how to make it do the things I need. My problem is, I develop things in a development schema "access_tdt_d" and when I am all done I give the dba a set of sql scripts, and the OAS guy a ear file. The DBA installs my SQL into "access_prd_d" and the OAS guy deploys my ear file. Then the DBA makes synonyms in a different schema "access_prod" to all my tables in "access_prd_d". On the OAS server the OAS guy has a datasource with the same name that I used only his points to access_prod instead of access_tst_d. My question comes from what I have just recently noticed. That being, the schema name is used throughout the toplink mappings and such.
I have never deployed one of these to prod but I get the strange feeling it wont work. Is there a way to tell toplink not to use the schema name but just the table name? If not how do people deal with this problem?
Thanks in advance
Troy