July 2023 - hibernate-issues - Jboss List Archives

Markus Hofstetter ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15777 ( https://hibernate.atlassian.net/browse/HHH-15777?atlOrigin=eyJpIjoiMTBlZG... ) Re: wrong column type expected for audit table keys ( https://hibernate.atlassian.net/browse/HHH-15777?atlOrigin=eyJpIjoiMTBlZG... ) I also encountered this Problem. Envers ignores the @JdbcTypeCode Annotation. I have a @MappedSuperclass that defines an id like this: @Schema @Id // @Type(value = org.hibernate.type.UUIDCharType.class) // this was the way to do it in hibernate 5 @JdbcTypeCode(SqlTypes.VARCHAR) // hibernate 6 way @Column(nullable = false, updatable = false, length = DB_UUID_LENGTH) @NonNull private UUID id = UUID.randomUUID(); When exporting the schema through hibernate this creates the actual Entity Tables correctly but envers tries to generate a binary column. The DB dialect I am using is mariadb. CREATE TABLE IndexPerson ( id VARCHAR(36) NOT NULL, userErstellt_id VARCHAR(36) NOT NULL, userMutiert_id VARCHAR(36), name VARCHAR(255), vorname VARCHAR(255) NOT NULL, PRIMARY KEY (id) ) ENGINE = InnoDB; CREATE TABLE IndexPerson_AUD ( id BINARY(36) NOT NULL, userErstellt_id BINARY(36), userMutiert_id BINARY(36), name VARCHAR(255), vorname VARCHAR(255), PRIMARY KEY (REV, id) ) ENGINE = InnoDB; As you can see varchar(36) is used for the "real" entity table as requested. However the audit Table is generated with a binary column which obviously will not work. ( https://hibernate.atlassian.net/browse/HHH-15777#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15777#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#100231- sha1:2d13be9 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16860) OneToMany with inherited classes on both sides

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16860 ( https://hibernate.atlassian.net/browse/HHH-16860?atlOrigin=eyJpIjoiMzJmMW... ) Re: OneToMany with inherited classes on both sides ( https://hibernate.atlassian.net/browse/HHH-16860?atlOrigin=eyJpIjoiMzJmMW... ) Hi Rob Scala ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , we’re looking into this. Can you tell us what version of Hibernate did you migrate from? And were the extra columns (on the child entity tables) created with that version? ( https://hibernate.atlassian.net/browse/HHH-16860#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16860#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#100231- sha1:2d13be9 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16931) add SelectionQuery.getResultCount() and Pager.getPageCount()

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=eyJpIjoiMTk5ODUyZjJm... ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-16931?atlOrigin=eyJpIjoiMTk5OD... ) HHH-16931 ( https://hibernate.atlassian.net/browse/HHH-16931?atlOrigin=eyJpIjoiMTk5OD... ) add SelectionQuery.getResultCount() and Pager.getPageCount() ( https://hibernate.atlassian.net/browse/HHH-16931?atlOrigin=eyJpIjoiMTk5OD... ) Issue Type: New Feature Assignee: Unassigned Components: query-criteria, query-hql, query-sql Created: 12/Jul/2023 06:08 AM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) For query pagination users sometimes want a convenient way to just get the number of pages by running a count query. Of course it’s not difficult to implement this on top of our APIs, but since every framework built on top of Hibernate reimplements this, we may as well provide a standard implementation. To be clear, we would implement this by: * messing with the SQM tree for HQL and criteria queries, and * by wrapping in an outer select for native queries (or, perhaps, in the case where there’s only one select keyword in the query, by just replacing the select list). ( https://hibernate.atlassian.net/browse/HHH-16931#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16931#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#100231- sha1:2d13be9 )

2 years, 9 months

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 July 2023