Hi,

I have an application that has several datasources (different MSSql
servers and schemas)
I would like to have a single hibernate schema that will apply to all.
is that possible ? or I would be required to perform multiple mappings,
one per database.
Is there an option to work with a connection pool or something of that sort ?
If there is a better way to manage the connections definition I'd be happy to hear of it, since the datasources give me trouble anyway, they are defined staticaly and I cannot add a database to the application dynamically. (I must apply configuration changes).

I'm using JBoss 3.2.6, Hibernate 3.0, MSSql 8.0, Win2K server

Any help will be appreciated,
thanks

[b]Hibernate version:[/b] 3.0

[b]Name and version of the database you are using:[/b] MSSql 8.0

hmm ?

You can of course have one set of hbm.xml files that you just use with multiple SessonFactories and different hibernate.properties or hibernate.cfg.xml to control which database they will connect to.