`
echohfut
  • 浏览: 234120 次
  • 性别: Icon_minigender_1
  • 来自: 上海
社区版块
存档分类
最新评论

Read-Only transactions

阅读更多

read-only="true|false" 经常出现在Spring事务配置文件或者annotation 属性中,具体解释如下:

 

 

1. Spring documents describes:

 

Read-only status: a read-only transaction does not modify any data. Read-only transactions can be a useful optimization in some cases (such as when using Hibernate).

2. from Google

 

if the transaction is marked as read-only, Spring will set the Hibernate Session's flush mode to FLUSH_NEVER, and will set the JDBC transaction to read-only.

 

3. Hiberante

 

when a session's flush mode is set to FLUSH_NEVER, two things happen:

First, running HQL queries no longer cause Hibernate to flush the session state to the database, which can provide a dramatic performance improvement.

Secondly, Hibernate will not flush the changes before commiting the transaction. But the user can still call Session.flush() by hand, causing any modifications to be persisted to database.

 

4. Oracle

 

When using the Oracle JDBC driver, calling connection.setReadOnly(true) translates into the statement "SET TRANSACTION READ ONLY". This statement limits the types of SQL statements that can be executed during the transaction. Only SELECTS (without 'FOR UPDATE') and a few other statements can be executed. Specifically, no UPDATEs, DELETEs, INSERTs or MERGEs can be executed. This behavior is Oracle-specific. Other RDBMS can have different semantics for read only transactions or simply not support it at all.

 

 

 

from:  http://www.codeinstructions.com/2009/04/read-only-transactions-with-spring-and.html

分享到:
评论

相关推荐

    Concurrency in Main-Memory Database Systems

    single workload type, either short transactions or long-running, read-only analytical queries. In this thesis, we focus on allowing a broad range of workloads to be executed concurrently on the same ...

    mysql 5.6 新特性-innodb

    1. **Read-Only Transactions(只读事务)**: - **第一层优化**:通过区分只读事务与更新事务来提高并发性能。只读事务不会产生历史版本,因此可以优化 ReadView 的创建过程,减少遍历活跃事务链表的次数,从而...

    Clarion Toolkit(VCL)

    applications for Clarion v.2.X tables read-only access.Features: - Encrypted tables support(with Password Recovery ) - Clarion Arrays support - Application-level transactions support - Fast and smart ...

    AMBA AXI protocal

    • uses burst-based transactions with only the start address issued • separate read and write data channels, that can provide low-cost Direct Memory Access (DMA) • support for issuing multiple ...

    ABAP Program Tips.pdf

    1.1 EDI SPECIFIC TRANSACTIONS---------------3 3.4.3 DATASET.............................................25 1.1.1 SCHEDULING AGREEMENTS.......................3 3.4.4 WS_DOWNLOAD...........................

    RESTful Web Services.rar

    5. Designing Read-Only Resource-Oriented Services..107 Resource Design 108 Turning Requirements Into Read-Only Resources 109 Figure Out the Data Set 110 Split the Data Set into Resources 112 Name...

    Serv-U Keygen

    * Logs all transactions to file and screen that can be read by other applications. Includes unique session IDs, time, and date stamps. * Log file can be read by other applications while open, or...

    ibatis-sqlMap

    - **Read-Only vs. Read/Write**:读取模式和读写模式下的缓存行为。 - **Serializable Read/Write Caches**:支持序列化的读写缓存。 - **Cache Types**:不同类型的缓存机制,如LRU缓存、FIFO缓存等。 - **...

    微软内部资料-SQL性能优化3

    Concurrent transactions are isolated from the updates of other incomplete transactions. These updates do not constitute a consistent state. This property is often called serializability. For example, ...

    ibatis developer guide

    - **Read-Only vs. Read/Write**:读取模式与读写模式的区别及其应用场景。 - **Serializable Read/Write Caches**:序列化的读写缓存,适用于需要跨会话持久化的场景。 - **Cache Types**:不同类型的缓存策略,...

    spring.net IOC例子

    -- 配置事务属性,如 propagation、read-only、timeout 等 --> ``` 当你运行应用程序时,Spring.NET容器会根据配置文件创建并初始化对象。在本例中,`myService`对象将被创建,并且它的`connectionString...

    数据库系统原理英文课件:ch16 Concurrency Control.ppt

    This allows transactions to read older versions while newer modifications are being executed, reducing conflicts. The impact of concurrency control on **Insert and Delete Operations** is covered, as...

    Absolute Database for D7

    user and multi-user mode Full transactions support with ReadCommited isolation level SQL Support SELECT with DISTINCT, INNER LEFT, RIGTH, FULL and OUTER JOIN, GROUP BY and ORDER BY clauses CREATE ...

    Beginning T-SQL with Microsoft SQL Server 2005 and 2008

    Each section of this book organizes topics into logical groups so the book can be read cover-to-cover or can be used as a reference guide for specific topics. We start with an introduction to the T-...

    spring-boot-reference.pdf

    37. Distributed Transactions with JTA 37.1. Using an Atomikos Transaction Manager 37.2. Using a Bitronix Transaction Manager 37.3. Using a Narayana Transaction Manager 37.4. Using a Java EE Managed ...

    k7 SRIO参考例程

    - 8-bit SWrite transactions usign 16-bit deviceIDs suffer lost eofs - Version fixed : v4.4 - CR#467668 / AR#30322 - Modified Logical Layer to properly forward eof through the pipeline. - Some ...

    Unity插件:iOS Native 8.1

    * Transactions Validation * Restoring Purchases * Store Product View Social Sharing * Facebook Post * Twitter Post * Native Sharing Dialog * Sending e-mail * Documentation iAd App Network ...

    ocp认证oracle

    11. 回退段管理:初始化参数TRANSACTIONS-PER-ROLLBACK-SEGMENT和TRANSACTIONS决定实例中的回退段数量。 12. 参数修改:动态性能视图V$SYSTEM_PARAMETER的ISSYS_MODIFABLE字段表示参数是否可被ALTER SYSTEM命令即时...

    Modern Operating Systems 3rd

    RAM (Random Access Memory) is volatile and provides fast access, while ROM (Read-Only Memory) stores firmware instructions. Modern systems also use cache memory to improve data access speeds. 3. **...

    在线图书销售管理系统毕业论文

    gned using one of the ... By embracing the digital age, this system not only transforms the way books are bought and sold but also contributes to the ongoing evolution of e-commerce in China and beyond.

Global site tag (gtag.js) - Google Analytics