{"id":124835,"date":"2024-05-21T20:54:24","date_gmt":"2024-05-21T19:54:24","guid":{"rendered":"https:\/\/www.baeldung.com\/spring-jpa-converter-exception"},"modified":"2024-05-21T20:54:24","modified_gmt":"2024-05-21T19:54:24","slug":"solving-spring-data-jpa-converternotfoundexception-no-converter-found","status":"publish","type":"post","link":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/2024\/05\/21\/solving-spring-data-jpa-converternotfoundexception-no-converter-found\/","title":{"rendered":"Solving Spring Data JPA ConverterNotFoundException: No converter found"},"content":{"rendered":"

\"\"<\/p>\n

1. Overview<\/h2>\n
<\/div>\n

When using Spring Data JPA<\/a>, we often leverage derived and custom queries<\/a> that return the result in our preferred formats. A typical example is the DTO projection<\/a>, which offers a great way to select only some specific columns and reduce the overhead of selecting unnecessary data.<\/p>\n

However, the DTO projection isn’t always easy and may lead to ConverterNotFoundException<\/em>\u00a0when it’s not implemented properly. So, in this short tutorial, we’ll elucidate how to avoid the ConverterNotFoundException<\/em> exception when working with Spring Data JPA.<\/p>\n

2. Understanding the Exception in Practice<\/h2>\n
<\/div>\n

Before jumping to the solution, let\u2019s try to understand what the exception and its stack trace mean through a practical example.<\/p>\n

To keep things simple, we’ll use the H2 database<\/a>. Let\u2019s start by adding its dependency<\/a> to the pom.xml<\/em> file:<\/p>\n

<dependency>\r\n    <groupId>com.h2database<\/groupId>\r\n    <artifactId>h2<\/artifactId>\r\n    <version>2.2.224<\/version>\r\n<\/dependency><\/code><\/pre>\n
2.1. H2 Configuration<\/h3>\n
<\/div>\n
Spring Boot provides intrinsic support for the H2 embeddable database. By design, it configures the application to connect to H2 using the username sa<\/em> and an empty password<\/strong>.<\/p>\n
First, let’s add the database connection credentials to the application.properties<\/em> file:<\/p>\n
spring.datasource.url=jdbc:h2:mem:mydb\r\nspring.datasource.driverClassName=org.h2.Driver\r\nspring.datasource.username=sa\r\nspring.datasource.password=<\/code><\/pre>\n
That’s all we need to set up the H2 configuration with Spring Boot.<\/p>\n
2.2. Entity Class<\/h3>\n
<\/div>\n
Now, let’s define a JPA entity<\/a>. For instance, we’ll consider the Employee<\/em> class:<\/p>\n
@Entity\r\npublic class Employee {\r\n    @Id\r\n    private int id;\r\n    @Column\r\n    private String firstName;\r\n    @Column\r\n    private String lastName;\r\n    @Column\r\n    private double salary;\r\n    \/\/ standards getters and setters\r\n}<\/code><\/pre>\n
In this example, we define an employee by their identifier, first name, last name, and salary.<\/p>\n
Typically, we use the @Entity<\/em> annotation to denote that the Employee<\/em> class is a JPA entity. Moreover, @Id<\/em> marks the field that represents the primary key. Furthermore, we use @Column <\/em>to bind each entity field to its respective table column.<\/p>\n
2.3. JPA Repository<\/h3>\n
<\/div>\n
Next, we’re going to create a Spring Data JPA repository<\/a> to handle the logic of storing and retrieving employees:<\/p>\n
@Repository\r\npublic interface EmployeeRepository extends JpaRepository<Employee, Integer> {\r\n}<\/code><\/pre>\n
Here, we’ll assume that we need to display the full name of an employee. So, we’ll rely on DTO projection to select only firstName<\/em> and lastName<\/em>.<\/p>\n
Since the Employee<\/em> class holds additional data, let’s create a new class named EmployeeFullName<\/em> that contains only the first and the last names:<\/p>\n
public class EmployeeFullName {\r\n    private String firstName;\r\n    private String lastName;\r\n    \/\/ standards getters and setters\r\n    public String fullName() {\r\n        return getFirstName()\r\n          .concat(" ")\r\n          .concat(getLastName());\r\n    }\r\n}<\/code><\/pre>\n
Notably, we create a custom method fullName()<\/em> to display the employee’s full name<\/strong>. Now, let’s add a derived query that returns the full name of an employee to EmployeeRepository<\/em>:<\/p>\n
EmployeeFullName findEmployeeFullNameById(int id);<\/code><\/pre>\n
Lastly, let’s create a test to make sure that everything works as expected:<\/p>\n
@Test\r\nvoid givenEmployee_whenGettingFullName_thenThrowException() {\r\n    Employee emp = new Employee();\r\n    emp.setId(1);\r\n    emp.setFirstName("Adrien");\r\n    emp.setLastName("Juguet");\r\n    emp.setSalary(4000);\r\n    employeeRepository.save(emp);\r\n    assertThatThrownBy(() -> employeeRepository\r\n      .findEmployeeFullNameById(1))\r\n      .isInstanceOfAny(ConverterNotFoundException.class)\r\n      .hasMessageContaining("No converter found capable of converting from type" \r\n        + "[com.baeldung.spring.data.noconverterfound.models.Employe");\r\n}<\/code><\/pre>\n
As shown above, the test fails with ConverterNotFoundException<\/em>.<\/p>\n
The root cause of the exception is that JpaRepository<\/em> expects that its derived queries return an instance of the Employee<\/em> entity class. Since the method returns an EmployeeFullName<\/em> object, Spring Data JPA fails to find a converter suitable to convert the expected Employee<\/em> object to the new EmployeeFullName<\/em> object<\/strong>.<\/p>\n
3. Solutions<\/h2>\n
<\/div>\n
When using a class to implement the DTO projection, Spring Data JPA uses, by default, the constructor to determine the fields that are supposed to be retrieved. So, the basic solution here is to add a parameterized constructor to the EmployeeFullName<\/em> class<\/strong>:<\/p>\n
public EmployeeFullName(String firstName, String lastName) {\r\n    this.firstName = firstName;\r\n    this.lastName = lastName;\r\n}<\/code><\/pre>\n
That way, we tell Spring Data JPA to select only firstName<\/em> and lastName<\/em>. Now, let’s add another test to test the solution:<\/p>\n
@Test\r\nvoid givenEmployee_whenGettingFullNameUsingClass_thenReturnFullName() {\r\n    Employee emp = new Employee();\r\n    emp.setId(2);\r\n    emp.setFirstName("Azhrioun");\r\n    emp.setLastName("Abderrahim");\r\n    emp.setSalary(3500);\r\n    employeeRepository.save(emp);\r\n    assertThat(employeeRepository.findEmployeeFullNameById(2).fullName())\r\n      .isEqualTo("Azhrioun Abderrahim");\r\n}<\/code><\/pre>\n
Unsurprisingly, the test passes with success.<\/p>\n
Another solution would be to use the interface-based projection<\/strong>. That way, we don’t have to worry about the constructor. So, instead of using a class, we can use an interface that exposes getters for the fields to be read<\/strong>:<\/p>\n
public interface IEmployeeFullName {\r\n    String getFirstName();\r\n    String getLastName();\r\n    default String fullName() {\r\n        return getFirstName().concat(" ")\r\n          .concat(getLastName());\r\n    }\r\n}<\/code><\/pre>\n
Here, we used a default method<\/a> to display the full name. Next, let’s create another derived query that returns an instance of type IEmployeeFullName<\/em>:<\/p>\n
IEmployeeFullName findIEmployeeFullNameById(int id);<\/code><\/pre>\n
Finally, let’s add another test to verify this second solution:<\/p>\n
@Test\r\nvoid givenEmployee_whenGettingFullNameUsingInterface_thenReturnFullName() {\r\n    Employee emp = new Employee();\r\n    emp.setId(3);\r\n    emp.setFirstName("Eva");\r\n    emp.setLastName("Smith");\r\n    emp.setSalary(6500);\r\n    employeeRepository.save(emp);\r\n    assertThat(employeeRepository.findIEmployeeFullNameById(3).fullName())\r\n      .isEqualTo("Eva Smith");\r\n}<\/code><\/pre>\n
As expected, the interface-based solution works.<\/p>\n
4. Conclusion<\/h2>\n
<\/div>\n
In this article, we learned what causes Spring Data JPA to fail with ConverterNotFoundException<\/em>. Along the way, we saw how to reproduce and fix the exception in practice.<\/p>\n
As always, the full source code of the examples is available over on GitHub<\/a>.<\/p>\n
\"\"<\/p>\n
<\/a> <\/a> <\/a> <\/a> <\/a> <\/a> <\/a> <\/div>\n\n
Commercials Cooperation Advertisements:<\/b><\/h2>\r\n

(1) IT Teacher IT Freelance
 <\/p>\r\nIT\u96fb\u8166\u88dc\u7fd2<\/a>
\u7acb\u523b\u8a3b\u518a\u53ca\u5831\u540d\u96fb\u8166\u88dc\u7fd2\u8ab2\u7a0b\u5427! <\/a>
\r\n\r\n\u7535\u5b50\u8ba1\u7b97\u673a -\u6559\u80b2 -IT \u96fb\u8166\u73ed\u201d ( IT\u96fb\u8166\u88dc\u7fd2 ) \u63d0\u4f9b\u4e00\u500b\u65b9\u4fbf\u7684\u7535\u5b50\u8ba1\u7b97\u673a \u6559\u80b2\u5e73\u53f0, \u70ba\u5927\u5bb6\u914d\u5c0d\u4fe1\u606f\u6280\u672f, \u96fb\u8166 \u8001\u5e2b, IT freelance \u548c programming expert. \u8b93\u5927\u5bb6\u65b9\u4fbf\u5730\u5c31\u80fd\u627e\u5230\u5408\u9069\u7684\u96fb\u8166\u88dc\u7fd2, \u96fb\u8166\u73ed, \u5bb6\u6559, \u79c1\u4eba\u8001\u5e2b.  
\r\n\r\nWe are a education and information platform which you can find a IT private tutorial teacher or freelance. 
\r\n\r\nAlso we provide different information about information technology, Computer, programming, mobile, Android, apple, game, movie, anime, animation\u2026 \r\n<\/p>\n

(2) ITSec
 <\/p>https:\/\/itsec.vip\/\r\nSecure<\/a> \r\n

 \r\n
www.ITSec.vip<\/a> 
 
 \r\n
www.Sraa.com.hk<\/a> 
 
 \r\n
www.ITSec.hk<\/a> 
 
 \r\n
www.Penetrationtest.hk<\/a> 
 
 \r\n
www.ITSeceu.uk<\/a> 
 
 \r\nSecure Your Computers from Cyber Threats and mitigate risks with professional services to defend Hackers. 

\r\nITSec provide IT Security and Compliance Services, including IT Compliance Services, Risk Assessment, IT Audit, Security Assessment and Audit, ISO 27001 Consulting and Certification, GDPR Compliance Services, Privacy Impact Assessment (PIA), Penetration test, Ethical Hacking, Vulnerabilities scan, IT Consulting, Data Privacy Consulting, Data Protection Services, Information Security Consulting, Cyber Security Consulting, Network Security Audit, Security Awareness Training. \r\n

Contact us right away. 

Email (Prefer using email to contact us): 
SalesExecutive@ITSec.vip<\/p>","protected":false},"excerpt":{"rendered":"
\"\"<\/p>\n
Learn how to resolve the Spring Data JPA ConverterNotFoundException: No converter found.<\/p>\n
<\/a>\u00a0<\/a>\u00a0<\/a>\u00a0<\/a>\u00a0<\/a>\u00a0<\/a>\u00a0<\/a>\u00a0<\/div>\n","protected":false},"author":293,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[22],"tags":[61,122,127,129,124,128,125,132,131,133,126,130,123,66,94,88,97,56,64,65,60,112,40,75,95,104,33,120,30419,105,101,98,115,30,29,41,86,70,69,68,72,71,26,118,108,87,46,55,48,52,54,51,50,83,62,58,57,30418,109,35,59,63,85,79,82,96,80,27,81,114,44,42,43,45,38,39,110,117,100,111,116,73,89,90,92,91,93,84,78,37,102,34,36,77,67,74,99,113,30420,119,28,121,32,47,49,53,103,31,76],"class_list":["post-124835","post","type-post","status-publish","format-standard","hentry","category-mobile","tag-airpods","tag-anime","tag-anime-characters","tag-anime-cosplay","tag-anime-edits","tag-anime-merchandise","tag-anime-movies","tag-anime-news","tag-anime-recommendations","tag-anime-reviews","tag-anime-series","tag-anime-streaming","tag-animes","tag-app-store","tag-app-store-samsung","tag-appgallery","tag-appgallery-oneplus","tag-apple","tag-apple-music","tag-apple-tv","tag-apple-watch","tag-bbc-sport","tag-best-mobile-games","tag-bixby","tag-bixby-xiaomi","tag-champions-league","tag-cyberpunk","tag-cyberpunk-2077","tag-exception","tag-fantasy-football","tag-fifa","tag-football","tag-formula-1","tag-fortnite","tag-free-fire","tag-free-mobile-games","tag-freebuds-pro","tag-galaxy-a52","tag-galaxy-note-20","tag-galaxy-s21","tag-galaxy-watch-4","tag-galaxy-z-fold-3","tag-game","tag-games","tag-golf","tag-harmonyos","tag-how-to-backup-iphone","tag-how-to-factory-reset-iphone","tag-how-to-reset-iphone","tag-how-to-restore-iphone","tag-how-to-unlock-iphone","tag-how-to-unlock-iphone-5","tag-how-to-unlock-iphone-6","tag-huawei","tag-ios","tag-ipad","tag-iphone","tag-jpa","tag-live-soccer","tag-lol","tag-macbook","tag-macos","tag-mate-40-pro","tag-mi-11-lite","tag-mi-home-security-camera-basic-1080p","tag-mi-home-security-camera-basic-1080p-huawei","tag-mi-smart-band-6","tag-minecraft","tag-miui","tag-mlb-scores","tag-mobile-game-design","tag-mobile-game-development","tag-mobile-game-marketing","tag-mobile-game-monetization","tag-mobile-games","tag-mobile-gaming","tag-nba-scores","tag-nba-standings","tag-nfl","tag-nfl-scores","tag-nhl-scores","tag-one-ui","tag-oneplus","tag-oneplus-9-pro","tag-oneplus-buds-pro","tag-oneplus-nord-ce-5g","tag-oxygenos","tag-p40-pro-plus","tag-poco-x3-pro","tag-pokemon","tag-premier-league","tag-pubg","tag-pubg-mobile","tag-redmi-note-10-pro","tag-samsung","tag-samsung-pay","tag-soccer","tag-sports","tag-spring-data-jpa","tag-steam","tag-steeam","tag-top-10-anime","tag-valorant","tag-when-do-the-iphone-7-come-out","tag-when-does-the-iphone-7-come-out","tag-when-is-the-iphone-7-coming-out","tag-world-cup","tag-xbox-series-x","tag-xiaomi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/posts\/124835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/users\/293"}],"replies":[{"embeddable":true,"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/comments?post=124835"}],"version-history":[{"count":0,"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/posts\/124835\/revisions"}],"wp:attachment":[{"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/media?parent=124835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/categories?post=124835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/tags?post=124835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}