SqmTypedNode.getExpressible() is null

Hibernate ORM
1

I update project from spring boot 2 to spring boot 3. After updating i’ve got errors (at the end).
My Entity:

@Entity
@Table(name = "rules")
@Getter
@Setter
@Builder
@ToString
@NoArgsConstructor
@AllArgsConstructor
@Accessors(chain = true)
public class Rules {
  @Id
  private Long id;

  @JdbcTypeCode(SqlTypes.ARRAY)
  @Column(name = "message_department_ids")
  private List<Long> messageDepartmentIds;
}

Repository:

@Repository
@Retryable(value = { SQLException.class }, maxAttemptsExpression = "#{${retry.maxAttempts:2147483647}}",
        backoff = @Backoff(delayExpression = "#{${retry.delay:1000}}"))
public interface RulesRepository extends JpaRepository<Rules, Long>, JpaSpecificationExecutor<Rules> {

    @Modifying
    @Query("UPDATE Rules " +
            "SET messageDepartmentIds = FUNCTION('ARRAY_REMOVE', messageDepartmentIds, :departmentId) " +
            "WHERE id = :id")
    void deleteDepartmentId(@Param("id") Long id, @Param("departmentId") Long departmentId);
}

And exception:

Validation failed for query for method public abstract void project.repository.RulesRepository.deleteDepartmentId(java.lang.Long,java.lang.Long)

Caused by: org.hibernate.query.sqm.InterpretationException: Error interpreting query [Cannot invoke "org.hibernate.query.sqm.SqmExpressible.getSqmType()" because the return value of "org.hibernate.query.sqm.tree.SqmTypedNode.getExpressible()" is null] [UPDATE Rules SET messageDepartmentIds = FUNCTION('ARRAY_REMOVE', messageDepartmentIds, :departmentId) WHERE id = :id] [UPDATE Rules SET messageDepartmentIds = FUNCTION('ARRAY_REMOVE', messageDepartmentIds, :departmentId) WHERE id = :id]

Caused by: java.lang.NullPointerException: Cannot invoke "org.hibernate.query.sqm.SqmExpressible.getSqmType()" because the return value of "org.hibernate.query.sqm.tree.SqmTypedNode.getExpressible()" is null

Can’t understand what should i do. Version of Hibernate is 6.4.1 Final. Version of Spring-boot 3.2.2

2

Hello @Kolom123, note that version 6.4.1 of Hibernate is no longer supported. Please upgrade to the latest 6.4 release or, even better, to the latest stable (6.6.11 at this time).

3

I updated Hibernate to version 6.6.11 , but it doesn’t help at all :frowning:

4

An NPE is always a bug, so please try to create a reproducer with our test case template and if you are able to reproduce the issue, create a new ticket in our issue tracker and attach that reproducer.

I’m guessing the error is caused by the fact we’re not resolving the type of the custom function() expression correctly. Note that Hibernate introduced native support for array functions since version 6.4, including array_remove(), so you should be able to just use that function instead and fix your query.

5

Yesterday I rewrite hibernate query on nativequery and seems like it’s worked for me. So I think that question may be closed. Thanks for help