Skip to main content

Queries

  • Chapter
  • First Online:
Spring Boot Persistence Best Practices
  • 1349 Accesses

Abstract

Consider the Author and Book entities involved in a bidirectional lazy one-to-many association. The data snapshot is shown in Figure 14-1 (there is one author who has written two books).

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

eBook
USD 16.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 79.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    https://hibernate.atlassian.net/browse/HHH-10965

  2. 2.

    https://hibernate.atlassian.net/browse/HHH-13280

  3. 3.

    https://hibernate.atlassian.net/browse/HHH-13782

  4. 4.

    HibernateSpringBootHintPassDistinctThrough

  5. 5.

    HibernateSpringBootJpaCallbacks

  6. 6.

    HibernateSpringBootEntityListener

  7. 7.

    HibernateSpringBootLimitResultSizeViaQueryCreator

  8. 8.

    HibernateSpringBootDerivedCountAndDelete

  9. 9.

    HibernateSpringBootPostCommit

  10. 10.

    HibernateSpringBootRedundantSave

  11. 11.

    HibernateSpringBootSimulateNPlus1

  12. 12.

    HibernateSpringBootFetchJoinAndQueries

  13. 13.

    https://jira.spring.io/browse/DATAJPA-307

  14. 14.

    HibernateSpringBootSoftDeletes

  15. 15.

    HibernateSpringBootJacksonHibernate5Module

  16. 16.

    HibernateSpringBootSuppressLazyInitInOpenSessionInView

  17. 17.

    HibernateSpringBootEnableLazyLoadNoTrans

  18. 18.

    HibernateSpringBootUTCTimezone

  19. 19.

    HibernateSpringBootOrderByRandom

  20. 20.

    HibernateSpringBootSubqueryInWhere

  21. 21.

    HibernateSpringBootResultSetMap

  22. 22.

    HibernateSpringBootCallStoredProcedureReturnValue

  23. 23.

    https://jira.spring.io/browse/DATAJPA-1092

  24. 24.

    HibernateSpringBootCallStoredProcedureJdbcTemplateBeanPropertyRowMapper

  25. 25.

    HibernateSpringBootCallStoredProcedureJdbcTemplate

  26. 26.

    HibernateSpringBootCallStoredProcedureNativeCall

  27. 27.

    HibernateSpringBootCallStoredProcedureReturnResultSet

  28. 28.

    https://hibernate.atlassian.net/browse/HHH-13215

  29. 29.

    https://github.com/spring-projects/spring-data-examples/tree/master/jpa/deferred

  30. 30.

    HibernateSpringBootUnproxyAProxy

  31. 31.

    https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html

  32. 32.

    HibernateSpringBootDatabaseView

  33. 33.

    https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html

  34. 34.

    https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html

  35. 35.

    HibernateSpringBootDatabaseViewUpdateInsertDelete

  36. 36.

    HibernateSpringBootDatabaseViewWithCheckOption

  37. 37.

    HibernateSpringBootAssignSequentialNumber

  38. 38.

    HibernateSpringBootRankFunction

  39. 39.

    HibernateSpringBootDenseRankFunction

  40. 40.

    HibernateSpringBootNTilleFunction

  41. 41.

    HibernateSpringBootTopNRowsPerGroup

  42. 42.

    HibernateSpringBootSearchViaSpecifications

  43. 43.

    HibernateSpringBootINListPadding

  44. 44.

    HibernateSpringBootSpecificationQueryFetchJoins

  45. 45.

    HibernateSpringBootQueryPlanCache

  46. 46.

    HibernateSpringBootExampleApi

  47. 47.

    HibernateSpringBootDynamicUpdate

  48. 48.

    HibernateSpringBootNamedQueriesViaAnnotations

  49. 49.

    HibernateSpringBootNamedQueriesInPropertiesFile

  50. 50.

    HibernateSpringBootNamedQueriesInOrmXml

  51. 51.

    HibernateSpringBootPropertyExpressions

  52. 52.

    HibernateSpringBootParentChildSeparateQueries

  53. 53.

    HibernateSpringBootSaveAndMerge

  54. 54.

    HibernateSpringBootMySqlSkipLocked

  55. 55.

    HibernateSpringBootPostgresSqlSkipLocked

  56. 56.

    https://vladmihalcea.com/how-do-postgresql-advisory-locks-work/

  57. 57.

    HibernateSpringBootSimulateVersionedOptimisticLocking

  58. 58.

    HibernateSpringBootRetryVersionedOptimisticLocking

  59. 59.

    HibernateSpringBootRetryVersionedOptimisticLockingTT

  60. 60.

    HibernateSpringBootSimulateVersionlessOptimisticLocking

  61. 61.

    HibernateSpringBootRetryVersionlessOptimisticLocking

  62. 62.

    HibernateSpringBootRetryVersionlessOptimisticLockingTT

  63. 63.

    HibernateSpringBootVersionedOptimisticLockingAndDettachedEntity

  64. 64.

    HibernateSpringBootHTTPLongConversationDetachedEntity

  65. 65.

    HibernateSpringBootOptimisticForceIncrement

  66. 66.

    https://www.percona.com/blog/2012/08/28/differences-between-read-committed-and-repeatable-read-transaction-isolation-levels/

  67. 67.

    HibernateSpringBootPesimisticForceIncrement

  68. 68.

    HibernateSpringBootPessimisticLocks

  69. 69.

    HibernateSpringBootPessimisticLocksDelInsUpd

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2020 Anghel Leonard

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Leonard, A. (2020). Queries. In: Spring Boot Persistence Best Practices. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5626-8_14

Download citation

Publish with us

Policies and ethics