Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Toplink Develop in one schema deploy to another HOW TO?

447980Jun 1 2006 — edited Jun 23 2006
Greetings:

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2006
Added on Jun 1 2006
5 comments
510 views