April 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16306) CountExpressionTest.testCountDistinctTuple fails on Sybase

by Steve Ebersole (JIRA)

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16314) Skip NativeQueryResultTypeAutoDiscoveryTest#dateTimeTypes for Sybase

by Steve Ebersole (JIRA)

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16321) Hibernate maps NCLOB to ntext on Sybase

by Steve Ebersole (JIRA)

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16321) Hibernate maps NCLOB to ntext on Sybase

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16321 ( https://hibernate.atlassian.net/browse/HHH-16321?atlOrigin=eyJpIjoiZjJiOT... ) Re: Hibernate maps NCLOB to ntext on Sybase ( https://hibernate.atlassian.net/browse/HHH-16321?atlOrigin=eyJpIjoiZjJiOT... ) I was able to get this supported without changing the APIs ( https://hibernate.atlassian.net/browse/HHH-16321#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16321#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#100223- sha1:cdc0af3 )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16321) Hibernate maps NCLOB to ntext on Sybase

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16321 ( https://hibernate.atlassian.net/browse/HHH-16321?atlOrigin=eyJpIjoiMDRjZT... ) Re: Hibernate maps NCLOB to ntext on Sybase ( https://hibernate.atlassian.net/browse/HHH-16321?atlOrigin=eyJpIjoiMDRjZT... ) If we do end up adding support for this, it probably can be handled by splitting org.hibernate.engine.jdbc.LobCreator up into separate parts for BLOB , CLOB and NCLOB. That way we can test all three methods on the driver and return appropriate creators for each. interface BlobCreator { Blob wrap(Blob blob); Blob createBlob( byte [] bytes); ... } interface ClobCreator { Clob wrap(Clob clob); Clob createClob( String string); ... } interface NClobCreator { NClob wrap(NClob nclob); NClob createNClob( String string); ... } ( https://hibernate.atlassian.net/browse/HHH-16321#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16321#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#100223- sha1:cdc0af3 )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16321) Hibernate maps NCLOB to ntext on Sybase

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16321 ( https://hibernate.atlassian.net/browse/HHH-16321?atlOrigin=eyJpIjoiNmZkNm... ) Re: Hibernate maps NCLOB to ntext on Sybase ( https://hibernate.atlassian.net/browse/HHH-16321?atlOrigin=eyJpIjoiNmZkNm... ) I changed this to use Sybase’s specific unitext type, which is their renaming of the T-SQL ntext type. Unfortunately this test still fails because we try to create a NClob from the Connection for the s.getLobHelper().createNClob( ... ) call. jConnect does not implement that method (or maybe only in case of ENABLE_LOB_LOCATORS , not really sure). That comes about because we assume that if the driver implements one, it implements them all - makes sense, right? Well unfortunately, the jConnect driver does implement Connection#createBlob and Connection#createClob ; it just does not implement Connection#createNClob oddly. I’m just going to skip this test for Sybase. The use case here would be someone mapping a long (n)varchar as a (N)Clob in their Java model. No one is doing that. And if they are doing that on Sybase, I think we just say that is not supported (though it would be interesting to try with ENABLE_LOB_LOCATORS enabled). ( https://hibernate.atlassian.net/browse/HHH-16321#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16321#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#100223- sha1:cdc0af3 )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16306) CountExpressionTest.testCountDistinctTuple fails on Sybase

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16306 ( https://hibernate.atlassian.net/browse/HHH-16306?atlOrigin=eyJpIjoiM2U5Nm... ) Re: CountExpressionTest.testCountDistinctTuple fails on Sybase ( https://hibernate.atlassian.net/browse/HHH-16306?atlOrigin=eyJpIjoiM2U5Nm... ) We are probably going to have to look at server configs and compare. I’m going to back-burner this one for now. ( https://hibernate.atlassian.net/browse/HHH-16306#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16306#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#100223- sha1:cdc0af3 )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16306) CountExpressionTest.testCountDistinctTuple fails on Sybase

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16306 ( https://hibernate.atlassian.net/browse/HHH-16306?atlOrigin=eyJpIjoiZDc4OT... ) Re: CountExpressionTest.testCountDistinctTuple fails on Sybase ( https://hibernate.atlassian.net/browse/HHH-16306?atlOrigin=eyJpIjoiZDc4OT... ) Not sure what is different, but I am not able to reproduce this… $ ../gradlew test -Pdb=sybase_jconn_ci --tests=org.hibernate.orm.test.query.hql.CountExpressionTest.testCountDistinctTuple Java versions for main code: [compiler:17, release:11] Java versions for tests: [compiler:17, release:17, launcher:17] Type-safe dependency accessors is an incubating feature. > Configure project : No android or java plugins found in the project hibernate-orm, checker compiler options will not be applied. BUILD SUCCESSFUL in 3s ( https://hibernate.atlassian.net/browse/HHH-16306#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16306#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#100223- sha1:cdc0af3 )

3 years, 1 month

1
0
0 / 0

[JIRA] (HSEARCH-4839) Test Hibernate Search regularly against the latest version of Lucene

by Automation for Jira (JIRA)

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16517) H6: Problems with flush when batch is ON (without @DynamicUpdate)

by Nemanja Jovanovic (JIRA)

Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmM5OTU0Nzc2... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16517?atlOrigin=eyJpIjoiNmM5OT... ) HHH-16517 ( https://hibernate.atlassian.net/browse/HHH-16517?atlOrigin=eyJpIjoiNmM5OT... ) H6: Problems with flush when batch is ON (without @DynamicUpdate) ( https://hibernate.atlassian.net/browse/HHH-16517?atlOrigin=eyJpIjoiNmM5OT... ) Change By: Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Update statement does not get generated when flushing in case we have batching on for following example: {noformat}@Entity @Inheritance(strategy = InheritanceType.JOINED) class BaseEntity implements Serializable { private static final long serialVersionUID = -5412503864464287451L; @Id long id; @Column(name = "VAL") int val; } @Entity @PrimaryKeyJoinColumn(name = "ID") class FooEntity extends BaseEntity { private static final long serialVersionUID = 6681665021507587925L; @Column(name = "NAME") String name; FooEntity() {} FooEntity(long id) { this.id = id; } } @Entity class SingleTableEntity implements Serializable { private static final long serialVersionUID = -5412503864464287451L; @Id long id; @Column(name = "NAME") String name; SingleTableEntity() {} SingleTableEntity(long id) { this.id = id; } } public class FlushTest { @Test public void test() { Transaction txn = null; try (final Session session = newSessionFactory().openSession()) { txn = session.beginTransaction(); final FooEntity foo = new FooEntity(1L); session.persist(foo); session.flush(); session.clear(); FooEntity fetched = session.get(FooEntity.class, 1L); fetched.name = "string"; session.flush(); session.clear(); fetched = session.get(FooEntity.class, 1L); fetched.name = "string2"; // This flush does not generate update, and it should session.flush(); session.clear(); fetched = session.get(FooEntity.class, 1L); assertEquals("string2", fetched.name); txn.rollback(); } } @Test public void testSingleTable() { Transaction txn = null; try (final Session session = newSessionFactory().openSession()) { txn = session.beginTransaction(); final SingleTableEntity foo = new SingleTableEntity(1L); session.persist(foo); session.flush(); session.clear(); SingleTableEntity fetched = session.get(SingleTableEntity.class, 1L); fetched.name = "string"; session.flush(); session.clear(); fetched = session.get(SingleTableEntity.class, 1L); fetched.name = "string2"; session.flush(); session.clear(); fetched = session.get(SingleTableEntity.class, 1L); assertEquals("string2", fetched.name); txn.rollback(); } } protected SessionFactory newSessionFactory() { final Properties properties = new Properties(); properties.put("hibernate.hbm2ddl.auto", "create"); properties.put("hibernate.show_sql", "true"); properties.put("hibernate.dialect", "org.hibernate.dialect.HSQLDialect"); properties.put("hibernate.connection.driver_class", "org.hsqldb.jdbc.JDBCDriver"); properties.put("hibernate.connection.url", "jdbc:hsqldb:mem:test"); properties.put("hibernate.connection.username", "sa"); properties.put("hibernate.connection.password", ""); // putting batch_size to 1 solves the problem properties.put("hibernate.jdbc.batch_size", "2"); return new Configuration().addProperties(properties) .addAnnotatedClass(BaseEntity.class) .addAnnotatedClass(FooEntity.class) .addAnnotatedClass(SingleTableEntity.class) .buildSessionFactory(new StandardServiceRegistryBuilder().applySettings(properties).build()); } } {noformat} After some debugging found quick workaround and potentially source of the problem, removing {noformat} if (currentBatch.getKey().equals(key)) { return currentBatch; }{noformat} from org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch solves the problem. It seems that state of {{currentBatch}} is left from previous statement execution but with all preparestatements cleared. And since {{BatchKey}} is the same as previous update , empty batch , ( without prepared statements , ) is being reused and no update statement is being generated/executed. This issue seems to be related to [https://hibernate.atlassian.net/browse/HHH-16367|https://hibernate.atlass... that one is I think wrongfully closed as duplicate. Test case eclipse project with pom attached to issue. ( https://hibernate.atlassian.net/browse/HHH-16517#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16517#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#100223- sha1:cdc0af3 )

3 years, 1 month

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