August 2020 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-14153) HQL update query with multiple condition generates temporary tables on SQLServer

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14153 ( https://hibernate.atlassian.net/browse/HHH-14153?atlOrigin=eyJpIjoiZjYxMD... ) Re: HQL update query with multiple condition generates temporary tables on SQLServer ( https://hibernate.atlassian.net/browse/HHH-14153?atlOrigin=eyJpIjoiZjYxMD... ) The entity names suggest that inheritance is involved. Could you post the model or even better, a reproducing test case so we can take a look. This is obviously a missed opportunity for an optimization that we should take. ( https://hibernate.atlassian.net/browse/HHH-14153#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14153#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#100144- sha1:b6d623e )

4 years, 4 months

1
0
0 / 0

[JIRA] (HHH-14152) Query fails after upgrading to 5.4.20.Final

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14152 ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiMGYxNG... ) Re: Query fails after upgrading to 5.4.20.Final ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiMGYxNG... ) Hi Scott Roehrig ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) can you please provide a test case. Thanks ( https://hibernate.atlassian.net/browse/HHH-14152#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14152#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#100144- sha1:b6d623e )

4 years, 4 months

1
0
0 / 0

[JIRA] (HHH-14153) HQL update query with multiple condition generates temporary tables on SQLServer

by François DAMBRINE (JIRA)

François DAMBRINE ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c07a50... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzFmYWRhMGRk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14153?atlOrigin=eyJpIjoiMzFmYW... ) HHH-14153 ( https://hibernate.atlassian.net/browse/HHH-14153?atlOrigin=eyJpIjoiMzFmYW... ) HQL update query with multiple condition generates temporary tables on SQLServer ( https://hibernate.atlassian.net/browse/HHH-14153?atlOrigin=eyJpIjoiMzFmYW... ) Issue Type: Bug Affects Versions: 5.4.10, 5.4.19 Assignee: Unassigned Components: hibernate-core Created: 13/Aug/2020 00:14 AM Environment: Windows Server 2019 SQLServer 2016 hibernate-core 5.4.19 (also tested with 5.4.10) hibernate-c3p0 5.4.19 (also tested with 5.4.10) Labels: HQL Priority: Major Reporter: François DAMBRINE ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c07a50... ) When we try to run an HQL UPDATE query that will update a table with a set of two conditions, hibernate split the query in three parts : * create a temp table * insert all matching records in this table * launch update query This only happen with SQLServer, the main issue is that HHH-3326 ( https://hibernate.atlassian.net/browse/HHH-3326 ) Open is not yet fixed, so, when the SQLServer tempdb has a collation that is not compatible with our current db, the query just fails with a collation conflict. *Minimal code to reproduce* Query q = entityManager.createQuery( "UPDATE abstracttaskentity e SET " + "e.locked = true " + "WHERE e.locked = false AND e.taskId = :id" ); q.setParameter( "id" , taskToAcquire.getTaskId()); entityManager.getTransaction().commit(); *Hibernate query log* Hibernate: create table #abstracttaskentity ( id varchar(255) not null ) Hibernate: insert into #abstracttaskentity select abstractta0_.id as id from abstracttaskentity abstractta0_ where abstractta0_.locked=0 and abstractta0_.id=? Hibernate: update abstracttaskentity set locked=1, where ( id ) IN ( select id from #abstracttaskentity ) ( https://hibernate.atlassian.net/browse/HHH-14153#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14153#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#100144- sha1:b6d623e )

4 years, 4 months

1
0
0 / 0

[JIRA] (HHH-14152) Query fails after upgrading to 5.4.20.Final

by Nathan Xu (JIRA)

Nathan Xu ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14152 ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiMWU2M2... ) Re: Query fails after upgrading to 5.4.20.Final ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiMWU2M2... ) We did change something in hydrated stuff and TwoPhaseLoad in this release. I would appreciate if you can help reproduce the issue either by attaching your code, creating a broken Hibernate testing cass or even created a git repo. Logging is good when you have access to code, but would be intimidating without code. ( https://hibernate.atlassian.net/browse/HHH-14152#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14152#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#100144- sha1:b6d623e )

4 years, 4 months

1
0
0 / 0

[JIRA] (HHH-14152) Query fails after upgrading to 5.4.20.Final

by Scott Roehrig (JIRA)

Scott Roehrig ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14152 ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiNTI1MT... ) Re: Query fails after upgrading to 5.4.20.Final ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiNTI1MT... ) There is a difference in traces between the 2 runs. The failing run doesn’t hydrate and it has HQLParser trace entries (perhaps that is new). ( https://hibernate.atlassian.net/browse/HHH-14152#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14152#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#100144- sha1:57e1ab7 )

4 years, 4 months

1
0
0 / 0

[JIRA] (HHH-14152) Query fails after upgrading to 5.4.20.Final

by Scott Roehrig (JIRA)

4 years, 4 months

1
0
0 / 0

[JIRA] (HHH-14152) Query fails after upgrading to 5.4.20.Final

by Scott Roehrig (JIRA)

4 years, 4 months

1
0
0 / 0

[JIRA] (HHH-14152) Query fails after upgrading to 5.4.20.Final

by Scott Roehrig (JIRA)

Scott Roehrig ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14152 ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiYTA0Zj... ) Re: Query fails after upgrading to 5.4.20.Final ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiYTA0Zj... ) I am baffled at the moment… I will see if I can compare the traces further.. ( https://hibernate.atlassian.net/browse/HHH-14152#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14152#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#100144- sha1:57e1ab7 )

4 years, 4 months

1
0
0 / 0

[JIRA] (HHH-14152) Query fails after upgrading to 5.4.20.Final

by Scott Roehrig (JIRA)

Scott Roehrig ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14152 ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiNjI1ZW... ) Re: Query fails after upgrading to 5.4.20.Final ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiNjI1ZW... ) I would agree with that! The 5.4.19 version of the query is here: SQL - select distinct issuerimpl0_.ISSUER as issuer2_14_, issuerimpl0_.IDENTIFIER as identifi3_14_, issuerimpl0_.CREATED as created4_14_, issuerimpl0_.CREATOR_ISSUER as creator13_14_, issuerimpl0_.CREATOR_IDENTIFIER as creator14_14_, issuerimpl0_.ENTITY as entity1_14_, issuerimpl0_.EXPIRATION as expirati5_14_, issuerimpl0_.EXTERNAL_IDENTIFIER as external6_14_, issuerimpl0_.MIMETYPE as mimetype7_14_, issuerimpl0_.MODIFIED as modified8_14_, issuerimpl0_.MODIFIER_ISSUER as modifie15_14_, issuerimpl0_.MODIFIER_IDENTIFIER as modifie16_14_, issuerimpl0_.NAME as name9_14_, issuerimpl0_.URI as uri10_14_, issuerimpl0_.VERSION as version11_14_, issuerimpl0_1_.NAME as name1_10_, issuerimpl0_1_.PARENT_ISSUER as parent_i2_10_, issuerimpl0_1_.PARENT_IDENTIFIER as parent_i3_10_ from RESOURCES issuerimpl0_ inner join ISSUERS issuerimpl0_1_ on issuerimpl0_.ISSUER=issuerimpl0_1_.ISSUER and issuerimpl0_.IDENTIFIER=issuerimpl0_1_.IDENTIFIER where issuerimpl0_.ENTITY='IssuerImpl' and issuerimpl0_.ISSUER=? and issuerimpl0_.IDENTIFIER=? BUT the query looks the same to me offhand but the result IS returned in 5.4.19 because it then goes into hyrdration for the object… [TRACE] 2020-08-12 19:10:51.398 [main] JdbcCoordinatorImpl - Registering last query statement [HikariProxyPreparedStatement@1809367960 wrapping org.hsqldb.jdbc.JDBCPreparedStatement@1f7949dc[sql=[select distinct issuerimpl0_.ISSUER as issuer2_14_, issuerimpl0_.IDENTIFIER as identifi3_14_, issuerimpl0_.CREATED as created4_14_, issuerimpl0_.CREATOR_ISSUER as creator13_14_, issuerimpl0_.CREATOR_IDENTIFIER as creator14_14_, issuerimpl0_.ENTITY as entity1_14_, issuerimpl0_.EXPIRATION as expirati5_14_, issuerimpl0_.EXTERNAL_IDENTIFIER as external6_14_, issuerimpl0_.MIMETYPE as mimetype7_14_, issuerimpl0_.MODIFIED as modified8_14_, issuerimpl0_.MODIFIER_ISSUER as modifie15_14_, issuerimpl0_.MODIFIER_IDENTIFIER as modifie16_14_, issuerimpl0_.NAME as name9_14_, issuerimpl0_.URI as uri10_14_, issuerimpl0_.VERSION as version11_14_, issuerimpl0_1_.NAME as name1_10_, issuerimpl0_1_.PARENT_ISSUER as parent_i2_10_, issuerimpl0_1_.PARENT_IDENTIFIER as parent_i3_10_ from RESOURCES issuerimpl0_ inner join ISSUERS issuerimpl0_1_ on issuerimpl0_.ISSUER=issuerimpl0_1_.ISSUER and issuerimpl0_.IDENTIFIER=issuerimpl0_1_.IDENTIFIER where issuerimpl0_.ENTITY='IssuerImpl' and issuerimpl0_.ISSUER=? and issuerimpl0_.IDENTIFIER=?], parameters=[[null], [null]]]] [TRACE] 2020-08-12 19:10:51.403 [main] BasicBinder - binding parameter [1] as [BIGINT] - [1] [TRACE] 2020-08-12 19:10:51.403 [main] BasicBinder - binding parameter [1] as [BIGINT] - [1] [TRACE] 2020-08-12 19:10:51.404 [main] BasicBinder - binding parameter [2] as [NVARCHAR] - [1] [TRACE] 2020-08-12 19:10:51.404 [main] BasicBinder - binding parameter [2] as [NVARCHAR] - [1] [DEBUG] 2020-08-12 19:10:51.404 [main] Loader - Lock timeout [180000] requested but dialect reported to not support lock timeouts [DEBUG] 2020-08-12 19:10:51.404 [main] Loader - Lock timeout [180000] requested but dialect reported to not support lock timeouts [TRACE] 2020-08-12 19:10:51.446 [main] Loader - Bound [3] parameters total [TRACE] 2020-08-12 19:10:51.446 [main] Loader - Bound [3] parameters total [TRACE] 2020-08-12 19:10:51.451 [main] ResourceRegistryStandardImpl - Registering result set [HikariProxyResultSet@1269555311 wrapping org.hsqldb.jdbc.JDBCResultSet@5c6be812] [TRACE] 2020-08-12 19:10:51.451 [main] ResourceRegistryStandardImpl - Registering result set [HikariProxyResultSet@1269555311 wrapping org.hsqldb.jdbc.JDBCResultSet@5c6be812] [TRACE] 2020-08-12 19:10:51.452 [main] Loader - Processing result set [TRACE] 2020-08-12 19:10:51.452 [main] Loader - Processing result set [DEBUG] 2020-08-12 19:10:51.453 [main] Loader - Result set row: 0 [DEBUG] 2020-08-12 19:10:51.453 [main] Loader - Result set row: 0 [TRACE] 2020-08-12 19:10:51.454 [main] BasicExtractor - extracted value ([issuer2_14_] : [BIGINT]) - [1] [TRACE] 2020-08-12 19:10:51.454 [main] BasicExtractor - extracted value ([issuer2_14_] : [BIGINT]) - [1] [TRACE] 2020-08-12 19:10:51.455 [main] BasicExtractor - extracted value ([identifi3_14_] : [NVARCHAR]) - [1] [TRACE] 2020-08-12 19:10:51.455 [main] BasicExtractor - extracted value ([identifi3_14_] : [NVARCHAR]) - [1] [DEBUG] 2020-08-12 19:10:51.459 [main] Loader - Result row: EntityKey[com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [DEBUG] 2020-08-12 19:10:51.459 [main] Loader - Result row: EntityKey[com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [TRACE] 2020-08-12 19:10:51.459 [main] Loader - Initializing object from ResultSet: [com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [TRACE] 2020-08-12 19:10:51.459 [main] Loader - Initializing object from ResultSet: [com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [TRACE] 2020-08-12 19:10:51.470 [main] AbstractEntityPersister - Hydrating entity: [com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [TRACE] 2020-08-12 19:10:51.470 [main] AbstractEntityPersister - Hydrating entity: [com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([created4_14_] : [TIMESTAMP]) - [2020-08-12T14:10:49.450-05:00[America/Chicago]] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([created4_14_] : [TIMESTAMP]) - [2020-08-12T14:10:49.450-05:00[America/Chicago]] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([creator13_14_] : [BIGINT]) - [null] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([creator13_14_] : [BIGINT]) - [null] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([entity1_14_] : [NVARCHAR]) - [IssuerImpl] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([entity1_14_] : [NVARCHAR]) - [IssuerImpl] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([expirati5_14_] : [TIMESTAMP]) - [null] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([expirati5_14_] : [TIMESTAMP]) - [null] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([external6_14_] : [NVARCHAR]) - [null] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([external6_14_] : [NVARCHAR]) - [null] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([mimetype7_14_] : [NVARCHAR]) - [null] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([mimetype7_14_] : [NVARCHAR]) - [null] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([modified8_14_] : [TIMESTAMP]) - [2020-08-12T14:10:49.450-05:00[America/Chicago]] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([modified8_14_] : [TIMESTAMP]) - [2020-08-12T14:10:49.450-05:00[America/Chicago]] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([modifie15_14_] : [BIGINT]) - [null] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([modifie15_14_] : [BIGINT]) - [null] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([name9_14_] : [NVARCHAR]) - [BIPlatform] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([name9_14_] : [NVARCHAR]) - [BIPlatform] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([uri10_14_] : [NVARCHAR]) - [ https://localhost:8443/biw/platform/simulator/manager |https://localhost:8443/biw/platform/simulator/manager%5D] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([uri10_14_] : [NVARCHAR]) - [ https://localhost:8443/biw/platform/simulator/manager |https://localhost:8443/biw/platform/simulator/manager%5D] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([version11_14_] : [BIGINT]) - [0] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([version11_14_] : [BIGINT]) - [0] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([name1_10_] : [NVARCHAR]) - [BIPlatform] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([name1_10_] : [NVARCHAR]) - [BIPlatform] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([parent_i2_10_] : [BIGINT]) - [null] [TRACE] 2020-08-12 19:10:51.481 [main] BasicExtractor - extracted value ([parent_i2_10_] : [BIGINT]) - [null] [TRACE] 2020-08-12 19:10:51.525 [main] TwoPhaseLoad - Version: 0 [TRACE] 2020-08-12 19:10:51.525 [main] TwoPhaseLoad - Version: 0 [TRACE] 2020-08-12 19:10:51.526 [main] Loader - Done processing result set (1 rows) [TRACE] 2020-08-12 19:10:51.526 [main] Loader - Done processing result set (1 rows) [TRACE] 2020-08-12 19:10:51.528 [main] Loader - Total objects hydrated: 1 [TRACE] 2020-08-12 19:10:51.528 [main] Loader - Total objects hydrated: 1 [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Resolving attributes for [com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Resolving attributes for [com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute created : value = 2020-08-12T14:10:49.450-05:00[America/Chicago] [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute created : value = 2020-08-12T14:10:49.450-05:00[America/Chicago] [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( created ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( created ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute creator : value = null [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute creator : value = null [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( creator ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( creator ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute entity : value = IssuerImpl [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute entity : value = IssuerImpl [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( entity ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( entity ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute expiration : value = null [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute expiration : value = null [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( expiration ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( expiration ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute externalidentifier : value = null [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute externalidentifier : value = null [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( externalidentifier ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( externalidentifier ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute mimetype : value = null [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute mimetype : value = null [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( mimetype ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Attribute ( mimetype ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute modified : value = 2020-08-12T14:10:49.450-05:00[America/Chicago] [DEBUG] 2020-08-12 19:10:51.531 [main] TwoPhaseLoad - Processing attribute modified : value = 2020-08-12T14:10:49.450-05:00[America/Chicago] [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( modified ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( modified ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Processing attribute modifier : value = null [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Processing attribute modifier : value = null [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( modifier ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( modifier ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Processing attribute name : value = BIPlatform [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Processing attribute name : value = BIPlatform [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( name ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( name ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Processing attribute uri : value = https://localhost:8443/biw/platform/simulator/manager [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Processing attribute uri : value = https://localhost:8443/biw/platform/simulator/manager [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( uri ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( uri ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Processing attribute version : value = 0 [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Processing attribute version : value = 0 [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( version ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( version ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Processing attribute value : value = NOT NULL COLLECTION [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Processing attribute value : value = NOT NULL COLLECTION [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( value ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.532 [main] TwoPhaseLoad - Attribute ( value ) - enhanced for lazy-loading? - false [TRACE] 2020-08-12 19:10:51.556 [main] CollectionType - Created collection wrapper: [com.gemalto.ics.usplatform.bip.ResourceCollectionImpl.value#component[issuer,value]{value=1, issuer=1}] [TRACE] 2020-08-12 19:10:51.556 [main] CollectionType - Created collection wrapper: [com.gemalto.ics.usplatform.bip.ResourceCollectionImpl.value#component[issuer,value]{value=1, issuer=1}] [DEBUG] 2020-08-12 19:10:51.556 [main] TwoPhaseLoad - Processing attribute name1 : value = BIPlatform [DEBUG] 2020-08-12 19:10:51.556 [main] TwoPhaseLoad - Processing attribute name1 : value = BIPlatform [DEBUG] 2020-08-12 19:10:51.556 [main] TwoPhaseLoad - Attribute ( name1 ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.556 [main] TwoPhaseLoad - Attribute ( name1 ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.556 [main] TwoPhaseLoad - Processing attribute parentIssuer : value = null [DEBUG] 2020-08-12 19:10:51.556 [main] TwoPhaseLoad - Processing attribute parentIssuer : value = null [DEBUG] 2020-08-12 19:10:51.556 [main] TwoPhaseLoad - Attribute ( parentIssuer ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.556 [main] TwoPhaseLoad - Attribute ( parentIssuer ) - enhanced for lazy-loading? - false [DEBUG] 2020-08-12 19:10:51.556 [main] TwoPhaseLoad - Adding entity to second-level cache: [com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [DEBUG] 2020-08-12 19:10:51.556 [main] TwoPhaseLoad - Adding entity to second-level cache: [com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [DEBUG] 2020-08-12 19:10:51.593 [main] AbstractReadWriteAccess - Caching data from load [region= com.gemalto.ics.usplatform.bip.Resource (AccessType[read-write])] : key[com.gemalto.ics.usplatform.bip.ResourceImpl#{"issuer":1,"value":"1"}] -> value[CacheEntry(com.gemalto.ics.usplatform.bip.IssuerImpl)] [DEBUG] 2020-08-12 19:10:51.593 [main] AbstractReadWriteAccess - Caching data from load [region= com.gemalto.ics.usplatform.bip.Resource (AccessType[read-write])] : key[com.gemalto.ics.usplatform.bip.ResourceImpl#{"issuer":1,"value":"1"}] -> value[CacheEntry(com.gemalto.ics.usplatform.bip.IssuerImpl)] [DEBUG] 2020-08-12 19:10:51.677 [main] TwoPhaseLoad - Done materializing entity [com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [DEBUG] 2020-08-12 19:10:51.677 [main] TwoPhaseLoad - Done materializing entity [com.gemalto.ics.usplatform.bip.IssuerImpl#component[issuer,value]{value=1, issuer=1}] [TRACE] 2020-08-12 19:10:51.680 [main] ResourceRegistryStandardImpl - Releasing statement [HikariProxyPreparedStatement@1809367960 wrapping org.hsqldb.jdbc.JDBCPreparedStatement@1f7949dc[sql=[select distinct issuerimpl0_.ISSUER as issuer2_14_, issuerimpl0_.IDENTIFIER as identifi3_14_, issuerimpl0_.CREATED as created4_14_, issuerimpl0_.CREATOR_ISSUER as creator13_14_, issuerimpl0_.CREATOR_IDENTIFIER as creator14_14_, issuerimpl0_.ENTITY as entity1_14_, issuerimpl0_.EXPIRATION as expirati5_14_, issuerimpl0_.EXTERNAL_IDENTIFIER as external6_14_, issuerimpl0_.MIMETYPE as mimetype7_14_, issuerimpl0_.MODIFIED as modified8_14_, issuerimpl0_.MODIFIER_ISSUER as modifie15_14_, issuerimpl0_.MODIFIER_IDENTIFIER as modifie16_14_, issuerimpl0_.NAME as name9_14_, issuerimpl0_.URI as uri10_14_, issuerimpl0_.VERSION as version11_14_, issuerimpl0_1_.NAME as name1_10_, issuerimpl0_1_.PARENT_ISSUER as parent_i2_10_, issuerimpl0_1_.PARENT_IDENTIFIER as parent_i3_10_ from RESOURCES issuerimpl0_ inner join ISSUERS issuerimpl0_1_ on issuerimpl0_.ISSUER=issuerimpl0_1_.ISSUER and issuerimpl0_.IDENTIFIER=issuerimpl0_1_.IDENTIFIER where issuerimpl0_.ENTITY='IssuerImpl' and issuerimpl0_.ISSUER=? and issuerimpl0_.IDENTIFIER=?], parameters=[[1], [1]]]] [TRACE] 2020-08-12 19:10:51.680 [main] ResourceRegistryStandardImpl - Releasing statement [HikariProxyPreparedStatement@1809367960 wrapping org.hsqldb.jdbc.JDBCPreparedStatement@1f7949dc[sql=[select distinct issuerimpl0_.ISSUER as issuer2_14_, issuerimpl0_.IDENTIFIER as identifi3_14_, issuerimpl0_.CREATED as created4_14_, issuerimpl0_.CREATOR_ISSUER as creator13_14_, issuerimpl0_.CREATOR_IDENTIFIER as creator14_14_, issuerimpl0_.ENTITY as entity1_14_, issuerimpl0_.EXPIRATION as expirati5_14_, issuerimpl0_.EXTERNAL_IDENTIFIER as external6_14_, issuerimpl0_.MIMETYPE as mimetype7_14_, issuerimpl0_.MODIFIED as modified8_14_, issuerimpl0_.MODIFIER_ISSUER as modifie15_14_, issuerimpl0_.MODIFIER_IDENTIFIER as modifie16_14_, issuerimpl0_.NAME as name9_14_, issuerimpl0_.URI as uri10_14_, issuerimpl0_.VERSION as version11_14_, issuerimpl0_1_.NAME as name1_10_, issuerimpl0_1_.PARENT_ISSUER as parent_i2_10_, issuerimpl0_1_.PARENT_IDENTIFIER as parent_i3_10_ from RESOURCES issuerimpl0_ inner join ISSUERS issuerimpl0_1_ on issuerimpl0_.ISSUER=issuerimpl0_1_.ISSUER and issuerimpl0_.IDENTIFIER=issuerimpl0_1_.IDENTIFIER where issuerimpl0_.ENTITY='IssuerImpl' and issuerimpl0_.ISSUER=? and issuerimpl0_.IDENTIFIER=?], parameters=[[1], [1]]]] [TRACE] 2020-08-12 19:10:51.681 [main] ResourceRegistryStandardImpl - Closing result set [HikariProxyResultSet@1269555311 wrapping org.hsqldb.jdbc.JDBCResultSet@5c6be812] ( https://hibernate.atlassian.net/browse/HHH-14152#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14152#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#100144- sha1:57e1ab7 )

4 years, 4 months

1
0
0 / 0

[JIRA] (HHH-10963) EntityManager.persist() not throwing EntityExistsException for existing row in database

by Scott Roehrig (JIRA)

Scott Roehrig ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-10963 ( https://hibernate.atlassian.net/browse/HHH-10963?atlOrigin=eyJpIjoiN2VkNT... ) Re: EntityManager.persist() not throwing EntityExistsException for existing row in database ( https://hibernate.atlassian.net/browse/HHH-10963?atlOrigin=eyJpIjoiN2VkNT... ) So apparently I am WAY behind. Can you please close this off? I can’t seem to cancel it to get rid of it from your lists ( https://hibernate.atlassian.net/browse/HHH-10963#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-10963#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#100144- sha1:57e1ab7 )

4 years, 4 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 August 2020