Does JPA support mapping to sql views?

by

While using the @Id annotation with fields of directly supported types is not the only way to specify an entity’s identity (see @IdClass with multiple @Id annotations or @EmbeddedId with @Embedded), the JPA specification requires a primary key for each entity.

That said, you don’t need entities to use JPA with database views. As mapping to a view is no different from mapping to a table from an SQL perspective, you could still use native queries (createNativeQuery on EntityManager) to retrieve scalar values instead.

More Related Contents:

  1. String variable in java to get and store the json array in table column
  2. JPA JoinColumn vs mappedBy
  3. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  4. Hibernate Annotations – Which is better, field or property access?
  5. How to map calculated properties with JPA and Hibernate
  6. How to print a query string with parameter values when using Hibernate
  7. How to call a stored procedure from Java and JPA
  8. Bypass GeneratedValue in Hibernate (merge data not in db?)
  9. When and why JPA entities should implement the Serializable interface?
  10. Map enum in JPA with fixed values?
  11. How to annotate MYSQL autoincrement field with JPA annotations
  12. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  13. Storing a Map using JPA
  14. How to persist a property of type List in JPA?
  15. I found JPA, or alike, don’t encourage DAO pattern
  16. Getting Database connection in pure JPA setup
  17. Hibernate – @ElementCollection – Strange delete/insert behavior
  18. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  19. How to clone a JPA entity
  20. Spring JPA @Query with LIKE
  21. Is it possible to dynamically define column names in Hibernate / JPA?
  22. @Basic(optional = false) vs @Column(nullable = false) in JPA
  23. No operator matches the given name and argument type(s). You might need to add explicit type casts. — Netbeans, Postgresql 8.4 and Glassfish
  24. Batch inserts with JPA/EJB3
  25. Hibernate triggering constraint violations using orphanRemoval
  26. What is Persistence Context?
  27. How to create join table with JPA annotations?
  28. Change Table Name of an Entity on runtime? [duplicate]
  29. JPA Select latest instance for each item
  30. How to map one class to different tables using hibernate/jpa annotations

Leave a Comment