blocks|key|4563184|text|当创建/更新被引用列的responsibility不在当前实体中，而在另一个实体中时，可以这样做。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|4563185|entityMap^0|B|E|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

You would do that when the responsibility of creating/updating the referenced column isn't in the current entity, but in another entity.

blocks|key|4563209|text|当您需要在一个实体中多次映射一个字段时，定义insertable=false,+updatable=false非常有用，通常是：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4563210|使用复合密钥时使用|4563211|在使用cascaded+primary+keys|unordered-list-item|4563212|时使用复合密钥|4563213|4563214|4563215|这不是一个语义上的东西，但绝对是一个技术上的东西。|4563216|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikibooks.org/wiki/Java_Persistence/OneToOne#Target_Foreign_Keys.2C_Primary_Key_Join_Columns.2C_Cascade_Primary_Keys^0|M|X|0|0|3|L|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|12|8|@]|D|@$9|13|A|14|1|15]]|E|$]]|$1|K|3|L|5|6|7|16|8|@]|D|@]|E|$]]|$1|M|3|-4|5|J|7|17|8|@]|D|@]|E|$]]|$1|N|3|-4|5|6|7|18|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|19|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]]]

Defining <code>insertable=false, updatable=false</code> is useful when you need to map a field more than once in an entity, typically:

<ul>
<li>when using a composite key</li>
<li>when using a <a href="http://en.wikibooks.org/wiki/Java_Persistence/Identity_and_Sequencing#Primary_Keys_through_OneToOne_and_ManyToOne_Relationships" rel="noreferrer">shared primary key</a></li>
<li>when using <a href="http://en.wikibooks.org/wiki/Java_Persistence/OneToOne#Target_Foreign_Keys.2C_Primary_Key_Join_Columns.2C_Cascade_Primary_Keys" rel="noreferrer">cascaded primary keys</a></li>
</ul>

This is IMO not a semantical thing, but definitely a technical one.

blocks|key|4563272|text|对于BalusC和Pascal+Thivent的回答，我想补充一下insertable=false,+updatable=false的另一种常见用法|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4563273|考虑一列，它不是id，而是某种类型的序列号。计算序列号的责任可能不一定属于应用程序。|BOLD|4563274|例如，序列号从1000开始，每个新实体都应递增1。在数据库中很容易做到这一点，而且非常恰当，在这种情况下，这些配置是有意义的。|4563275|entityMap^0|X|X|0|I|3|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|P|8|@$9|Q|A|R|B|H]]|D|@]|E|$]]|$1|I|3|J|5|6|7|S|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|L|$]]

I would like to add to the answers of BalusC and Pascal Thivent another common use of <code>insertable=false, updatable=false</code>:

Consider a column that is not an id but some kind of sequence number. The responsibility for calculating the sequence number may not necessarily belong to the application. 

For example, sequence number starts with 1000 and should increment by one for each new entity. This is easily done, and very appropriately so, in the database, and in such cases these configurations makes sense.

blocks|key|3152602|text|另一个示例是在"created_on“列上，您希望让数据库处理日期创建|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3152603|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

An other example would be on the "created_on" column where you want to let the database handle the date creation

blocks|key|1839142|text|根据Javax的持久化文档：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1839143|1839144|列是否包含在持久性提供程序生成的SQL+UPDATE语句中。|blockquote|1839145|1839146|1839147|最好从官方文档here中了解。|offset|length|1839148|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.oracle.com/javaee/7/api/javax/persistence/Column.html#updatable--^0|0|0|0|0|0|7|4|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|U|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|V|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Y|8|@]|9|@$J|Z|K|10|1|11]]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

According to Javax's persistence documentation:
<blockquote>
Whether the column is included in SQL UPDATE statements generated by the persistence provider.
</blockquote>
It would be best to understand from the official documentation <a href="https://docs.oracle.com/javaee/7/api/javax/persistence/Column.html#updatable--" rel="nofollow noreferrer">here</a>.

blocks|key|1096381|text|除了前面的回答之外，insertable=false,+updatable=false的一个常见用途是保存冗余的数据库查询，从而提高性能。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1096382|想象一下，有一个Client类，它有一个父实体。如果您只想检查客户端是否有父级，则只需检查其parent_id列中是否存在值。不需要要求Hibernate获取父实体，可能还有它的所有其他关联，这会导致额外数量的查询：|1096383|public+class+Client+{
++++@ManyToOne(cascade+=+{CascadeType.MERGE,+CascadeType.PERSIST},+fetch+=+FetchType.LAZY)
++++@JoinColumn(name+=+"parent_id")
++++private+Parent+parent;

++++@Column(name+=+"parent_id",+insertable+=+false,+updatable+=+false)
++++private+UUID+parentId;
}|code-block|syntax|javascript|1096384|通过上面的设置，parentId字段将简单地获取存储在parent_id列中的任何值，该列仅由父实体编辑/更新。|1096385|entityMap^0|A|X|0|1A|9|0|0|8|8|R|9|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|X|8|@$9|Y|A|Z|B|C]|$9|10|A|11|B|C]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|P|$]]

Adding to the previous answers, a common use of <code>insertable=false, updatable=false</code> is to save redundant database queries, thereby improving performance.
Imagine having a Client class, which has a Parent entity. If you just want to check if a Client has a Parent, you simply need to check for the presence of value in its <code>parent_id</code> column. There is no need to ask Hibernate to fetch the Parent entity, with possibly all of its other associations, leading to additional number of queries:
<pre><code>public class Client {
 @ManyToOne(cascade = {CascadeType.MERGE, CascadeType.PERSIST}, fetch = FetchType.LAZY)
 @JoinColumn(name = &quot;parent_id&quot;)
 private Parent parent;

 @Column(name = &quot;parent_id&quot;, insertable = false, updatable = false)
 private UUID parentId;
}
</code></pre>
With the setup above, the <code>parentId</code> field will simply fetch whatever value is stored in the <code>parent_id</code> column, which is solely edited/updated by the Parent entity.

blocks|key|1842259|text|我认为这仅仅意味着：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1842260|列是否包含在持久性提供程序生成的SQL+INSERT语句中。|1842261|参考：https://www.objectdb.com/api/java/jpa/Column|offset|length|1842262|entityMap|0|LINK|mutability|MUTABLE|url|https://www.objectdb.com/api/java/jpa/Column^0|0|0|3|18|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

I think it simply mean :
Whether the column is included in SQL INSERT statements generated by the persistence provider.
Reference: <a href="https://www.objectdb.com/api/java/jpa/Column" rel="nofollow noreferrer">https://www.objectdb.com/api/java/jpa/Column</a>

blocks|key|3152673|text|另一个原因可能是您的属性映射到视图的列(例如，您的hibernate实体是表和视图的融合)。因此，您的列不能被插入(也不能被更新)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3152674|@Entity
@Table(name+=+"THE_VIEW")
@SecondaryTable(name+=+"THE_TABLE",+pkJoinColumns+=+@PrimaryKeyJoinColumn(name+=+"THE_ID"))
public+class+MyEntity+{

++++@Id
++++@Column(name+=+"THE_ID")
++++private+Integer+id;

++++@Column(name+=+"VIEW_COLUMN",+updatable+=+false,+insertable+=+false)
++++private+String+viewColumn

++++@Column(name+=+"TABLE_COLUMN",+table+=+"THE_TABLE")
++++private+String+tableColumn;|code-block|syntax|javascript|3152675|(我不在这里讨论可更新的视图)|3152676|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Another reason could be that your attribute is mapper to a column of a view (Example, your hibernate entity is the fusion of a table and a view). So it does not make sens that your column can be inserted (nor updated).
<pre><code>@Entity
@Table(name = &quot;THE_VIEW&quot;)
@SecondaryTable(name = &quot;THE_TABLE&quot;, pkJoinColumns = @PrimaryKeyJoinColumn(name = &quot;THE_ID&quot;))
public class MyEntity {

 @Id
 @Column(name = &quot;THE_ID&quot;)
 private Integer id;

 @Column(name = &quot;VIEW_COLUMN&quot;, updatable = false, insertable = false)
 private String viewColumn

 @Column(name = &quot;TABLE_COLUMN&quot;, table = &quot;THE_TABLE&quot;)
 private String tableColumn;
</code></pre>
(I don't talk about updatable views here)

If a field is annotated <code>insertable=false, updatable=false</code>, doesn't it mean that you cannot insert value nor change the existing value? Why would you want to do that?

<pre><code>@Entity
public class Person {

 @Id
 @GeneratedValue(strategy = GenerationType.AUTO)
 private Long id;

 @OneToMany(mappedBy="person", cascade=CascadeType.ALL)
 private List&lt;Address&gt; addresses;
}

@Entity
public class Address {

 @Id
 @GeneratedValue(strategy = GenerationType.AUTO)
 private Long id;

 @ManyToOne
 @JoinColumn(name="ADDRESS_FK")
 @Column(insertable=false, updatable=false)
 private Person person;
}
</code></pre>

Please explain about insertable=false and updatable=false in reference to the JPA @Column annotation

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

如果一个字段被注释为insertable=false, updatable=false，这不是意味着您不能插入值或更改现有值吗？你为什么要这么做呢？@Entitypublic class Person {    @Id    @GeneratedValue(strategy = GenerationType.AUTO)    private Long id;    @OneToMany(mappe

问请参考JPA @Column注解解释一下insertable=false和updatable=false
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问请参考JPA @Column注解解释一下insertable=false和updatable=falseEN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问请参考JPA @Column注解解释一下insertable=false和updatable=false
EN