Styjun

Do we know the situation in Britain before Sealion (summer 1940)?

Suffocation while cooking under an umbrella?

How to say "cheat sheet" in French

Lost Update Understanding

Fuel sender works when outside of tank, but not when in tank

Received a package but didn't order it

Labview vs Matlab??Which one better for image processing?

Why does C++ have 'Undefined Behaviour' and other languages like C# or Java don't?

How do pilots align the HUD with their eyeballs?

Why does (inf + 0j)*1 evaluate to inf + nanj?

Can anyone put a name to this Circle of Fifths observation?

Is it more effective to add yeast before or after kneading?

What should I consider when deciding whether to delay an exam?

My Project Manager does not accept carry-over in Scrum, Is that normal?

On the meaning of 'anyways' in "What Exactly Is a Quartz Crystal, Anyways?"

What exactly did this mechanic sabotage on the American Airlines 737, and how dangerous was it?

Strange Sticky Substance on Digital Camera

Reorder a matrix, twice

How to see the previous "Accessed" date in Windows

How to clarify between imagined sensations and "real" fantasy events?

relating two diagrams in tikzcd

Examples of "unsuccessful" theories with afterlives

I am 15 years old and do not go to a Yeshiva but would like to learn Talmud. A few rabbis near me said they could teach me. How should I start

Difference between types of yeast

Hibernate INSERT with foreign key relation without UPDATE permissions

Hibernate: Where do insertable = false, updatable = false belong in composite primary key constellations involving foreign keys?Should Hibernate be able to handle overlapping foreign keys?The JPA hashCode() / equals() dilemmaCreate the perfect JPA entityNull foreign key, in ManyToOne relation using hibernate [4.1.1] annotationsHibernate update with relations foreign keyInsert entity with foreign key in hibernate without having to query related entityHibernate Foreign Key Name for ManyToOne with JoinTableHibernate Postgresql select for update with outer join issueforeign key not updated in one to many hibernate mapping

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I have two tables Table A and Table B, Table B has a foreign key to the Table A.
Given a database user with only SELECT and INSERT rights, I need to insert to both tables from my Spring Boot application with Hibernate.

My problem is, that Hibernate generates the following query:

SELECT 1 FROM ONLY "Table A" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x

that needs UPDATE permissions (and the user don't have them). The FOR KEY SHARE query should be a lock for the foreign key relation, if I understand it correctly.

My Table A entity is annotated with @Immutable, but it doesn't seem to work. The @JoinColumn(updatable = false) either.

How can I say Hibernate that I don't want this lock?

java postgresql hibernate spring-boot

share|improve this question

edited Mar 28 at 22:43

vkirilichev

asked Mar 28 at 17:37

vkirilichevvkirilichev

8666 bronze badges

add a comment
 | 

1

I have two tables Table A and Table B, Table B has a foreign key to the Table A.
Given a database user with only SELECT and INSERT rights, I need to insert to both tables from my Spring Boot application with Hibernate.

My problem is, that Hibernate generates the following query:

SELECT 1 FROM ONLY "Table A" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x

that needs UPDATE permissions (and the user don't have them). The FOR KEY SHARE query should be a lock for the foreign key relation, if I understand it correctly.

My Table A entity is annotated with @Immutable, but it doesn't seem to work. The @JoinColumn(updatable = false) either.

How can I say Hibernate that I don't want this lock?

java postgresql hibernate spring-boot

share|improve this question

edited Mar 28 at 22:43

vkirilichev

asked Mar 28 at 17:37

vkirilichevvkirilichev

8666 bronze badges

add a comment
 | 

I have two tables Table A and Table B, Table B has a foreign key to the Table A.
Given a database user with only SELECT and INSERT rights, I need to insert to both tables from my Spring Boot application with Hibernate.

My problem is, that Hibernate generates the following query:

SELECT 1 FROM ONLY "Table A" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x

that needs UPDATE permissions (and the user don't have them). The FOR KEY SHARE query should be a lock for the foreign key relation, if I understand it correctly.

My Table A entity is annotated with @Immutable, but it doesn't seem to work. The @JoinColumn(updatable = false) either.

How can I say Hibernate that I don't want this lock?

java postgresql hibernate spring-boot

share|improve this question

edited Mar 28 at 22:43

vkirilichev

asked Mar 28 at 17:37

vkirilichevvkirilichev

8666 bronze badges

SELECT 1 FROM ONLY "Table A" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x

share|improve this question

edited Mar 28 at 22:43

vkirilichev

asked Mar 28 at 17:37

vkirilichevvkirilichev

8666 bronze badges

share|improve this question

edited Mar 28 at 22:43

vkirilichev

asked Mar 28 at 17:37

vkirilichevvkirilichev

8666 bronze badges

asked Mar 28 at 17:37

vkirilichevvkirilichev

8666 bronze badges

asked Mar 28 at 17:37

vkirilichevvkirilichev

8666 bronze badges