dynamic « Database « JPA Q&A

1. how to connect to multiple databases dynamically using Hibernate coderanch.com

Hi all, I have a requirement in which I should be able to connect to multiple databases dynamically using Hibernate. I can use multiple configuration files and call configure(String filename) to create SessionFactory object. But my requirement is that multiple databases connect to my server dynamically which I am unaware of, so I would not be able to configure them in ...

2. Configure Database dynamically in Hibernate coderanch.com

Hi ranchers, My web application needs to support two databases either MS-SQL or Oracle. My application will be deployed on Weblogic Server. Users will be creating a datasource (either MS-SQL or Oracle) in Weblogic Server. As my application need to support many databases i have decided to use hibernate, so that i can code to HQL rather than SQL. Can i ...

3. JPA and dynamic user authentication with the database coderanch.com

Is it possible to use JPA and dynamic based user authentication with the database? I would like to capture the users credentials in a form and authenticate them with the database and have JPA use that connection. I am not interested in Realms, because it sound likes I would need to set up additional tables. If the user is an authorized ...

4. Dynamic reconnection to DB in hibernate forum.hibernate.org

Hi, I am new to Hibernate. I have created a basic database application using Hibernate in java. My doubt is that how can I switch from one host to another, which contains the same DB schema at runtime. Suppose my "connection.url" is "jdbc:oracle:thin:@host1:1521:sid" Now without stopping the application can i change to some other host like "jdbc:oracle:thin:@host2:1521:sid" say after 1 hour? ...

5. j2ee dynamic database generation forum.hibernate.org

I'm trying to get some feedback searching through hibernate documentation and JPA specs as well as use cases. I've inherited a j2ee application that uses application managed persistence and has the unique functionality of generating databases (varying only by name) with the same persistence unit via the createEntityManager call. Each database contains identical data structures and simply houses a unique groups ...

6. Dynamic database forum.hibernate.org

Hi! I've been looking around for a good O/R mapping and persistance tool, and as far as I can tell, Hibernate is one of the best tools to use. I have a problem that I really hope that Hibernate can solve for me. At our company we have a very dynamic database structure for our system. Our customers can add and ...

7. Dynamic Dialect forum.hibernate.org

We currently have our session factory setup for the MSSQL dialect. I have come across a situation where we want to obtain data from one of our legacy systems, which is using a proprietary sql database. I am able to run query's on it by passing a JDBC connection into the session, and it seems to work OK for the most ...

8. Dynamic Database views forum.hibernate.org

I know that mapping to database view is just like mapping to a regular database table. The issue I have is that application we have will be implemented by various customers and tthey create the views as they see fit. For example, say we have a base table name TelephoneNumbers. The customer may choose to create views into this table, through ...

9. how to change the database dynamically? forum.hibernate.org

10. Dynamic Create databases forum.hibernate.org

I am just wondering is there anyone has the experince about dynamicly create database. I am working on a research. The project is create a web management tool that allow researchers create their own website throught this management tool. We got two options for the database design now. 1. using one database to store all the researchsers' website data. 2. for ...

11. Dynamic Database creation using hibernate forum.hibernate.org

12. how to dynamically change database user? forum.hibernate.org

I want to use hibernate with an existing database. The problem is that there are multiple database accounts with different privileges, and my application must dynamically switch to the appropriate database user based on what it is doing and for whom? At the JDBC level, I want to be calling getConnection passing in a database username and password. How can I ...

13. Suggestion to dynamic change database settings. forum.hibernate.org

Hibernate version: 3.2.6.ga Hello, I'm a Hibernate newbie, I would like to know if anyone have a suggestion to read the database settings from another file/local that is not the hibernate.cfg.xml. This will help to migrate code from an database to another, so I don't need to change the hibernate.cfg.xml and then make deploy to update database settings. That is possible? ...

14. Dynamically Database creation. forum.hibernate.org

IN JDBC, for database programming, we must need to give database name during connectivity and then we perform our further sql operation while i want to create that dynamically..i.e first user will enter his new database name(create) then he create table for that database from my wizard.. so here is my actual problem..how can i do that..