Schema change at connect time?

[Chris Halverson <cd...@halverson.org>]

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/