May 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16554) UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements

by Ahmet Tanakol (JIRA)

Ahmet Tanakol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDcxY2I2YTUy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiZDcxY2... ) HHH-16554 ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiZDcxY2... ) UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiZDcxY2... ) Change By: Ahmet Tanakol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hello Hibernate Team, I was updating our SpringBoot version from 2.x to 3.x, and I am having trouble with starting our app. I created the tables by using liquibase in the past. When I start my application I see the below exception. {code:java} Suppressed: java.lang.UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements as well at org.hibernate.query.sqm.mutation.internal.cte.CteInsertStrategy.<init>(CteInsertStrategy.java:123) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final] at org.hibernate.query.sqm.mutation.internal.cte.CteInsertStrategy.<init>(CteInsertStrategy.java:107) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final] at org.hibernate.dialect.PostgreSQLDialect.getFallbackSqmInsertStrategy(PostgreSQLDialect.java:828) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]{code} One of my entites looks like the following (I created the sequence in liquibase changelog file) ; {noformat}import com.fasterxml.jackson.annotation.JsonIgnore; import java.time.OffsetDateTime; import jakarta.persistence.Column; import jakarta.persistence.Entity; import jakarta.persistence.GeneratedValue; import jakarta.persistence.GenerationType; import jakarta.persistence.Id; import lombok.AllArgsConstructor; import lombok.Builder; import lombok.Data; import lombok.NoArgsConstructor; import org.hibernate.annotations.CreationTimestamp; import org.hibernate.annotations.GenericGenerator; import org.hibernate.annotations.Parameter; import org.hibernate.annotations.UpdateTimestamp; import org.hibernate.envers.Audited; @Data @Entity @Builder @NoArgsConstructor @AllArgsConstructor @Audited public class PaymentAccount { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "payment_account_seq") @GenericGenerator( name = "payment_account_seq", strategy = "org.hibernate.id.enhanced.SequenceStyleGenerator", parameters = {@Parameter(name = "sequence_name", value = "payment_account_seq")}) @JsonIgnore private Long id; private String ciamId; private String providerName; private String providerUserId; @CreationTimestamp @Column(updatable = false) private OffsetDateTime createdAt; @UpdateTimestamp private OffsetDateTime updatedAt; } {noformat} I couldn’t be sure what is causing this issue. I would appreciate if you can help me solve it. You can find the configuration I use below. * hibernate-envers: 6.1.7.Final * hibernate-core: 6.1.7.Final * hibernate-commons-annotations:6.0.6.Final * spring-boot-starter-data-jpa:3.0.6 * postgresql jdbc driver:42.5.4 * postgres 14 {noformat} datasource: url: jdbc:postgresql://localhost:8086/mydb username: admin password: admin driver-class-name: org.postgresql.Driver hikari: maximum-pool-size: 12 idle-timeout: 60000 pool-name: BackendHikariPool connection-timeout: 45000 minimum-idle: 1 connection-test-query: SELECT 1 type: com.zaxxer.hikari.HikariDataSource jpa: show-sql: false open-in-view: false hibernate: ddl-auto: none properties: org.hibernate.envers.do_not_audit_optimistic_locking_field: false hibernate: namingStrategy: org.hibernate.cfg.ImprovedNamingStrategy dialect: org.hibernate.dialect.PostgreSQLDialect hbm2ddl: auto: none temp: use_jdbc_metadata_defaults: false sql: init: continue-on-error: true platform: org.hibernate.dialect.PostgreSQLDialect{noformat} ( https://hibernate.atlassian.net/browse/HHH-16554#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16554#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HBX-2390) Create a JBoss Tools adaptation layer

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-2134) Resolve test errors/failures for Oracle

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16554) UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements

by Ahmet Tanakol (JIRA)

Ahmet Tanakol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZmFkOWZjOTdm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiZmFkOW... ) HHH-16554 ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiZmFkOW... ) UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiZmFkOW... ) Change By: Ahmet Tanakol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hello Hibernate Team, I was updating our SpringBoot version from 2.x to 3.x, and I am having trouble with starting our app. I created the tables by using liquibase in the past. When I start my application I see the below exception. {code:java} Suppressed: java.lang.UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements as well at org.hibernate.query.sqm.mutation.internal.cte.CteInsertStrategy.<init>(CteInsertStrategy.java:123) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final] at org.hibernate.query.sqm.mutation.internal.cte.CteInsertStrategy.<init>(CteInsertStrategy.java:107) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final] at org.hibernate.dialect.PostgreSQLDialect.getFallbackSqmInsertStrategy(PostgreSQLDialect.java:828) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]{code} One of my entites looks like the following; {noformat}import com.fasterxml.jackson.annotation.JsonIgnore; import java.time.OffsetDateTime; import jakarta.persistence.Column; import jakarta.persistence.Entity; import jakarta.persistence.GeneratedValue; import jakarta.persistence.GenerationType; import jakarta.persistence.Id; import lombok.AllArgsConstructor; import lombok.Builder; import lombok.Data; import lombok.NoArgsConstructor; import org.hibernate.annotations.CreationTimestamp; import org.hibernate.annotations.GenericGenerator; import org.hibernate.annotations.Parameter; import org.hibernate.annotations.UpdateTimestamp; import org.hibernate.envers.Audited; @Data @Entity @Builder @NoArgsConstructor @AllArgsConstructor @Audited public class PaymentAccount { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "payment_account_seq") @GenericGenerator( name = "payment_account_seq", strategy = "org.hibernate.id.enhanced.SequenceStyleGenerator", parameters = {@Parameter(name = "sequence_name", value = "payment_account_seq")}) @JsonIgnore private Long id; private String ciamId; private String providerName; private String providerUserId; @CreationTimestamp @Column(updatable = false) private OffsetDateTime createdAt; @UpdateTimestamp private OffsetDateTime updatedAt; } {noformat} I couldn’t be sure what is causing this issue. I would appreciate if you can help me solve it. You can find the configuration I use below. * hibernate-envers: 6.1.7.Final * hibernate-core: 6.1.7.Final * hibernate-commons-annotations:6.0.6.Final * spring-boot-starter-data-jpa:3.0.6 * postgresql jdbc driver:42.5.4 * postgres 14 {noformat} datasource: url: jdbc:postgresql://localhost:8086/mydb username: admin password: admin driver-class-name: org.postgresql.Driver hikari: maximum-pool-size: 12 idle-timeout: 60000 pool-name: BackendHikariPool connection-timeout: 45000 minimum-idle: 1 connection-test-query: SELECT 1 type: com.zaxxer.hikari.HikariDataSource jpa: show-sql: false open-in-view: false hibernate: ddl-auto: none properties: org.hibernate.envers.do_not_audit_optimistic_locking_field: false hibernate: namingStrategy: org.hibernate.cfg.ImprovedNamingStrategy dialect: org.hibernate.dialect.PostgreSQLDialect hbm2ddl: auto: none temp: use_jdbc_metadata_defaults: false sql: init: continue-on-error: true platform: org.hibernate.dialect.PostgreSQLDialect{noformat} ( https://hibernate.atlassian.net/browse/HHH-16554#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16554#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16555) Join fetch query in combination with the inheritance pattern not working in hibernate 6

by Finn (JIRA)

Finn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzgzNDZiZWE5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16555?atlOrigin=eyJpIjoiMzgzND... ) HHH-16555 ( https://hibernate.atlassian.net/browse/HHH-16555?atlOrigin=eyJpIjoiMzgzND... ) Join fetch query in combination with the inheritance pattern not working in hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-16555?atlOrigin=eyJpIjoiMzgzND... ) Issue Type: Bug Affects Versions: 6.2.2 Assignee: Unassigned Attachments: HibernateTicket.png Components: query-hql Created: 05/May/2023 01:20 AM Priority: Major Reporter: Finn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) I’m using the following entity structure with the inheritance pattern. ( https://hibernate.atlassian.net/secure/attachment/50339/50339_HibernateTi... ) I want so select all *animals* and load all *kittens* as well if the animal is a cat. I’m using the following query to load alls animals. select animal from Animal animal left join fetch animal.kittens In Hibernate 5 all *kittens* are loaded as expected. After the upgrade to hibernate 6 I get a *LazyInitializationException* on accessing the *kittens* Testcase https://github.com/finn0s/hibernate-test-case-templates ( https://hibernate.atlassian.net/browse/HHH-16555#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16555#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HBX-1413) Fix the identity detection in SQLServerMetaDataDialect

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-2127) Resolve test errors/failures for MySQL

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-2064) Investigate class 'org.hibernate.tool.ide.completion.HQLAnalyzer' to fix the failing test 'org.hibernate.tool.ide.completion.HqlAnalyzer.TestCase. testShouldShowTables()'

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-1412) Implement identity detection in the OracleMetaDataDialect

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-1399) Investigate how to make org.hibernate.tool.hbm2x.DefaultSchemaCatalog.TestCase run on MySQL

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-1404) Guard against connection leaks

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-1404) Guard against connection leaks

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-1349) Implement HBM to JPA annotation generation

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-1225) Proxy class should be used for referring property declaration

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-1179) <one-to-one> should not generate Sets

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16554) UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements

by Ahmet Tanakol (JIRA)

Ahmet Tanakol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZmFlZTQ3M2U0... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiZmFlZT... ) HHH-16554 ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiZmFlZT... ) UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiZmFlZT... ) Change By: Ahmet Tanakol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hello Hibernate Team, I was updating our SpringBoot version from 2.x to 3.x, and I am having trouble with starting our app. I create created the tables by using liquibase in the past. When I start my application I see the below exception. {code:java} Suppressed: java.lang.UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements as well at org.hibernate.query.sqm.mutation.internal.cte.CteInsertStrategy.<init>(CteInsertStrategy.java:123) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final] at org.hibernate.query.sqm.mutation.internal.cte.CteInsertStrategy.<init>(CteInsertStrategy.java:107) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final] at org.hibernate.dialect.PostgreSQLDialect.getFallbackSqmInsertStrategy(PostgreSQLDialect.java:828) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]{code} I couldn’t be sure what is causing this issue. I would appreciate if you can help me solve it. You can find the configuration I use below. * hibernate-envers: 6.1.7.Final * hibernate-core: 6.1.7.Final * hibernate-commons-annotations:6.0.6.Final * spring-boot-starter-data-jpa:3.0.6 * postgresql jdbc driver:42.5.4 * postgres 14 {noformat} datasource: url: jdbc:postgresql://localhost:8086/mydb username: admin password: admin driver-class-name: org.postgresql.Driver hikari: maximum-pool-size: 12 idle-timeout: 60000 pool-name: BackendHikariPool connection-timeout: 45000 minimum-idle: 1 connection-test-query: SELECT 1 type: com.zaxxer.hikari.HikariDataSource jpa: show-sql: false open-in-view: false hibernate: ddl-auto: none properties: org.hibernate.envers.do_not_audit_optimistic_locking_field: false hibernate: namingStrategy: org.hibernate.cfg.ImprovedNamingStrategy dialect: org.hibernate.dialect.PostgreSQLDialect hbm2ddl: auto: none temp: use_jdbc_metadata_defaults: false sql: init: continue-on-error: true platform: org.hibernate.dialect.PostgreSQLDialect{noformat} ( https://hibernate.atlassian.net/browse/HHH-16554#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16554#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HBX-2514) Update version identifier to 6.2.3.SNAPSHOT

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-2515) Update hibernate tools dependency of org.jboss.tools.hibernate.runtime.v_6_2 to version 6.2.2.Final

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16554) UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements

by Ahmet Tanakol (JIRA)

Ahmet Tanakol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGZjYmZlM2Iy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiMGZjYm... ) HHH-16554 ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiMGZjYm... ) UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiMGZjYm... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Components: hibernate-core Created: 05/May/2023 00:52 AM Priority: Major Reporter: Ahmet Tanakol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hello Hibernate Team, I was updating our SpringBoot version from 2.x to 3.x, and I am having trouble with starting our app. I create the tables by using liquibase in the past. When I start my application I see the below exception. Suppressed: java.lang.UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements as well at org.hibernate.query.sqm.mutation.internal.cte.CteInsertStrategy.<init>(CteInsertStrategy.java:123) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final] at org.hibernate.query.sqm.mutation.internal.cte.CteInsertStrategy.<init>(CteInsertStrategy.java:107) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final] at org.hibernate.dialect.PostgreSQLDialect.getFallbackSqmInsertStrategy(PostgreSQLDialect.java:828) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final] I couldn’t be sure what is causing this issue. I would appreciate if you can help me solve it. You can find the configuration I use below. * hibernate-envers: 6.1.7.Final * hibernate-core: 6.1.7.Final * hibernate-commons-annotations:6.0.6.Final * spring-boot-starter-data-jpa:3.0.6 * postgresql jdbc driver:42.5.4 * postgres 14 datasource: url: jdbc:postgresql://localhost:8086/mydb username: admin password: admin driver-class-name: org.postgresql.Driver hikari: maximum-pool-size: 12 idle-timeout: 60000 pool-name: BackendHikariPool connection-timeout: 45000 minimum-idle: 1 connection-test-query: SELECT 1 type: com.zaxxer.hikari.HikariDataSource jpa: show-sql: false open-in-view: false hibernate: ddl-auto: none properties: org.hibernate.envers.do_not_audit_optimistic_locking_field: false hibernate: namingStrategy: org.hibernate.cfg.ImprovedNamingStrategy dialect: org.hibernate.dialect.PostgreSQLDialect hbm2ddl: auto: none temp: use_jdbc_metadata_defaults: false sql: init: continue-on-error: true platform: org.hibernate.dialect.PostgreSQLDialect ( https://hibernate.atlassian.net/browse/HHH-16554#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16554#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HBX-2513) Update version identifier to 6.2.2.Final

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HBX-2512) Update Hibernate ORM Dependency to Version 6.2.2.Final

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16553) StackOverflowError when loading entities chained together

by Guillaume Toison (JIRA)

Guillaume Toison ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *commented* on HHH-16553 ( https://hibernate.atlassian.net/browse/HHH-16553?atlOrigin=eyJpIjoiMGNlY2... ) Re: StackOverflowError when loading entities chained together ( https://hibernate.atlassian.net/browse/HHH-16553?atlOrigin=eyJpIjoiMGNlY2... ) Pull request with a test reproducing the issue: https://github.com/hibernate/hibernate-orm/pull/6507 I initially thought that the problem was with @Proxy(lazy = false) but the error also seems to happen without it in the reproducer. ( https://hibernate.atlassian.net/browse/HHH-16553#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16553#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16553) StackOverflowError when loading entities chained together

by Guillaume Toison (JIRA)

Guillaume Toison ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNDM4MzAzZDBl... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16553?atlOrigin=eyJpIjoiNDM4Mz... ) HHH-16553 ( https://hibernate.atlassian.net/browse/HHH-16553?atlOrigin=eyJpIjoiNDM4Mz... ) StackOverflowError when loading entities chained together ( https://hibernate.atlassian.net/browse/HHH-16553?atlOrigin=eyJpIjoiNDM4Mz... ) Issue Type: Bug Affects Versions: 6.2.1, 6.2.2 Assignee: Unassigned Components: hibernate-core Created: 04/May/2023 13:00 PM Priority: Blocker Reporter: Guillaume Toison ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) Hello, As originally discussed here https://discourse.hibernate.org/t/stackoverflowerror-in-6-2-with-proxy-la... I’m getting a StackOverflowError on Hibernate 6.2.1 when loading an entities linked to other entities annotated with @Proxy(lazy = false) The stacktrace looks like this: at org.hibernate.sql.results.graph.entity.internal.BatchInitializeEntitySelectFetchInitializer.resolveInstance(BatchInitializeEntitySelectFetchInitializer.java:74) at org.hibernate.sql.results.internal.InitializersList.resolveInstances(InitializersList.java:88) at org.hibernate.sql.results.internal.StandardRowReader.coordinateInitializers(StandardRowReader.java:110) at org.hibernate.sql.results.internal.StandardRowReader.readRow(StandardRowReader.java:87) at org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:179) at org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:33) at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:362) at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:168) at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.list(JdbcSelectExecutorStandardImpl.java:93) at org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:31) at org.hibernate.loader.ast.internal.SingleIdEntityLoaderDynamicBatch.load(SingleIdEntityLoaderDynamicBatch.java:140) at org.hibernate.loader.ast.internal.SingleIdEntityLoaderDynamicBatch.load(SingleIdEntityLoaderDynamicBatch.java:58) at org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:3367) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3357) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:602) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromCacheOrDatasource(DefaultLoadEventListener.java:588) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:557) at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:550) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:202) at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:241) at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:106) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:78) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:138) at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1231) at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1075) ( https://hibernate.atlassian.net/browse/HHH-16553#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16553#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16552) Add new CockroachDB version (v23.1) to CI

by Karel Maesen (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16551) Schema management: discriminator column of type CHAR should always be of length 1

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16551 ( https://hibernate.atlassian.net/browse/HHH-16551?atlOrigin=eyJpIjoiZWQyYz... ) Re: Schema management: discriminator column of type CHAR should always be of length 1 ( https://hibernate.atlassian.net/browse/HHH-16551?atlOrigin=eyJpIjoiZWQyYz... ) Created pull request 6505 ( https://github.com/hibernate/hibernate-orm/pull/6505 ) ( https://hibernate.atlassian.net/browse/HHH-16551#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16551#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16551) Schema management: discriminator column of type CHAR should always be of length 1

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMWZjNzk1NTg4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16551?atlOrigin=eyJpIjoiMWZjNz... ) HHH-16551 ( https://hibernate.atlassian.net/browse/HHH-16551?atlOrigin=eyJpIjoiMWZjNz... ) Schema management: discriminator column of type CHAR should always be of length 1 ( https://hibernate.atlassian.net/browse/HHH-16551?atlOrigin=eyJpIjoiMWZjNz... ) Issue Type: Bug Affects Versions: 6.2.2 Assignee: Unassigned Components: hibernate-core Created: 04/May/2023 09:59 AM Priority: Minor Reporter: Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) When schema is created or updated discriminator column of type CHAR is always set to default length(31) instead of 1. ( https://hibernate.atlassian.net/browse/HHH-16551#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16551#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16489) Hibernate native query returns duplicate column values with addScalar() call

by Puhong You (JIRA)

Puhong You ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16489 ( https://hibernate.atlassian.net/browse/HHH-16489?atlOrigin=eyJpIjoiNWYzND... ) Re: Hibernate native query returns duplicate column values with addScalar() call ( https://hibernate.atlassian.net/browse/HHH-16489?atlOrigin=eyJpIjoiNWYzND... ) Hi, Prithvi, thanks for looking into this. In Hibernate 5.6.15.Final, please modify your test code like this {{NativeQuery<Integer> query=session.createNativeQuery(sql); }} query.addScalar( "user_id", StandardBasicTypes.INTEGER ); List<Integer> rsList = query.list(); Your test should work with or without the addScalar() call in Hibernate 5.6.15.Final, i.e., {{NativeQuery<Integer> query=session.createNativeQuery(sql); }} List<Integer> rsList = query.list(); ( https://hibernate.atlassian.net/browse/HHH-16489#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16489#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16550) Allow accessing the entity identifier from the UserType#nullSafeSet method

by Prithvi singh (JIRA)

Prithvi singh ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16550 ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiZWZkND... ) Re: Allow accessing the entity identifier from the UserType#nullSafeSet method ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiZWZkND... ) @François Rosière. Thanks for this detailed explanation. ( https://hibernate.atlassian.net/browse/HHH-16550#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16550#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16550) Allow accessing the entity identifier from the UserType#nullSafeSet method

by Prithvi singh (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16505) Interpretation of "bare" left-join alias reference in HQL

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16425) Function type resolver doesn't work with anonymous tuple path sources

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16425 ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiNzE2OT... ) Re: Function type resolver doesn't work with anonymous tuple path sources ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiNzE2OT... ) Sure, I was waiting to hear some feedback on mine before closing it for you. ( https://hibernate.atlassian.net/browse/HHH-16425#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16425#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16425) Function type resolver doesn't work with anonymous tuple path sources

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16425 ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiMjUyMm... ) Re: Function type resolver doesn't work with anonymous tuple path sources ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiMjUyMm... ) Nice if my changes helped you to make proper fix. I guess that now I can close my PR? ( https://hibernate.atlassian.net/browse/HHH-16425#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16425#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16550) Allow accessing the entity identifier from the UserType#nullSafeSet method

by François Rosière (JIRA)

François Rosière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYzRhYmU2Yzky... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiYzRhYm... ) HHH-16550 ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiYzRhYm... ) Allow accessing the entity identifier from the UserType#nullSafeSet method ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiYzRhYm... ) Change By: François Rosière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hibernate currently provides a way to define custom types. Either internal or user types. In some situations, this custom type may have to access the entity identifier. Concrete use case: compute a custom value using the entity identifier (may be null depending on the id strategy which is used). This is currently possible from the nullSafeGet method through the owner but this is not possible to access that identifier from the nullSafeSet Method. So, the proposal would be to review the Hibernate internals to allow exposing this identifier as follow on the UserType interface and call this new method instead of the current one {code:java}public interface UserType { // hibernate would call this method internally // id parameter is the owner/entity identifier default void nullSafeSet(PreparedStatement st, Serializable id, Object value, int index, SharedSessionContractImplementor session) throws HibernateException, SQLException { nullSafeSet(st, value, index, session); } // may have a default implementation to allow choosing to override one or the other void nullSafeSet(PreparedStatement st, Object value, int index, SharedSessionContractImplementor session) throws HibernateException, SQLException; }{code} Usage may be as follow {noformat}public class MyType implements UserType { @Override void nullSafeSet(PreparedStatement st, Serializable id, Object value, int index, SharedSessionContractImplementor session) throws HibernateException, SQLException { // compute my new type using the owner/entity id } @Override void nullSafeSet(PreparedStatement st, Object value, int index, SharedSessionContractImplementor session) throws HibernateException, SQLException { // does nothing ... default implementation in the interface? } }{noformat} The Type interface would also need to be updated the same way to allow transmitting the id from the caller stack. See CustomType. Proposed change is retro-compatible. ( https://hibernate.atlassian.net/browse/HHH-16550#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16550#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16550) Allow accessing the entity identifier from the UserType#nullSafeSet method

by François Rosière (JIRA)

François Rosière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTFkOGUxYTU0... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiZTFkOG... ) HHH-16550 ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiZTFkOG... ) Allow accessing the entity identifier from the UserType#nullSafeSet method ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiZTFkOG... ) Change By: François Rosière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hibernate currently provides a way to define custom types. Either internal or user types. In some situations, this custom type may have to access the entity identifier. Concrete use case: compute a custom value using the entity identifier (may be null depending on the id strategy which is used). This is currently possible from the nullSafeGet method through the owner but this is not possible to access that identifier from the nullSafeSet Method. So, the proposal would be to review the Hibernate internals to allow exposing this identifier as follow on the UserType interface and call this new method instead of the current one {code:java}public interface UserType { // hibernate would call this method internally // id parameter is the owner/entity identifier default void nullSafeSet(PreparedStatement st, Serializable id, Object value, int index, SharedSessionContractImplementor session) throws HibernateException, SQLException { nullSafeSet(st, value, index, session); } void nullSafeSet(PreparedStatement st, Object value, int index, SharedSessionContractImplementor session) throws HibernateException, SQLException; }{code} The Type interface would also need to be updated the same way to allow transmitting the id from the caller stack. See CustomType. Proposed change is retro-compatible. ( https://hibernate.atlassian.net/browse/HHH-16550#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16550#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16550) Allow accessing the entity identifier from the UserType#nullSafeSet method

by François Rosière (JIRA)

François Rosière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16550 ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiZTdkYW... ) Re: Allow accessing the entity identifier from the UserType#nullSafeSet method ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiZTdkYW... ) My custom type need to have access to the entity identifier to allow computing the value to either persist or load from the database. The nullSafeGet methods already provides a way to access the entity identifier as the owner is a parameter of the nullSafeGet method. So, through the session, it’s possible to retrieve the identifier using the following portion of code session.getContextEntityIdentifier(owner); The nullSafeSet method does not allow retrieving the identifier of the owner. So, this ticket has been created to solve that. Hope it’s clearer. ( https://hibernate.atlassian.net/browse/HHH-16550#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16550#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16370) Using MapKey on ManyToMany leads to wrong insert SQL

by Andrea Boriero (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16550) Allow accessing the entity identifier from the UserType#nullSafeSet method

by Prithvi singh (JIRA)

Prithvi singh ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16550 ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiZGJhMW... ) Re: Allow accessing the entity identifier from the UserType#nullSafeSet method ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiZGJhMW... ) @François Rosière could you please elaborate > > > > This is currently possible from the nullSafeGet method through the owner > but this is not possible to access that identifier from the nullSafeSet > Method. > > > > So, the proposal would be to review the Hibernate internals to allow > exposing this identifier as follow on the UserType interface and call this > new method instead of the current one > > ( https://hibernate.atlassian.net/browse/HHH-16550#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16550#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-14944) Bug: Detach entity removes NaturalIdCrossReference in shared cache too

by Guenther Demetz (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-14944) Detaching entity removes NaturalIdCrossReference in shared cache too

by Guenther Demetz (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-14944) Detaching entity removes NaturalIdCrossReference in 2nd-level cache too

by Guenther Demetz (JIRA)

Guenther Demetz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14944 ( https://hibernate.atlassian.net/browse/HHH-14944?atlOrigin=eyJpIjoiZjNhYT... ) Re: Detaching entity removes NaturalIdCrossReference in 2nd-level cache too ( https://hibernate.atlassian.net/browse/HHH-14944?atlOrigin=eyJpIjoiZjNhYT... ) Now the pull-request contains also a bug-fix proposal so that the added testcase does not fail anymore. ( https://hibernate.atlassian.net/browse/HHH-14944#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14944#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16472) Treated left join with restriction on entity results in incorrect query

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16489) Hibernate native query returns duplicate column values with addScalar() call

by Prithvi singh (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16489) Hibernate native query returns duplicate column values with addScalar() call

by Prithvi singh (JIRA)

Prithvi singh ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16489 ( https://hibernate.atlassian.net/browse/HHH-16489?atlOrigin=eyJpIjoiNjY4M2... ) Re: Hibernate native query returns duplicate column values with addScalar() call ( https://hibernate.atlassian.net/browse/HHH-16489?atlOrigin=eyJpIjoiNjY4M2... ) Hi @Puhong You, I tried to look into this issue and executed the above mentioned test case in version 5.6.15. Unfortunately, the test is not completing and I am getting org.hibernate.MappingException as java.lang.Integer class could not be recognised as an entity. Here are the attached snippets. I am using maven as my build tool and h2 as my database. My pom.xml <project xmlns= "http://maven.apache.org/POM/4.0.0" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation= "http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" > <modelVersion> 4.0.0 </modelVersion> <groupId> org.example </groupId> <artifactId> hibernate-tests </artifactId> <version> 1.0-SNAPSHOT </version> <packaging> jar </packaging> <name> hibernate-tests </name> <url> http://maven.apache.org </url> <properties> <project.build.sourceEncoding> UTF-8 </project.build.sourceEncoding> <maven.compiler.source> 17 </maven.compiler.source> <maven.compiler.target> 17 </maven.compiler.target> </properties> <dependencies>   <dependency> <groupId> com.h2database </groupId> <artifactId> h2 </artifactId> <version> 2.1.214 </version> <scope> test </scope> </dependency>   <dependency> <groupId> org.hibernate </groupId> <artifactId> hibernate-core </artifactId> <version> 5.6.15.Final </version> </dependency> <dependency> <groupId> junit </groupId> <artifactId> junit </artifactId> <version> 4.13.2 </version> <scope> test </scope> </dependency> </dependencies> </project> package org.example; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import org.hibernate.annotations.GenericGenerator; @Entity public class DummyUser { @Id @Column(name = "USER_ID" ) @GenericGenerator( name = "dummyuser_increment" ,strategy = "increment" ) @GeneratedValue(generator = "dummyuser_increment" ) private int userId; @Column(name = "USER_NAME" ,nullable = false ) private String userName; public DummyUser() { } public int getUserId() { return userId; } public void setUserId( int userId) { this.userId = userId; } public String getUserName() { return userName; } public void setUserName( String userName) { this.userName = userName; } @Override public String toString() { return "DummyUser{" + "userId=" + userId + ", userName= '" + userName + ' \'' + '}' ; } } Here is my test file package org.example; import java.util.List; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import org.hibernate.query.NativeQuery; import org.hibernate.type.StandardBasicTypes; import org.junit.Test; import static org.junit.Assert.assertEquals; import static org.junit.Assert.assertNotNull; public class DummyUserTest { private final SessionFactory sessionFactory; public DummyUserTest() { sessionFactory = new Configuration().configure().buildSessionFactory(); // also adding data to database Session session=sessionFactory.openSession(); DummyUser dummyUser= new DummyUser(); dummyUser.setUserName( "Joe Doe" ); Transaction transaction= session.beginTransaction(); session.persist( dummyUser ); transaction.commit(); session.close(); } @Test public void checkUniquenessOfAddScalar() { String sql= "SELECT user_id FROM dummyuser WHERE user_name= 'Joe Doe' " ; // obtaining session Session session=sessionFactory.openSession(); NativeQuery< Integer > query=session.createNativeQuery( sql, Integer.class ); query.addScalar( "user_id" , StandardBasicTypes.INTEGER ); List< Integer > rsList = query.list(); assertNotNull( rsList ); assertEquals( 1, rsList.size() ); assertEquals( Integer.valueOf( 1 ), rsList.get(0) ); } } And finally this is my surefire test report which shows the exception ------------------------------------------------------------------------------- Test set: org.example.DummyUserTest ------------------------------------------------------------------------------- Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 1.803 sec <<< FAILURE! checkUniquenessOfAddScalar(org.example.DummyUserTest) Time elapsed: 1.75 sec <<< ERROR! javax.persistence.PersistenceException: org.hibernate.MappingException: Unknown entity: java.lang.Integer at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1626) at org.example.DummyUserTest.checkUniquenessOfAddScalar(DummyUserTest.java:41) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63) at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.ParentRunner.run(ParentRunner.java:413) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:252) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:141) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:112) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189) at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165) at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:115) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:75) Caused by: org.hibernate.MappingException: Unknown entity: java.lang.Integer at org.hibernate.metamodel.internal.MetamodelImpl.entityPersister(MetamodelImpl.java:715) at org.hibernate.engine.spi.SessionFactoryImplementor.getEntityPersister(SessionFactoryImplementor.java:360) at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.getSQLLoadable(SQLQueryReturnProcessor.java:445) at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.processRootReturn(SQLQueryReturnProcessor.java:498) at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.processReturn(SQLQueryReturnProcessor.java:465) at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.process(SQLQueryReturnProcessor.java:180) at org.hibernate.loader.custom.sql.SQLCustomQuery.<init>(SQLCustomQuery.java:74) at org.hibernate.engine.query.internal.NativeQueryInterpreterStandardImpl.createQueryPlan(NativeQueryInterpreterStandardImpl.java:44) at org.hibernate.engine.query.spi.QueryPlanCache.getNativeSQLQueryPlan(QueryPlanCache.java:244) at org.hibernate.internal.AbstractSharedSessionContract.getNativeQueryPlan(AbstractSharedSessionContract.java:640) at org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1204) at org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:177) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617) ... 33 more @Puhog You could you please provide me snippets for a working test case in version 5.6.15 so that I may be able to better look into this issue. ( https://hibernate.atlassian.net/browse/HHH-16489#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16489#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16550) Allow accessing the entity identifier from the UserType#nullSafeSet method

by François Rosière (JIRA)

François Rosière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjcxYWMzNDhl... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiYjcxYW... ) HHH-16550 ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiYjcxYW... ) Allow accessing the entity identifier from the UserType#nullSafeSet method ( https://hibernate.atlassian.net/browse/HHH-16550?atlOrigin=eyJpIjoiYjcxYW... ) Issue Type: Improvement Affects Versions: 5.6.15, 6.2.2 Assignee: Unassigned Components: hibernate-core Created: 04/May/2023 04:44 AM Priority: Major Reporter: François Rosière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hibernate currently provides a way to define custom types. Either internal or user types. In some situations, this custom type may have to access the entity identifier. Concrete use case: compute a custom value using the entity identifier (may be null depending on the id strategy which is used). This is currently possible from the nullSafeGet method through the owner but this is not possible to access that identifier from the nullSafeSet Method. So, the proposal would be to review the Hibernate internals to allow exposing this identifier as follow on the UserType interface and call this new method instead of the current one public interface UserType { // hibernate would call this method internally default void nullSafeSet(PreparedStatement st, Serializable id, Object value, int index, SharedSessionContractImplementor session) throws HibernateException, SQLException { nullSafeSet(st, value, index, session); } void nullSafeSet(PreparedStatement st, Object value, int index, SharedSessionContractImplementor session) throws HibernateException, SQLException; } The Type interface would also need to be updated the same way to allow transmitting the id from the caller stack. See CustomType. Proposed change is retro-compatible. ( https://hibernate.atlassian.net/browse/HHH-16550#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16550#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HV-1946) PathImpl.createCopy() only performs a shallow copy

by Marko Bekhta (JIRA)

3 years

1
0
0 / 0

[JIRA] (HV-1946) PathImpl.createCopy() only performs a shallow copy

by Marko Bekhta (JIRA)

Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HV-1946 ( https://hibernate.atlassian.net/browse/HV-1946?atlOrigin=eyJpIjoiNGVhN2Fi... ) Re: PathImpl.createCopy() only performs a shallow copy ( https://hibernate.atlassian.net/browse/HV-1946?atlOrigin=eyJpIjoiNGVhN2Fi... ) Hey Jay Gorrell ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=622a122... ) thanks for reporting the issue and providing the reproducibles. The Path implementation deliberately is not creating deep copies for performance and resource usage reasons. While that’s so, there’s a problem you’ve reported. It comes from the fact that you are passing a null value as a nodeName into receiver.indexedValue(..). This results in a created path missing a container element node; you can see that by inspecting the nodes in the path or by calling a Node#getIndex() either on the node or nodeImpl in your test case. If you'd like to make it work on with the version of the validator you are using right now – you’d have to pass a nonnull node name. Keep in mind that that will change the string representation of the path (that’s if you care about how it looks). In the meantime, I’ll submit a patch that should address the problem. ( https://hibernate.atlassian.net/browse/HV-1946#add-comment?atlOrigin=eyJp... ) Add Comment ( https://hibernate.atlassian.net/browse/HV-1946#add-comment?atlOrigin=eyJp... ) 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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16537) Wrong SQL generated when root join is not used in sub-query

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16537 ( https://hibernate.atlassian.net/browse/HHH-16537?atlOrigin=eyJpIjoiMWVhYT... ) Re: Wrong SQL generated when root join is not used in sub-query ( https://hibernate.atlassian.net/browse/HHH-16537?atlOrigin=eyJpIjoiMWVhYT... ) In hibernate 5 the SQL is fine: Hibernate: select entitya0_.ID as id1_0_, entitya0_.ENTITY_B as entity_b2_0_ from ENTITY_A entitya0_ inner join ENTITY_B entityb1_ on entitya0_.ENTITY_B=entityb1_.ID where 0<( select count (*) from REFERENCED_ENTITY referenced2_ where referenced2_.foo=1 and referenced2_.ID=entityb1_.REF_NUMBER ) ( https://hibernate.atlassian.net/browse/HHH-16537#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16537#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16512) Bidirectional OneToOne association produces wrong isNull predicate in criteria query

by Tassilo Karge (JIRA)

Tassilo Karge ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f50ce4... ) *commented* on HHH-16512 ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiOTk2Nz... ) Re: Bidirectional OneToOne association produces wrong isNull predicate in criteria query ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiOTk2Nz... ) I reverted my proposed change, but the tests are with no doubt correct ( https://hibernate.atlassian.net/browse/HHH-16512#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16512#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HV-1946) PathImpl.createCopy() only performs a shallow copy

by Marko Bekhta (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16512) Bidirectional OneToOne association produces wrong isNull predicate in criteria query

by Tassilo Karge (JIRA)

Tassilo Karge ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f50ce4... ) *commented* on HHH-16512 ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiMjFhNj... ) Re: Bidirectional OneToOne association produces wrong isNull predicate in criteria query ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiMjFhNj... ) The query should pick the correct implicit join for the nullability semantics of the relation, which is a left join. In contrast, Hibernate 5.8 does not even query the relation as it omits the join, and check whether the primary key of the table is null, and Hibernate 6.2 performs an inner join which can never result in the null predicate becoming true. ( https://hibernate.atlassian.net/browse/HHH-16512#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16512#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16512) Bidirectional OneToOne association produces wrong isNull predicate in criteria query

by Tassilo Karge (JIRA)

Tassilo Karge ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f50ce4... ) *commented* on HHH-16512 ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiYzlmYz... ) Re: Bidirectional OneToOne association produces wrong isNull predicate in criteria query ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiYzlmYz... ) You are right, the tested change is incorrect, though the test I built shows that the query built by hibernate without the change is also incorrect for both the current version (6.2) as well as the last 5.x version of Hibernate. ( https://hibernate.atlassian.net/browse/HHH-16512#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16512#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16505) interpretation of "bare" alias reference in HQL

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16512) Bidirectional OneToOne association produces wrong isNull predicate in criteria query

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16512 ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiOTA0MG... ) Re: Bidirectional OneToOne association produces wrong isNull predicate in criteria query ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiOTA0MG... ) Hi, the change you proposed is incorrect (as you can see from all the failing tests) as it would change implicit join semantics. If you want a LEFT JOIN you should explicitly define it, like you do in your second query. The first query works in your specific case without explicitly joining just because, being on the owning side of the association, we can use the foreign key. ( https://hibernate.atlassian.net/browse/HHH-16512#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16512#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16512) Bidirectional OneToOne association produces wrong isNull predicate in criteria query

by Tassilo Karge (JIRA)

Tassilo Karge ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f50ce4... ) *commented* on HHH-16512 ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiNjM0NT... ) Re: Bidirectional OneToOne association produces wrong isNull predicate in criteria query ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiNjM0NT... ) Hello Marco, there are two PRs (linked here on the right side) with tests that both fail currently. I tried to search for a solution, but have not been able to find one so far. ( https://hibernate.atlassian.net/browse/HHH-16512#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16512#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16364) com.sybase.jdbc4.jdbc.SybDriver ddl-auto update not working

by razvan dana (JIRA)

razvan dana ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16364 ( https://hibernate.atlassian.net/browse/HHH-16364?atlOrigin=eyJpIjoiYmJmNm... ) Re: com.sybase.jdbc4.jdbc.SybDriver ddl-auto update not working ( https://hibernate.atlassian.net/browse/HHH-16364?atlOrigin=eyJpIjoiYmJmNm... ) Link to sample project that can be used to replicate. Simply define datasource url and user/pass: https://github.com/razvdana/jconnect-example Consecutive runs of the application will throw the entity already exists errors. PS: I was able o replicate issue with sourceforge driver as well, included configuration for it as well. ( https://hibernate.atlassian.net/browse/HHH-16364#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16364#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16537) Wrong SQL generated when root join is not used in sub-query

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16537 ( https://hibernate.atlassian.net/browse/HHH-16537?atlOrigin=eyJpIjoiYjdkOG... ) Re: Wrong SQL generated when root join is not used in sub-query ( https://hibernate.atlassian.net/browse/HHH-16537?atlOrigin=eyJpIjoiYjdkOG... ) Did Hibernate 5 reuse the root query’s a.entityB join in the subquery too? If that’s what you’re trying to achieve, I think using the join’s alias in the subquery is the only correct syntax. I also believe that 6 behaves correctly, it creates a new (cross) join for the subquery since you’re specifying the full a.entityB.reference path: with a being in the root query, we can’t reuse its joins for correlated subqueries. ( https://hibernate.atlassian.net/browse/HHH-16537#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16537#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16512) Bidirectional OneToOne association produces wrong isNull predicate in criteria query

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16512 ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiMDVhNT... ) Re: Bidirectional OneToOne association produces wrong isNull predicate in criteria query ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiMDVhNT... ) Hello Tassilo Karge ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f50ce4... ) , could you please provide a reproducer for your issue so we can better understand the problem? You can start from our test case templates ( https://github.com/hibernate/hibernate-test-case-templates ). ( https://hibernate.atlassian.net/browse/HHH-16512#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16512#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#100225- sha1:f83bc8f )

3 years

1
0
0 / 0

[JIRA] (HHH-16549) NullPointerException when calling LoadQueryInfluencers#isFetchProfileEnabled

by Davide D'Alto (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16549) NullPointerException when calling LoadQueryInfluencers#isFetchProfileEnabled

by Davide D'Alto (JIRA)

Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZmYwMDQxNjU4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16549?atlOrigin=eyJpIjoiZmYwMD... ) HHH-16549 ( https://hibernate.atlassian.net/browse/HHH-16549?atlOrigin=eyJpIjoiZmYwMD... ) NullPointerException when calling LoadQueryInfluencers#isFetchProfileEnabled ( https://hibernate.atlassian.net/browse/HHH-16549?atlOrigin=eyJpIjoiZmYwMD... ) Issue Type: Bug Assignee: Unassigned Created: 03/May/2023 13:14 PM Priority: Major Reporter: Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) This happens because the session factory can be null. For example, when using LoadQueryInfluencers.NONE ( https://hibernate.atlassian.net/browse/HHH-16549#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16549#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16541) (Jakarta EE 10 Platform TCK) jpa/core/lock/query/Client.java#getResultListTest1 test regression

by Steve Ebersole (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16542) (Jakarta EE 10 Platform TCK) jpa/core/entitytest/cascadeall/oneXone/cascadeAll1X1Test10 test regression

by Steve Ebersole (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16425) Function type resolver doesn't work with anonymous tuple path sources

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16425 ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiOWJkOD... ) Re: Function type resolver doesn't work with anonymous tuple path sources ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiOWJkOD... ) Hello Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , thanks for the tests and the contribution. Your proposed solution looked fine to me. I’ve opened an alternative PR with simpler tests and a slightly more generalized fix. Note that we will only fix this in Hibernate 6.2 since we’re not releasing new maintenance versions for 6.1. ( https://hibernate.atlassian.net/browse/HHH-16425#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16425#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16425) Function type resolver doesn't work with anonymous tuple path sources

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16425) Function type resolver doesn't work with anonymous tuple path sources

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGUwNWY4YTE4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiNGUwNW... ) HHH-16425 ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiNGUwNW... ) Function type resolver doesn't work with anonymous tuple path sources ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiNGUwNW... ) Change By: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) Summary: Can not perform some aggregates over subquery Function type resolver doesn't work with anonymous tuple path sources ( https://hibernate.atlassian.net/browse/HHH-16425#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16425#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16548) allow directory/archive scanning via Configuration API

by Gavin King (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16548) allow directory/archive scanning via Configuration API

by Gavin King (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16548) allow directory/archive scanning via Configuration API

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTJhM2ViODBl... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16548?atlOrigin=eyJpIjoiZTJhM2... ) HHH-16548 ( https://hibernate.atlassian.net/browse/HHH-16548?atlOrigin=eyJpIjoiZTJhM2... ) allow directory/archive scanning via Configuration API ( https://hibernate.atlassian.net/browse/HHH-16548?atlOrigin=eyJpIjoiZTJhM2... ) Issue Type: Improvement Assignee: Unassigned Components: hibernate-core Created: 03/May/2023 08:12 AM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) We should let you specify a location to be scanned for entities via the Configuration API. It looks like this is easy to add via the ScannerEnvironment extension point. ( https://hibernate.atlassian.net/browse/HHH-16548#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16548#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16425) Can not perform some aggregates over subquery

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16425) Can not perform some aggregates over subquery

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16483) Recursive CTE using Criteria API will throw `Already registered a copy: org.hibernate.query.sqm.tree.cte.SqmCteStatement` error

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16542) (Jakarta EE 10 Platform TCK) jpa/core/entitytest/cascadeall/oneXone/cascadeAll1X1Test10 test regression

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16542 ( https://hibernate.atlassian.net/browse/HHH-16542?atlOrigin=eyJpIjoiMzQ4Nz... ) Re: (Jakarta EE 10 Platform TCK) jpa/core/entitytest/cascadeall/oneXone/cascadeAll1X1Test10 test regression ( https://hibernate.atlassian.net/browse/HHH-16542?atlOrigin=eyJpIjoiMzQ4Nz... ) I may be wrong but I think it is Hibernate specific and probably the reason is to decide which method to enhance. ( https://hibernate.atlassian.net/browse/HHH-16542#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16542#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16542) (Jakarta EE 10 Platform TCK) jpa/core/entitytest/cascadeall/oneXone/cascadeAll1X1Test10 test regression

by Scott Marlow (JIRA)

Scott Marlow ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16542 ( https://hibernate.atlassian.net/browse/HHH-16542?atlOrigin=eyJpIjoiNDVlM2... ) Re: (Jakarta EE 10 Platform TCK) jpa/core/entitytest/cascadeall/oneXone/cascadeAll1X1Test10 test regression ( https://hibernate.atlassian.net/browse/HHH-16542?atlOrigin=eyJpIjoiNDVlM2... ) private static void checkGetAndIsVariants( Class containerClass, String propertyName, Method getMethod, Method isMethod) { // Check the return types. If they are the same, its ok. If they are different // we are in a situation where we could not reasonably know which to use. if ( !isMethod.getReturnType().equals( getMethod.getReturnType() ) ) { throw new MappingException( String.format( Locale.ROOT, "In trying to locate getter for property [%s], Class [%s] defined " + "both a `get` [%s] and `is` [%s] variant", propertyName, containerClass.getName(), getMethod.toString(), isMethod.toString() ) ); } } Mentioned ReflectHelper code is ^ and error is: org.hibernate.MappingException: In trying to locate getter for property [b1] , Class [com.sun.ts.tests.jpa.core.entitytest.cascadeall.oneXone.A] defined both a get [public com.sun.ts.tests.jpa.core.entitytest.cascadeall.oneXone.B com.sun.ts.tests.jpa.core.entitytest.cascadeall.oneXone.A.getB1()] and is [public boolean com.sun.ts.tests.jpa.core.entitytest.cascadeall.oneXone.A.isB1()] variant The offending TCK source code is: @OneToOne(targetEntity = com.sun.ts.tests.jpa.core.entitytest.cascadeall.oneXone.B.class, mappedBy = "a1", orphanRemoval = true) protected B b1; public B getB1() { return b1; } public boolean isB1() { TestUtil.logTrace("isB1"); if (getB1() != null) TestUtil.logTrace("Relationship to B is not null..."); else TestUtil.logTrace("Relationship for B is null ..."); return getB1() != null; } Apologies for pasting all of the above but it helps me to see it all together as one comment. 🙂 From the above pasted code + error, I think the test would pass if both methods returned either B or boolean but is that only a Hibernate requirement or is that also Persistence Specification requirement? Could ReflectHelper be enhanced to handle ^ differently in JPA_COMPLIANCE mode? ( https://hibernate.atlassian.net/browse/HHH-16542#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16542#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HBX-2453) Implement and use the generic adapter for ISchemaExport in the experimental Hibernate runtime

by Koen Aers (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16546) Reduce verbosity of logs in a few edge cases

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16546 ( https://hibernate.atlassian.net/browse/HHH-16546?atlOrigin=eyJpIjoiY2MxNW... ) Re: Reduce verbosity of logs in a few edge cases ( https://hibernate.atlassian.net/browse/HHH-16546?atlOrigin=eyJpIjoiY2MxNW... ) Note I went through the whole CoreMessageLogger class and found only those two that were both used and too noisy, but there are a few different problems that we might also want to address (in a different issue): * some logs are no longer used: we could remove the methods or at least deprecate them * some logs are only used in deprecated classes (e.g. in org.hibernate.tool.hbm2ddl.TableMetadata ): we should deprecate them so that we can remove them when we remove that deprecated class. * some logs report failures but are marked as INFO… I’m pretty sure at least some of those should be WARN instead of INFO. ( https://hibernate.atlassian.net/browse/HHH-16546#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16546#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16541) (Jakarta EE 10 Platform TCK) jpa/core/lock/query/Client.java#getResultListTest1 test regression

by Scott Marlow (JIRA)

Scott Marlow ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16541 ( https://hibernate.atlassian.net/browse/HHH-16541?atlOrigin=eyJpIjoiZDc4Nz... ) Re: (Jakarta EE 10 Platform TCK) jpa/core/lock/query/Client.java#getResultListTest1 test regression ( https://hibernate.atlassian.net/browse/HHH-16541?atlOrigin=eyJpIjoiZDc4Nz... ) Agreed that we don’t have it reproduced in the Hibernate ORM test suite. ( https://hibernate.atlassian.net/browse/HHH-16541#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16541#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16542) (Jakarta EE 10 Platform TCK) jpa/core/entitytest/cascadeall/oneXone/cascadeAll1X1Test10 test regression

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16542 ( https://hibernate.atlassian.net/browse/HHH-16542?atlOrigin=eyJpIjoiZTJmZG... ) Re: (Jakarta EE 10 Platform TCK) jpa/core/entitytest/cascadeall/oneXone/cascadeAll1X1Test10 test regression ( https://hibernate.atlassian.net/browse/HHH-16542?atlOrigin=eyJpIjoiZTJmZG... ) this is the test I used import org.hibernate.testing.bytecode.enhancement.BytecodeEnhancerRunner; import org.hibernate.testing.bytecode.enhancement.EnhancementOptions; import org.hibernate.testing.junit4.BaseCoreFunctionalTestCase; import org.junit.Test; import org.junit.runner.RunWith; import jakarta.persistence.Basic; import jakarta.persistence.CascadeType; import jakarta.persistence.Entity; import jakarta.persistence.Id; import jakarta.persistence.JoinColumn; import jakarta.persistence.OneToOne; import jakarta.persistence.Table; @RunWith(BytecodeEnhancerRunner.class) @EnhancementOptions(inlineDirtyChecking = true, lazyLoading = true, extendedEnhancement = true) public class TestIt extends BaseCoreFunctionalTestCase { @Override protected Class<?>[] getAnnotatedClasses() { return new Class[]{ A.class, B.class }; } @Test public void testIt(){ inTransaction( entityManager -> { } ); } @Entity @Table(name = "AEJB_1X1_BI_BTOB") public class A implements java.io.Serializable { // =========================================================== // instance variables @Id protected String id; @Basic protected String name; @Basic protected int value; // =========================================================== // constructors public A() { } public A(String id, String name, int value) { this.id = id; this.name = name; this.value = value; } public A(String id, String name, int value, B b1) { this.id = id; this.name = name; this.value = value; this.b1 = b1; } // =========================================================== // relationship fields @OneToOne(targetEntity = B.class, mappedBy = "a1", orphanRemoval = true) protected B b1; // ======================================================================= // Business methods for test cases public B getB1() { return b1; } public boolean isB1() { return getB1() != null; } public B getB1Info() { if (isB1()) { B b1 = getB1(); return b1; } else return null; } public String getAId() { return id; } public String getAName() { return name; } public int getAValue() { return value; } } @Entity @Table(name = "BEJB_1X1_BI_BTOB") public class B implements java.io.Serializable { // =========================================================== // instance variables @Id protected String id; @Basic protected String name; @Basic protected int value; // =========================================================== // relationship fields @OneToOne(targetEntity = A.class, cascade = CascadeType.ALL, optional = true, orphanRemoval = true) @JoinColumn(name = "FK_FOR_AEJB_1X1_BI_BTOB") protected A a1; // =========================================================== // constructors public B() { } public B(String id, String name, int value) { this.id = id; this.name = name; this.value = value; } public B(String id, String name, int value, A a1) { this.id = id; this.name = name; this.value = value; this.a1 = a1; } // ========================================================== // Business Methods for Test Cases public A getA1() { return a1; } public void setA1(A a1) { this.a1 = a1; } public boolean isA() { return getA1() != null; } public A getA1Info() { if (isA()) { A a1 = getA1(); return a1; } else return null; } public String getBId() { return id; } public String getBName() { return name; } public void setBName(String name) { this.name = name; } public int getBValue() { return value; } } } but as I said I think the exception is the expected behaviour with bytecode enhancement, see https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/m... ( https://hibernate.atlassian.net/browse/HHH-16542#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16542#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16544) nested tables on Oracle

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16544 ( https://hibernate.atlassian.net/browse/HHH-16544?atlOrigin=eyJpIjoiN2I5ND... ) Re: nested tables on Oracle ( https://hibernate.atlassian.net/browse/HHH-16544?atlOrigin=eyJpIjoiN2I5ND... ) Done. ( https://hibernate.atlassian.net/browse/HHH-16544#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16544#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16547) New `hibernate.jpa.compliance.delete` setting

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNWY2MzY4NDdm... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16547?atlOrigin=eyJpIjoiNWY2Mz... ) HHH-16547 ( https://hibernate.atlassian.net/browse/HHH-16547?atlOrigin=eyJpIjoiNWY2Mz... ) New `hibernate.jpa.compliance.delete` setting ( https://hibernate.atlassian.net/browse/HHH-16547?atlOrigin=eyJpIjoiNWY2Mz... ) Issue Type: Improvement Assignee: Unassigned Created: 03/May/2023 06:22 AM Priority: Major Reporter: Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Add a new setting hibernate.jpa.compliance.delete which controls how to handle deletion / removal of a detached entity. While Hibernate allows this, JPA says it is illegal. ( https://hibernate.atlassian.net/browse/HHH-16547#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16547#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16542) (Jakarta EE 10 Platform TCK) jpa/core/entitytest/cascadeall/oneXone/cascadeAll1X1Test10 test regression

by Scott Marlow (JIRA)

Scott Marlow ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16542 ( https://hibernate.atlassian.net/browse/HHH-16542?atlOrigin=eyJpIjoiODk0Mm... ) Re: (Jakarta EE 10 Platform TCK) jpa/core/entitytest/cascadeall/oneXone/cascadeAll1X1Test10 test regression ( https://hibernate.atlassian.net/browse/HHH-16542?atlOrigin=eyJpIjoiODk0Mm... ) Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) did you examine the updated bytecode? If not, would it help if I hack something together to obtain the enhanced bytecode for the test class (I think https://github.com/jakartaee/platform-tck/blob/master/src/com/sun/ts/test... )? ( https://hibernate.atlassian.net/browse/HHH-16542#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16542#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16541) (Jakarta EE 10 Platform TCK) jpa/core/lock/query/Client.java#getResultListTest1 test regression

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16541 ( https://hibernate.atlassian.net/browse/HHH-16541?atlOrigin=eyJpIjoiODFiOW... ) Re: (Jakarta EE 10 Platform TCK) jpa/core/lock/query/Client.java#getResultListTest1 test regression ( https://hibernate.atlassian.net/browse/HHH-16541?atlOrigin=eyJpIjoiODFiOW... ) To be clear, I was never able to reproduce this in vanilla ORM. I made the change we discussed and you verified, but regression testing is still missing since I could not reproduce. ( https://hibernate.atlassian.net/browse/HHH-16541#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16541#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16541) (Jakarta EE 10 Platform TCK) jpa/core/lock/query/Client.java#getResultListTest1 test regression

by Scott Marlow (JIRA)

Scott Marlow ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16541 ( https://hibernate.atlassian.net/browse/HHH-16541?atlOrigin=eyJpIjoiZjBjNG... ) Re: (Jakarta EE 10 Platform TCK) jpa/core/lock/query/Client.java#getResultListTest1 test regression ( https://hibernate.atlassian.net/browse/HHH-16541?atlOrigin=eyJpIjoiZjBjNG... ) Should be addressed by https://github.com/hibernate/hibernate-orm/pull/6494 ( https://hibernate.atlassian.net/browse/HHH-16541#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16541#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16546) Reduce verbosity of logs in a few edge cases

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTE0NDc5NjZl... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16546?atlOrigin=eyJpIjoiNTE0ND... ) HHH-16546 ( https://hibernate.atlassian.net/browse/HHH-16546?atlOrigin=eyJpIjoiNTE0ND... ) Reduce verbosity of logs in a few edge cases ( https://hibernate.atlassian.net/browse/HHH-16546?atlOrigin=eyJpIjoiNTE0ND... ) Issue Type: Improvement Assignee: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: hibernate-core Created: 03/May/2023 06:07 AM Fix Versions: 6.2.3 Priority: Major Reporter: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) There are a few INFO logs that really should be debug logs, because they don’t bring useful information to users and/or represent normal operation. In particular, on startup: * org.hibernate.internal.CoreMessageLogger#lazyPropertyFetchingAvailable : “Lazy property fetching available for <property name>“. This appears as soon as we annotate a property with @Basic(fetch = LAZY) , and I don’t think it’s necessary to remind the user of their mapping. And worse, at runtime: * org.hibernate.internal.CoreMessageLogger#handlingTransientEntity : "Handling transient entity in delete processing": apparently this behavior was added to comply with JPA spec. Why would we log at info level that we’re complying with JPA every time a transient entity is passed to delete? It may be weird, but if it’s according to spec… ? ( https://hibernate.atlassian.net/browse/HHH-16546#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16546#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16545) JPATraversableResolver is not Thread-Safe

by Andreas Lanz (JIRA)

Andreas Lanz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16545 ( https://hibernate.atlassian.net/browse/HHH-16545?atlOrigin=eyJpIjoiMjA5Mj... ) Re: JPATraversableResolver is not Thread-Safe ( https://hibernate.atlassian.net/browse/HHH-16545?atlOrigin=eyJpIjoiMjA5Mj... ) Hi Marco, we’re currently on Hibernate Validator 6.2.5-Final with Hibernate-Core 5.6.15.Final. However, looking at the code on GitHub this is still present on main (as confirmed by Christian). Note that this is not just an issue with a single ValidatorImpl instance used by multiple Threads, but also with each Thread using it's own Validator instance. In particular, the non-thread-safe part in PersistenceUtilHelper is static and will be shared by all instance of ValidatorImpl. ( https://hibernate.atlassian.net/browse/HHH-16545#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16545#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16483) Recursive CTE using Criteria API will throw `Already registered a copy: org.hibernate.query.sqm.tree.cte.SqmCteStatement` error

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16545) JPATraversableResolver is not Thread-Safe

by Marko Bekhta (JIRA)

Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16545 ( https://hibernate.atlassian.net/browse/HHH-16545?atlOrigin=eyJpIjoiYjlmYj... ) Re: JPATraversableResolver is not Thread-Safe ( https://hibernate.atlassian.net/browse/HHH-16545?atlOrigin=eyJpIjoiYjlmYj... ) Thanks Christian 🙂 ( https://hibernate.atlassian.net/browse/HHH-16545#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16545#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16483) Recursive CTE using Criteria API will throw `Already registered a copy: org.hibernate.query.sqm.tree.cte.SqmCteStatement` error

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16545) JPATraversableResolver is not Thread-Safe

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16545 ( https://hibernate.atlassian.net/browse/HHH-16545?atlOrigin=eyJpIjoiYzUyNj... ) Re: JPATraversableResolver is not Thread-Safe ( https://hibernate.atlassian.net/browse/HHH-16545?atlOrigin=eyJpIjoiYzUyNj... ) I just checked the code and it is a legit issue that is still present. ( https://hibernate.atlassian.net/browse/HHH-16545#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16545#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16545) JPATraversableResolver is not Thread-Safe

by Christian Beikov (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16544) nested tables on Oracle

by Gavin King (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16370) Using MapKey on ManyToMany leads to wrong insert SQL

by Andrea Boriero (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16544) nested tables on Oracle

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNWMzYTkzZjZj... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16544?atlOrigin=eyJpIjoiNWMzYT... ) HHH-16544 ( https://hibernate.atlassian.net/browse/HHH-16544?atlOrigin=eyJpIjoiNWMzYT... ) nested tables on Oracle ( https://hibernate.atlassian.net/browse/HHH-16544?atlOrigin=eyJpIjoiNWMzYT... ) Change By: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Following on from [https://hibernate.atlassian.net/browse/HHH-16125|https://hibernate.atlass...], we could allow: {code:java}@Column(length = 25) @JdbcTypeCode(SqlTypes.TABLE) String[] strings;{code} in order to generate: {{ create or replace type StringArray as table of varchar2(25 char) }} instead of: {{ create or replace type StringArray as varying array(127) of varchar2(25 char) }} However, I think we should leave this as an incubating feature for now. ( https://hibernate.atlassian.net/browse/HHH-16544#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16544#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16544) nested tables on Oracle

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiM2U0NjkzZjMz... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16544?atlOrigin=eyJpIjoiM2U0Nj... ) HHH-16544 ( https://hibernate.atlassian.net/browse/HHH-16544?atlOrigin=eyJpIjoiM2U0Nj... ) nested tables on Oracle ( https://hibernate.atlassian.net/browse/HHH-16544?atlOrigin=eyJpIjoiM2U0Nj... ) Change By: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Following on from [https://hibernate.atlassian.net/browse/HHH-16125|https://hibernate.atlass...], we could allow: {code:java}@ Array(length = 33) @ Column(length = 25) @JdbcTypeCode(SqlTypes.TABLE) String[] strings;{code} in order to generate: create or replace type StringArray as table of varchar2(25 char) instead of: create or replace type StringArray as varying array(127) of varchar2(25 char) However, I think we should leave this as an incubating feature for now. ( https://hibernate.atlassian.net/browse/HHH-16544#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16544#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HHH-16544) nested tables on Oracle

by Gavin King (JIRA)

3 years

1
0
0 / 0

[JIRA] (HSEARCH-4850) Add compatibility with OpenSearch 2.7.0

by Automation for Jira (JIRA)

3 years

1
0
0 / 0

[JIRA] (HSEARCH-4850) Add compatibility with OpenSearch 2.7.0

by Marko Bekhta (JIRA)

3 years

1
0
0 / 0

[JIRA] (HSEARCH-4850) Add compatibility with OpenSearch 2.7.0

by Marko Bekhta (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16298) Failure merging a referenced entity

by Andrea Boriero (JIRA)

3 years

1
0
0 / 0

[JIRA] (HV-1947) JPATraversableResolver is not Thread-Safe

by Marko Bekhta (JIRA)

Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HV-1947 ( https://hibernate.atlassian.net/browse/HV-1947?atlOrigin=eyJpIjoiMGExNzAx... ) Re: JPATraversableResolver is not Thread-Safe ( https://hibernate.atlassian.net/browse/HV-1947?atlOrigin=eyJpIjoiMGExNzAx... ) Hey Andreas Lanz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , thanks for reaching out and reporting a problem. It doesn’t look like that much can be done on the validator side since JPATraversableResolver just refers to the Persistence.getPersistenceUtil().isLoaded(). Could you please provide more details on what ORM version you are using so that maybe someone from the ORM team can provide you with some feedback? Thanks! cc: Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) ( https://hibernate.atlassian.net/browse/HV-1947#add-comment?atlOrigin=eyJp... ) Add Comment ( https://hibernate.atlassian.net/browse/HV-1947#add-comment?atlOrigin=eyJp... ) 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#100224- sha1:4684446 )

3 years

1
0
0 / 0

[JIRA] (HSEARCH-4850) Add compatibility with OpenSearch 2.7.0

by Marko Bekhta (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16192) Hibernate Envers triggers wrong column type during validation

by Sebastian Götz (JIRA)

Sebastian Götz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6203fe7... ) *commented* on HHH-16192 ( https://hibernate.atlassian.net/browse/HHH-16192?atlOrigin=eyJpIjoiMGMyNT... ) Re: Hibernate Envers triggers wrong column type during validation ( https://hibernate.atlassian.net/browse/HHH-16192?atlOrigin=eyJpIjoiMGMyNT... ) I have the same issue here. We are trying to update to the most recent Hibernate 6.2.1 and are failing at the exact same problem. We have a simple entity with a byte[] field annotated as lob. While ORM maps this to a *varbinary(max)* on SQL-Server ENVERS contributes its audit table with a *varbinary(255)*. I am debugging on this but it’s quite hard to understand the different stages of meta model resolving along with the contributor contract. Moreover envers seems to have its own definition of a column (org.hibernate.envers.boot.model.Column). I tracked it down to org.hibernate.boot.model.source.internal.hbm.ModelBinder.resolveLob(SingularAttributeSourceBasic, SimpleValue) where the envers audit table has the typeName property set to "binary" resolving to the sqlType -3 (varbinary) but the length is set to 255. The entity model breaks down to this: @Entity @Table(name = "ByteData" ) @Audited public class ByteData { @Id @Access(AccessType.PROPERTY) @Column(name = PROPERTY_ID, length = 36, nullable = false ) private String id = IdGenerator.generateId(); @Version @Column(name = PROPERTY_VERSION) private Integer version = null ; @Column(name = "data" ) @Lob private byte [] data; ... } ( https://hibernate.atlassian.net/browse/HHH-16192#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16192#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#100224- sha1:4684446 )

3 years

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues May 2023