Davide D'Alto

We already test batching in some places: * https://github.com/hibernate/hibernate-reactive/blob/main/hibernate-reactive-core/src/test/java/org/hibernate/reactive/BatchFetchTest.java * https://github.com/hibernate/hibernate-reactive/blob/main/hibernate-reactive-core/src/test/java/org/hibernate/reactive/SubselectFetchTest.java These are the new methods: https://github.com/hibernate/hibernate-reactive/pull/1747

JsonTypeTest fails for MariaDB

4

The test is temporarily disabled for MariaDB: c32c331d682e8e52060ea9bb059bb315cbee1831 Testing with MariaDB requires the support for MySQL: https://github.com/hibernate/hibernate-reactive/issues/1528

Add examples for mapping a Json in the documentation

1

Some tests showing the different approaches are: * [UserJsonTypeTest](https://github.com/hibernate/hibernate-reactive/blob/main/hibernate-reactive-core/src/test/java/org/hibernate/reactive/types/UserJsonTypeTest.java) * [StringToJsonTypeTest](https://github.com/hibernate/hibernate-reactive/blob/main/hibernate-reactive-core/src/test/java/org/hibernate/reactive/types/StringToJsonTypeTest.java) * [JsonTypeTest](https://github.com/hibernate/hibernate-reactive/blob/main/hibernate-reactive-core/src/test/java/org/hibernate/reactive/types/JsonTypeTest.java)

Support the `StatementInspector` API

1

Based on [this question on StackOverflow](https://stackoverflow.com/questions/76619519/sql-inspection-injection-in-hibernate-reactive), we don't support the [StatementInspector](https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/main/java/org/hibernate/resource/jdbc/spi/StatementInspector.java) API. It seems something useful to have, but I haven't looked into it yet. We should: 1. Check that...

Check that we actually run the custom queries in CustomStoredProcedureSqlTest

4

In [CustomStoredProcedureSqlTest](https://github.com/hibernate/hibernate-reactive/blob/main/hibernate-reactive-core/src/test/java/org/hibernate/reactive/CustomStoredProcedureSqlTest.java), we use custom queries with stored procedures to test the support for the annotation `@SqlInsert`, `@SqlUpdate`, and `@SqlDelete`. It works fine, but we are not actually checking that...

[Snapshots should be here](https://quarkusio.zulipchat.com/#narrow/stream/187038-dev/topic/Vert.2Ex.204.2E4.2E3/near/365527412): > you can try with: > ``` > > sonatype-s01-snapshots > https://s01.oss.sonatype.org/content/repositories/snapshots > > true > > > ``` > > Or > > ``` >...

Support Lob in Postgres

2

Postgres Vert.x SQL client [doesn't seem to support the OID type](https://vertx.io/docs/vertx-pg-client/java/#_postgresql_type_mapping). See https://github.com/eclipse-vertx/vertx-sql-client/issues/1328 Marking this as regression, because it used to work before the Upgrade to ORM 6.2

Vert.x Db2 client currently [doesn't support type CLOB](https://vertx.io/docs/vertx-db2-client/java/#_db2_type_mapping): ``` Some types that are currently NOT supported are: XML BLOB CLOB DBCLOB GRAPHIC / VARGRAPHIC ``` We need to wait for...

See https://hibernate.atlassian.net/jira/software/c/projects/HHH/issues/HHH-16377

Follows [quarkus#33776](https://github.com/quarkusio/quarkus/issues/33776) [Extracting the info needed for schema generation is a blocking operation](https://github.com/hibernate/hibernate-reactive/blob/f17e8a1e80c70329baaf3d98fc7f229bf68b02e7/hibernate-reactive-core/src/main/java/org/hibernate/reactive/provider/service/ReactiveImprovedExtractionContextImpl.java#L113) This seems to work fine when the max pool size is bigger than 1, but it will...