view « Table « JPA Q&A





1. There are difference between a view and a table from the point of view of Hibernate?    coderanch.com

Hi, I have a application that uses several tables, I would like to change one table for a view that contains the same columns and data types, must I to change the application code (hibernate mapping files, daos etc) or hibernate not disting a table from a view. Suppose that the table and the view are identical. For example, I develop ...

2. Table/view already exists    forum.hibernate.org

Hi, I have a quite strange problem. I have a pretty large set of tables, linked together with bidirectional one-to-many/many-to-one associations. The problem occurs when i try to run my application. I get an error message saying that one of my tables already exist. But, when i remove the mapping for this class, i get an error message that this class ...

4. Write and Read same classes to different Tables/Views    forum.hibernate.org

I am using RDB Views to read my objects, but I am writing them to the tables underlying the Views. (This is because I am using read-only Materialized Views for efficiency.) Integrity is maintained, because of course the View is just exposing the same info as in the underlying table. Can Hibernate O/R mapping handle this situation?

5. Swap Table for Database view: Possible?    forum.hibernate.org

6. Can a class be configed to read from a view/write to a table    forum.hibernate.org

Hello, need to support something like this: I have a database table T and a database view of T - TV. I would like to configure hibernate to read from the view (TV), but write to the table (T). Writes can be strictly limited to T (e.g. none of the joined tables need to be updated). So what I don't understand ...

7. Support for Derived Tables/Anonymous Views    forum.hibernate.org

8. Views or temp tables supported?    forum.hibernate.org

MySQL 4.1 or less supports the "CREATE TEMPORARY TABLE..." syntax. MySQL 5.0+ supports the "CREATE VIEW..." syntax. Other database engines may support the above or a completely different syntax. I would rather not write special flavors of SQL depending on which DB I'm using. Is there a way to express the use of views using HQL which will work with all ...

9. View instead of Table    forum.hibernate.org





10. Large table views in Hibernate    forum.hibernate.org

Hi, I am extremely new to Hibernate and ORM having just started migrating my apps over from very old and clunky Delphi forms connected to MySQL. Many of my apps require that data is viewed in table form so that you can compare many records and update several at a time. I have just grasped the concept of Hibernate and very ...

11. Single object based on view, but used with table, too    forum.hibernate.org

Greetings. I have an object that was based on a view, so it's got fields that map to multiple tables in addition to derived/calculated columns. Most of the time, the only things I need in this object are the columns from the primary table, so a straight old mapping file has worked well for querying and updates. I have a need ...

12. Using Views instead Tables    forum.hibernate.org

Extract from the Hibernate doc "There is no difference between a view and a base table for a Hibernate mapping, as expected this is transparent at the database level (note that some DBMS don't support views properly, especially with updates). " You can directly use the configuration of a table with a view.

13. How to create different object views for a table    forum.hibernate.org

Hi, Suppose we have a table table_A and on object A mapped to that table, and imagine that the table has a large number of columns, so i want to recover a reduced version of A object with less attributes (less columns considered), say AReduced, but also keep the A object mapped to the table (i may need to get all ...

14. Many-to-Many with a view as intermediate table    forum.hibernate.org

Isnt there a way to tell hibernate not to delete from the intermediate table in a many-to-many relation? some thing like on-delete="cascade", or cascade="none", or tell hibernate to see a table as a read only table so it never tries to delete an element from there...? I dont know what else to try but it seems to me like something not ...