Illegal attempt to dereference path source [null.events] of basic type

[nikez]

Hi!

I tried to incorporate this to a project I'm working with but I can't seem to get it to work.

This works just fine (Without your filter)

CriteriaBuilder cb = entityManager.getCriteriaBuilder();

CriteriaQuery<Message> query = cb.createQuery(Message.class);

Root<Message> root = query.from(Message.class);
Join<Message, Event> join = root.join("events", JoinType.INNER);
query = query
	.select(root)
	.where(
		cb.equal(join.get("eventType"), Event.EventType.SENT)
	);
return entityManager.createQuery(query).getResultList();

However, trying to do the same with

selectFrom(messageRepository).innerJoin("events").where(filter).findAll();

and in-data
{ "field": "events.eventType", "operator": "eq", "value": "SENT" }

Results in the following error:

exception.GlobalControllerExceptionHandler - global controller exception handler encountered exception: SpecificationException message: Meet problem when parse field path: events.eventType, this path does not exist. Illegal attempt to dereference path source [null.events] of basic type

SpecificationException: Meet problem when parse field path: events.eventType, this path does not exist. Illegal attempt to dereference path source [null.events] of basic type

Caused by: java.lang.IllegalStateException: Illegal attempt to dereference path source [null.events] of basic type

[ZhongjunTian]

Looks like this is caused by not found ‘events’ in Message Or Message is not found ? I will look at it tomorrow

…

On Aug 29, 2018, at 01:04, Nikez ***@***.***> wrote: Hi! I tried to incorporate this to a project I'm working with but I can't seem to get it to work. This works just fine (Without your filter) CriteriaBuilder cb = entityManager.getCriteriaBuilder(); CriteriaQuery<Message> query = cb.createQuery(Message.class); Root<Message> root = query.from(Message.class); Join<Message, Event> join = root.join("events", JoinType.INNER); query = query .select(root) .where( cb.equal(join.get("eventType"), Event.EventType.SENT) ); return entityManager.createQuery(query).getResultList(); However, trying to do the same with selectFrom(messageRepository).innerJoin("events").where(filter).findAll(); and in-data { "field": "events.eventType", "operator": "eq", "value": "SENT" } Results in the following error: exception.GlobalControllerExceptionHandler - global controller exception handler encountered exception: SpecificationException message: Meet problem when parse field path: events.eventType, this path does not exist. Illegal attempt to dereference path source [null.events] of basic type SpecificationException: Meet problem when parse field path: events.eventType, this path does not exist. Illegal attempt to dereference path source [null.events] of basic type Caused by: java.lang.IllegalStateException: Illegal attempt to dereference path source [null.events] of basic type — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

[nikez]

The thing is that the JPA Criteria above uses the same model and names, but it has no issue.. So I'm not sure! But thanks for taking a look.

[ZhongjunTian]

You can change code throw new SpecificationException("Meet problem when parse field path: " + field + ", this path does not exist. " + e.getMessage(), e); to print call stack to see the root cause. I think something wrong when private Path<Object> parsePath(Path<? extends Object> root, String field) Please make sure your messageRepository is correctly configured

…

On Wed, Aug 29, 2018 at 1:42 AM Nikez ***@***.***> wrote: The thing is that the JPA Criteria above uses the same model and names, but it has no issue.. So I'm not sure! But thanks for taking a look. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#6 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AGxKvtNgzC_foZqbIckfDFanMGbu_Di4ks5uVlPegaJpZM4WRCG5> .

-- Best Regards Jon (Zhongjun)

[nikez]

It is, as far as I can tell.

Caused by: java.lang.IllegalStateException: Illegal attempt to dereference path source [null.events] of basic type
	at org.hibernate.query.criteria.internal.path.AbstractPathImpl.illegalDereference(AbstractPathImpl.java:82)
	at org.hibernate.query.criteria.internal.path.AbstractPathImpl.get(AbstractPathImpl.java:174)

public interface MessageRepository extends JpaSpecificationExecutor, JpaRepository<Message, Long> {
	Message findByMessageId(@Param("messageId") String messageId);
}```

[ZhongjunTian]

http://sansjavadevelopment.blogspot.com/2011/07/error-javalangillegalargumentexception.html

I found someone else got the same exception

But I cannot reproduce the same issue. If you look at my code, there is PersonController, I run the same query like you return selectFrom(personRepository).innerJoin("address").where(filter).findAll();
Did not get any exception.

PLEASE look at my latest commit, I added some logging for debug. You may get some useful info from logs

[ZhongjunTian]

could you add a method
run

{
CriteriaBuilder cb = entityManager.getCriteriaBuilder();

CriteriaQuery<Message> query = cb.createQuery(Message.class);

Root<Message> root = query.from(Message.class);
Join<Message, Event> join = root.join("events", JoinType.INNER);
query = query
	.select(root)
	.where(
		cb.equal(join.get("eventType"), Event.EventType.SENT)
	);
List list = entityManager.createQuery(query).getResultList();
//the code upon may invoke some other code to register Message in Hibernate? I guess
return selectFrom(messageRepository).innerJoin("events").where(filter).findAll();
}

[nikez]

No success.

INNER join root class Message with table [events] 
Parsing child path events.eventType of root class Message
exception.GlobalControllerExceptionHandler - global controller exception handler encountered exception: SpecificationException message: Met problem when parse field path: events.eventType, this path does not exist. [Ljava.lang.StackTraceElement;@5a06217c 
SpecificationException: Met problem when parse field path: events.eventType, this path does not exist. [Ljava.lang.StackTraceElement;@5a06217c

[borja-glez]

Hi, i update this library with OneToOne, ManyToOne, OneToMany, ManyToMany supported and added other functionalities like pagination in the rest filter, ignorecase and more.

Check it here: https://github.com/borja-glez/springify

[ZhongjunTian]

Great job doing that :)