{"id":1563,"date":"2017-09-10T09:44:46","date_gmt":"2017-09-10T13:44:46","guid":{"rendered":"http:\/\/shirishranjit.com\/blog1\/?page_id=1563"},"modified":"2017-09-10T09:47:10","modified_gmt":"2017-09-10T13:47:10","slug":"jpa-persistence-error-could-not-extract-resultset-or-error-relation-does-not-exist","status":"publish","type":"page","link":"https:\/\/shirishranjit.com\/blog1\/java-stuff\/java-persistence-entitymanager-persist-v-s-merge\/jpa-persistence-error-could-not-extract-resultset-or-error-relation-does-not-exist","title":{"rendered":"JPA Persistence Error &#8211; Could Not Extract ResultSet or ERROR: relation does not exist"},"content":{"rendered":"<p>If you are getting error as described below, check following<\/p>\n<ul>\n<ol>\n<li>Schema is defined in your @Table Definition<\/li>\n<li>Check your relationship mapping in your JPA Model. Easy way to check is have a bare minimum mapping and run Find All to test your mapping<\/li>\n<\/ol>\n<\/ul>\n<h2> Types of error you my encounter are:<\/h2>\n<p><code><\/p>\n<p>javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet<\/p>\n<p>Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet<\/p>\n<p>Caused by: org.postgresql.util.PSQLException: ERROR: relation \"XXXXXXXXXXX\" does not exist<br \/>\n<\/code><\/p>\n<div class=\"twttr_buttons\"><div class=\"twttr_twitter\">\n\t\t\t\t\t<a href=\"http:\/\/twitter.com\/share?text=JPA+Persistence+Error+-+Could+Not+Extract+ResultSet+or+ERROR%3A+relation+does+not+exist\" class=\"twitter-share-button\" data-via=\"\" data-hashtags=\"\"  data-size=\"default\" data-url=\"https:\/\/shirishranjit.com\/blog1\/java-stuff\/java-persistence-entitymanager-persist-v-s-merge\/jpa-persistence-error-could-not-extract-resultset-or-error-relation-does-not-exist\"  data-related=\"\" target=\"_blank\">Tweet<\/a>\n\t\t\t\t<\/div><div class=\"twttr_followme\">\n\t\t\t\t\t\t<a href=\"https:\/\/twitter.com\/shiranjit\" class=\"twitter-follow-button\" data-size=\"default\"  data-show-screen-name=\"false\"  target=\"_blank\">Follow me<\/a>\n\t\t\t\t\t<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>If you are getting error as described below, check following Schema is defined in your @Table Definition Check your relationship mapping in your JPA Model. Easy way to check is have a bare minimum mapping and run Find All to &hellip; <a href=\"https:\/\/shirishranjit.com\/blog1\/java-stuff\/java-persistence-entitymanager-persist-v-s-merge\/jpa-persistence-error-could-not-extract-resultset-or-error-relation-does-not-exist\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"parent":901,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1563","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/pages\/1563"}],"collection":[{"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/comments?post=1563"}],"version-history":[{"count":3,"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/pages\/1563\/revisions"}],"predecessor-version":[{"id":1566,"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/pages\/1563\/revisions\/1566"}],"up":[{"embeddable":true,"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/pages\/901"}],"wp:attachment":[{"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/media?parent=1563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}