com.mongodb.util.JSONParseException in Spring Boot?

Question

I tried to create custom query using @Query annotation. But it throws some error.

This is my Repository

package com.springboot.springmongodb.user;
import java.util.List;
import org.springframework.data.mongodb.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;
import org.springframework.transaction.annotation.Transactional;

public interface UserRepository extends CrudRepository<User, String>{
    @Override
    User findOne(String id);

    @Transactional(readOnly=false)
    @Query("SELECT user FROM User user WHERE user.username = :username")
    public List<User> findByUsername(@Param("username") String username);

}

I want to create custom query for check username.

Here the error which I'm getting.

2017-12-04 14:46:10.413 WARN 1452 --- [ main] ationConfigEmbeddedWebApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'springSecurityFilterChain' defined in class path resource [org/springframework/security/config/annotation/web/configuration/WebSecurityConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.servlet.Filter]: Factory method 'springSecurityFilterChain' threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userDetailsService': Unsatisfied dependency expressed through field 'userRep'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userRepository': Invocation of init method failed; nested exception is com.mongodb.util.JSONParseException: SELECT user FROM User user WHERE user.username = :username ^

It seems that you are declaring a SQL Query as mongodb. A mongo query should look like this: @Query("{ 'firstname' : ?0 }") — Clijsters
– Clijsters, Commented Dec 4, 2017 at 9:15
Would you try to code format it? The line breaks are surely not original. — Clijsters
– Clijsters, Commented Dec 4, 2017 at 9:22

Clijsters · Accepted Answer · 2017-12-04 09:25:44Z

3

The exception tells that the @Query you gave gets treated as JSON. Taking a look at your imports leads us to the reason:

import org.springframework.data.mongodb.repository.Query;

While your query SELECT user FROM User user WHERE user.username = :username would be valid for JPA (SQL), it's invalid for MongoDB. Either change your import to fit your database or change the query to fit it.

A valid mongoDB looks like from the Spring Data MongoDB example:

public interface PersonRepository extends MongoRepository<Person, String>

  @Query("{ 'username' : ?0 }")
  List<Person> findByThePersonsFirstname(String firstname);

}

...And a valid JPA statement from the Spring Data JPA example:

public interface UserRepository extends JpaRepository<User, Long> {

  @Query("select u from User u where u.username = ?1")
  User findByEmailAddress(String emailAddress);
}

This would need the import org.springframework.data.jpa.repository.Query

edited Dec 4, 2017 at 9:25

answered Dec 4, 2017 at 9:17

Clijsters

4,3622 gold badges30 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

Sankar Over a year ago

Yes I have given the same import which you have mentioned.

Clijsters Over a year ago

That's the problem I think. What's your database?

Sankar Over a year ago

Here am using Crudrepository interface

Sankar Over a year ago

Absolutely mongodb

Clijsters Over a year ago

Than your query is invalid. Try change it as I suggested.

|

Collectives™ on Stack Overflow

com.mongodb.util.JSONParseException in Spring Boot?

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related