October 2022 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-15592) Use of JdbcExceptionHelper.extractSqlState in string switches causes NPE

by Brian Stansberry (JIRA)

Brian Stansberry ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZmEwMDUyNDk5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15592?atlOrigin=eyJpIjoiZmEwMD... ) HHH-15592 ( https://hibernate.atlassian.net/browse/HHH-15592?atlOrigin=eyJpIjoiZmEwMD... ) Use of JdbcExceptionHelper.extractSqlState in string switches causes NPE ( https://hibernate.atlassian.net/browse/HHH-15592?atlOrigin=eyJpIjoiZmEwMD... ) Issue Type: Bug Affects Versions: 6.1.4 Assignee: Unassigned Components: hibernate-core Created: 10/Oct/2022 15:52 PM Priority: Major Reporter: Brian Stansberry ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) A number of dialects use the return value from JdbcExceptionHelper.extractSqlState( SQLException ) in a string switch statement. The problem is that method may return null, which will result in an NPE, a la https://wildfly.zulipchat.com/#narrow/stream/174184-wildfly-developers/to... ( https://wildfly.zulipchat.com/#narrow/stream/174184-wildfly-developers/to... ) JdbcExceptionHelper.extractSqlState returns the value of the SQLException.SQLState field, but that can be null. It for sure will be if the new SQLException(String reason) constructor is used. It can be with the other constructors too as none of them reject a null param value. MySQLDialect, PostgreSQLDialect and SybaseASEDialect all look like they’d have this problem. ( https://hibernate.atlassian.net/browse/HHH-15592#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15592#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:591c2ef )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15591) Unidirectional @OneToMany with @OrderColumn still throwing ConstraintViolationException (unique index violation)

by Burkhard Graves (JIRA)

Burkhard Graves ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTk2YWZlZDcx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiZTk2YW... ) HHH-15591 ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiZTk2YW... ) Unidirectional @OneToMany with @OrderColumn still throwing ConstraintViolationException (unique index violation) ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiZTk2YW... ) Change By: Burkhard Graves ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) There are several tickets dealing with this setup, see linked issues. What seems to work: * Adding one or more elements to the list * Removing one or more elements from the list What still does not work: * Swapping elements in the list * Simultaneously adding and removing elements from the list I added created a PR which adds two tests to {{UnidirectionalOneToManyOrderColumnTest}}, namely {code:java} @Test public void testSwapElementsAtZeroAndOne(EntityManagerFactoryScope scope) { long parentId = scope.fromTransaction( entityManager -> { ParentData parent = new ParentData(); entityManager.persist( parent ); String[] childrenStr = new String[] {"One", "Two"}; for ( String str : childrenStr ) { ChildData child = new ChildData( str ); entityManager.persist( child ); parent.getChildren().add( child ); } entityManager.flush(); List<ChildData> children = parent.getChildren(); ChildData child0 = children.get( 0 ); ChildData child1 = children.get( 1 ); children.set(0, child1); children.set(1, child0); return parent.id; } ); // if the above works, then test on {"Two", "One"} } @Test public void testAddAtZeroDeleteAtTwo(EntityManagerFactoryScope scope) { long parentId = scope.fromTransaction( entityManager -> { ParentData parent = new ParentData(); entityManager.persist( parent ); String[] childrenStr = new String[] {"One", "Two"}; for ( String str : childrenStr ) { ChildData child = new ChildData( str ); entityManager.persist( child ); parent.getChildren().add( child ); } entityManager.flush(); List<ChildData> children = parent.getChildren(); children.add( 0, new ChildData( "Zero" ) ); children.remove( 2 ); return parent.id; } ); // if the above works, then test on {"Zero", "One"} }{code} Both tests fail (in h2 and presumably many other databases). ( https://hibernate.atlassian.net/browse/HHH-15591#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15591#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:591c2ef )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15591) Unidirectional @OneToMany with @OrderColumn still throwing ConstraintViolationException (unique index violation)

by Burkhard Graves (JIRA)

Burkhard Graves ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNzNhOTExMmIx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiNzNhOT... ) HHH-15591 ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiNzNhOT... ) Unidirectional @OneToMany with @OrderColumn still throwing ConstraintViolationException (unique index violation) ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiNzNhOT... ) Change By: Burkhard Graves ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) There are several tickets dealing with this setup, see linked issues. What seems to work: * Adding one or more elements to the list * Removing one or more elements from the list What still does not work: * Swapping elements in the list * Simultaneously adding and removing elements from the list I added a PR which adds to two tests to {{UnidirectionalOneToManyOrderColumnTest}}, namely {code:java} @Test public void testSwapElementsAtZeroAndOne(EntityManagerFactoryScope scope) { long parentId = scope.fromTransaction( entityManager -> { ParentData parent = new ParentData(); entityManager.persist( parent ); String[] childrenStr = new String[] {"One", "Two"}; for ( String str : childrenStr ) { ChildData child = new ChildData( str ); entityManager.persist( child ); parent.getChildren().add( child ); } entityManager.flush(); List<ChildData> children = parent.getChildren(); ChildData child0 = children.get( 0 ); ChildData child1 = children.get( 1 ); children.set(0, child1); children.set(1, child0); return parent.id; } ); // if the above works, then test on {"Two", "One"} } @Test public void testAddAtZeroDeleteAtTwo(EntityManagerFactoryScope scope) { long parentId = scope.fromTransaction( entityManager -> { ParentData parent = new ParentData(); entityManager.persist( parent ); String[] childrenStr = new String[] {"One", "Two"}; for ( String str : childrenStr ) { ChildData child = new ChildData( str ); entityManager.persist( child ); parent.getChildren().add( child ); } entityManager.flush(); List<ChildData> children = parent.getChildren(); children.add( 0, new ChildData( "Zero" ) ); children.remove( 2 ); return parent.id; } ); // if the above works, then test on {"Zero", "One"} }{code} Both tests fail (in h2 and presumably many other databases). ( https://hibernate.atlassian.net/browse/HHH-15591#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15591#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:591c2ef )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15591) Unidirectional @OneToMany with @OrderColumn still throwing ConstraintViolationException (unique index violation)

by Burkhard Graves (JIRA)

Burkhard Graves ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjU4Nzk0MTEy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiNjU4Nz... ) HHH-15591 ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiNjU4Nz... ) Unidirectional @OneToMany with @OrderColumn still throwing ConstraintViolationException (unique index violation) ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiNjU4Nz... ) Change By: Burkhard Graves ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) There are several tickets dealing with this setup, see linked issues. What seems to work: * Adding one or more elements to the list * Removing one or more elements from the list What still does not work: * Swapping elements in the list * Simultaneously adding and removing elements from the list I added a PR which adds to tests to {{UnidirectionalOneToManyOrderColumnTest}}, namely {code:java} @Test public void testSwapElementsAtZeroAndOne(EntityManagerFactoryScope scope) { long parentId = scope.fromTransaction( entityManager -> { ParentData parent = new ParentData(); entityManager.persist( parent ); String[] childrenStr = new String[] {"One", "Two"}; for ( String str : childrenStr ) { ChildData child = new ChildData( str ); entityManager.persist( child ); parent.getChildren().add( child ); } entityManager.flush(); List<ChildData> children = parent.getChildren(); ChildData child0 = children.get( 0 ); ChildData child1 = children.get( 1 ); children.set(0, child1); children.set(1, child0); return parent.id; } ); // if the above works, then test on {"Two", "One"} } @Test public void testAddAtZeroDeleteAtTwo(EntityManagerFactoryScope scope) { long parentId = scope.fromTransaction( entityManager -> { ParentData parent = new ParentData(); entityManager.persist( parent ); String[] childrenStr = new String[] {"One", "Two"}; for ( String str : childrenStr ) { ChildData child = new ChildData( str ); entityManager.persist( child ); parent.getChildren().add( child ); } entityManager.flush(); List<ChildData> children = parent.getChildren(); children.add( 0, new ChildData( "Zero" ) ); children.remove( 2 ); return parent.id; } ); // if the above works, then test on {"Zero", "One"} }{code} Both tests fail (in h2 and presumably many other databases). ( https://hibernate.atlassian.net/browse/HHH-15591#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15591#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:591c2ef )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15591) Unidirectional @OneToMany with @OrderColumn still throwing ConstraintViolationException (unique index violation)

by Burkhard Graves (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15591) Unidirectional @OneToMany with @OrderColumn still throwing ConstraintViolationException (unique index violation)

by Burkhard Graves (JIRA)

Burkhard Graves ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiM2U4N2Y1MjY5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiM2U4N2... ) HHH-15591 ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiM2U4N2... ) Unidirectional @OneToMany with @OrderColumn still throwing ConstraintViolationException (unique index violation) ( https://hibernate.atlassian.net/browse/HHH-15591?atlOrigin=eyJpIjoiM2U4N2... ) Issue Type: Bug Affects Versions: 5.6.12, 6.1.4 Assignee: Unassigned Components: hibernate-core Created: 10/Oct/2022 11:15 AM Environment: java 11, linux, h2 Priority: Major Reporter: Burkhard Graves ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) There are several tickets dealing with this setup, see linked issues. What seems to work: * Adding one or more elements to the list * Removing one or more elements from the list What still does not work: * Swapping elements in the list * Simultaneously adding and removing elements from the list ( https://hibernate.atlassian.net/browse/HHH-15591#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15591#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:591c2ef )

1 year, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4705) Merge the various implementations of ElasticsearchTestDialect

by Automation for Jira (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HBX-2405) Update version identifier to 5.6.13-SNAPSHOT

by Koen Aers (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HBX-2411) Update JUnit Jupiter dependency to 5.9.1

by Koen Aers (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HBX-2411) Update JUnit Jupiter dependency to 5.9.1

by Koen Aers (JIRA)

1 year, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues October 2022