error with @Query annotation

[jmdavid]

When I try to use Query annotation:

public interface WorkflowInstanceRepository extends JpaRepository<WorkflowInstance, Long> {
@query("SELECT wi FROM WorkflowInstance wi WHERE wi.currentState = :currentState")
WorkflowVariableInstance findByCustomParams(@param("currentState") String currentState);
}

Entity is marked as followed:

@entity(name = "workflow_instance")
public class WorkflowInstance {
...
}

I get an error:
org.hibernate.hql.internal.ast.QuerySyntaxException: WorkflowInstance is not mapped

[dsyer]

Stupid question: is the entity mapped? Seems like a mapping issue not a Boot issue on the face of it. Maybe you can share a simple project that reproduces the problem?

[wilkinsona]

Apologies, I fat-fingered the issue number in a commit comment

[jmdavid]

I finally found why. I wanted all my names in my front-end with underscore (ie last_name); so I added this bean:

@bean
public ObjectMapper objectMapper() {
ObjectMapper objectMapper = new ObjectMapper();
objectMapper.setPropertyNamingStrategy(PropertyNamingStrategy.CAMEL_CASE_TO_LOWER_CASE_WITH_UNDERSCORES);
return objectMapper;
}

So far, so good, my JSON is happy. My models are like this:

@entity(name = "workflow_variable_instance")
public class WorkflowVariableInstance {
...
@column(name="workflow_variable_id")
private Long workflowVariableId;
...

When using @query, I had the aforementioned error. But if I write my query like this:

@query("SELECT v FROM workflow_variable_instance v WHERE v.workflowVariableId = :workflowVariableId AND v.workflowInstanceId = :workflowInstanceId")
List findByCustomParams(@param("workflowVariableId") Long workflowVariableId,
@param("workflowInstanceId") Long workflowInstanceId);

It works!

It is quite odd because the FROM clause has the "table" name and not the "class" name, but the WHERE clause has the "property" names (and not the "field" name)!

Thank you by the way for support.