Error query jpa spring boot

I am working with jpa connect to mysql. when I use query to table database follow:

public interface CommentRepository  extends JpaRepository<Comment1, Integer>{
	@Query(value = "SELECT * FROM comment1 WHERE contribution_id=:contributionId",nativeQuery = true)
	List<Comment1> findByContributionId(@Param("contributionId") String contributionId);
}

Answers


UPDATE: I check more time and find a cause that it relate to colume create_date If create date > 2015-06-24 15:47:52 it can not query true.

enter image description here


Need Your Help

how to send parameters to a web Services via SOAP?

iphone objective-c web-services parameters

Before I start: I'm programming for Iphone, using objective C.

Using Mysql WHERE IN clause in codeigniter

codeigniter codeigniter-2

I have the following mysql query. Could you please tell me how to write the same query in Codeigniter's way ?