|
|
Tip: Creating a Spring Read Only and Native Query
For reading operations, the transaction configuration readOnly flag should be set to true and in order to execute native queries, the @Query annotation parameter, nativeQuery flag, should be set to true.
|
|
|
To allow your query methods to be transactional, you should use @Transactional at the repository interface that you define. For reading operations, the transaction configuration readOnly flag should be set to true and in order to execute native queries, the @Query annotation parameter, nativeQuery flag, should be set to true, as you will see in the snippet of code below:
//before using the readOnly and nativeQuery flags
@Transactional()
@Query(value="...")
//after setting the readOnly and native query flags to true
@Transactional(readOnly=true)
@Query(value="...", nativeQuery=true)
Visit the DevX Tip Bank
|
Octavia Andreea Anghel is a senior PHP developer currently working as a primary trainer for programming teams that participate at national and international software-development contests. She consults on developing educational projects at a national level. She is a coauthor of the book "XML Technologies--XML in Java" (Albastra, ISBN 978-973-650-210-1), for which she wrote the XML portions. In addition to PHP and XML, she's interested in software architecture, web services, UML, and high-performance unit tests.
Email Author
|
|
|
|