Does oracle itself support queries across multiple databases? I'm using SQL Server, which allows it using fully qualified object names (database.owner.table) in all sql statements. I just specify the database.owner in the schema attribute of each mapping, and it works fine. If oracle allows the same thing, this may work for you.
Joe ----- Original Message ----- From: "Tim Kettering" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 07, 2003 3:38 PM Subject: [Hibernate] Multiple database support w/ Hibernate > Pardon this question - I'm sure this has been asked, but I cannot find a definite answer in the Hibernate documents, and the sourceforge list archives (like usual) is taking forever to return any results. > > I know its possible to set up different session factories for multipled databases, but is it possible to do queries across multiple databases? If there's any information on this that I've missed, accept my apologies and point me in the general direction. Thanks. > > If it means anything, we're currently doing handcoded SQL statements on an Oracle database and we're evaluating Hibernate. We're also looking at revising the schema to merge the databases - so this may be moot, but was just wondering. > > -tim > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 > _______________________________________________ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
