Multiple DataSource « Connection « JPA Q&A





1. JPA Reverse Engineering multiple Datasources    stackoverflow.com

I am using Eclipse, and my application works with two different DBs. I am able to reverse engineer one DB or the other, but I do not see how to set things ...

2. Multiple Datasources and Hibernate    coderanch.com

Hi, I am not using Spring Framework along with Hibernate. Is there any way where i can create and use the multiple datasources. IDE is Eclipse (MyElipse plugin) with XDoclete. Supposing i am having multiple entries of in hibernate.cfg.xml file , then how will i create the multiple SessionFactories , so for that i need to have multiple configuration xml ...

3. Multiple datasources with hibernate    coderanch.com

4. using multiple datasources in hibernate app    coderanch.com

My cfg file is like this true com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/mysql root sess 1 org.hibernate.dialect.MySQL5Dialect thread org.hibernate.cache.NoCacheProvider

10. Multiple datasources\databases    forum.hibernate.org

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 ...

11. question on multiple datasources    forum.hibernate.org

hi, i'm writing a portlet that will run in jboss (3.2.6). i have tested the portlet separately and it works with hibernate (2.1.8, i believe) just fine (connecting to mysql). the problem comes when i put the portlet in the portal. the portal uses it's own database (oracle) and stores all the hibernate properties in system properties. i have my xml ...

12. One App Multiple Datasources    forum.hibernate.org

just use different sessionfactories for each customer or if the mappings are completely the same then use the same session factory, but provide your own connection (but be warned that the 2nd level cache is global for one session factory thus you will not have complete isolation ... so multiple session factories are to be preffered.)

13. Multiple Datasources and Hibernate configuration    forum.hibernate.org

Ok, but why? Why not modify the DTD so that we can have multiple session factories? Make a rule that session-factorys' name attributes must be present and unique when specifying more than one session-factory element. Then, when parsing the config file, just iterate the session-factory elements and put them in a map keyed by the name attribute. Then all you need ...

15. Configuration in a Multiple Datasources scenario    forum.hibernate.org

Hi, when reading CaveatEmptor HibernateUtils, I found the following excerpt: * Note: This class supports only one data store. Support for several * SessionFactory instances can be easily added (through a static Map, * for example). You could then lookup a SessionFactory by its name. which makes sense due the SessionFactory variables static signature. But, considering the following scenario: 1) A ...

16. multiple data sources    forum.hibernate.org

Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version:3.2 I am trying to use hibernate in an application to connect to multiple data sources. One db is DB2 that houses most of the basic employee info companywide, the other is an Oracle db that houses specific performance appraisal info for the application. is it possible to connect to ...





17. Use datasource pool across multiple databases    forum.hibernate.org

Hey there- I have an application with multiple instances of the same schema, one per corporate account. I would ideally like to pool datasources and be able to switch between schema depending on the caller's environment. Is this possible through hibernate? Right now I am maintaining a Map of SessionFactory objects for each schema, but at a certain point I'm going ...