org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.query.SyntaxException: At x:xx and token ')', no viable alternative at input

[lasselindqvist]

Updating automatically to Spring Boot 3.5.0 gave me

service | org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.query.SyntaxException: At 1:41 and token ')', no viable alternative at input 'SELECT new domain.Table(*) FROM Table t WHERE t.linkedId = :linkedId AND NOT t.id = :originalId' [SELECT new domain.Table() FROM Table t WHERE t.linkedId = :linkedId AND NOT t.id = :originalId]
service | 	at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:371) ~[spring-orm-6.2.7.jar:6.2.7]

The query itself is defined as

	@Query(value = """
			SELECT t FROM Table t
			WHERE t.linkedId = :linkedId
			AND NOT t.id = :originalId
			""")
	Table findOtherCustomershipByLinkedCustomershipId(@Param("linkedId") Long linkedId,
			@Param("originalId") Long originalId);

This worked previously and return a "Table" object. Could be an issue in Hibernate or spring-orm or spring-data-jpa. I am not sure. Or then this syntax was never supported?

[mp911de]

What domain type do you use in the repository (e.g. how does your extends Repository<…> part look like)?

This one looks like a duplicate of #3895

[lasselindqvist]

The query is in a Repository for another table, not the "Table" used there in the example.
But seems like a duplicate for the mentioned issue.