I'm copying parts of two separate Oracle databases into (hopefully) one MySQL database (don't ask, strange business rules are dictating this). In one of the Oracle databases, they have a public synonym setup which makes the copying easy. In the other, they do not (and will not add one), which makes copying hard. I'm using the same repository_user.xml for both Oracle and MySQL. I've tried adding the "schema=" to the class-descriptor lines, but then OJB tries to connect to a different database in MySQL, which is not what I want.
The Oracle DBA says if I could execute: ALTER SESSION SET CURRENT_SCHEMA = SYSDBA at the beginning of my session on Oracle, everything would be fine. So my questions are: * Is there a way to execute that SQL at connection time? * Am I going to be forced to have two separate databases? If I have to have two databases, it's not really the end of the world, it's just semi-easier to do it as one. Thanks! cdh -- Chris D. Halverson http://www.halverson.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
