Hi Everybody,

I have a question about my config and the catalog attribute in the hbm.xml files. Currently, I have three databases that I'm accessing simultaneously, so I have three different hibernate config files that have something like this:
<property name="connection.url"> jdbc:oracle:thin:@machineA:some_port:foo</property>
<property name="connection.url"> jdbc:oracle:thin:@machineA:some_port:bar</property>
<property name="connection.url"> jdbc:oracle:thin:@machineA:some_port:foobar</property>

I saw a post that eluded to catalog attribute in the individual hbm.xml files.

viewtopic.php?f=1&t=961448 (The second from the last posting - by jherbst)

My question is could we combine the three configuration files down to one and by pushing the database name down to the in hbm.xml files and have Hibernate figure out which database to go to dynamically? For example:

<property name="connection.url"> jdbc:oracle:thin:@machineA:some_port</property>

In individual hbm.xml files, have something like this:

<class name="a.b.c.d.hibernate.t.t" table="t_name" schema="fooAdmin" catalog="foo">
<class name="a.b.c.d.hibernate.s.s" table="s_name" schema="barAdmin" catalog="bar">
<class name="a.b.c.d.hibernate.u.u" table="u_name" schema="foobarAdmin" catalog="foobar">

Thanks!
Tino

Hello Everybody,

I have few questions to get cleared as I did not have chance to workaround with 2 databases concurrently. Using Oracle 10g.

SID : sidname
user 1 : username-1
user2 : username-2

My queries

1. From the above what is the catalog name & which is the schema name

2. I create a table called Persons with username-1 (having 50 records), Now I login in oracle with username-2 If I try creating Persons with username-2 what will happen.

After I get answers for the above I have few other questions to be in place. Please help me understand these things.

if the user1 give the previlage to access the table then only user2 can access it.
when you retrive the table place user1.tablename.

please update,

if you find anything how to access more than one database in single hibernate config files.