title: No Dialect mapping for JDBC type: 1111 (Native Query)
body: <p>I encountered an error as per title at <code>query.getResultList()</code> ; on <code>JsonbHibernateExampleApplicationTests</code> class file when running native query to return a json object.</p>
  
  <p>It has no issue returning of non <code>json</code> type of column.</p>
  
  <p>Kindly assist and do let me know if there is a need for more information.</p>
  
  <p>Below is the source code</p>
  
  <pre><code>public class JsonbHibernateExampleApplicationTests {
  
      @Autowired
      private PersonRepository repository;
  
      @Autowired
      private ApplicationContext appContext;
  
      @Test
      public void contextLoads() {
          EntityManagerFactory entityManagerFactory = (EntityManagerFactory) appContext
                  .getBean("entityManagerFactory");
  
          EntityManager entityManager = entityManagerFactory.createEntityManager();
  
          String sql = "select additional_data  from person";
  
          javax.persistence.Query query = entityManager.createNativeQuery(sql);
          query.getResultList();
          //List&lt;JsonDataUserType&gt; list = (List&lt;JsonDataUserType&gt;) query.getResultList();
          /* System.out.println("list:" + list);
          for (JsonDataUserType json: list)
          {
              System.out.println("json:" + json);
          }*/
          //List&lt;Object[]&gt; objects = query.getResultList();
          //System.out.println("result:"+ objects);
  
      }
  
  }
  </code></pre>
  
  <p>I specified the additional_data column as customized json type in the entity</p>
  
  <pre><code>@Type(type = "JsonDataUserType")
  private Map&lt;String, String&gt; additionalData;
  </code></pre>
  
  <p>I can't paste all the source code here and you can check out the full source code at <a href="http://vojtechruzicka.com/postgresqls-jsonb-type-mapping-using-hibernate/" rel="nofollow noreferrer">http://vojtechruzicka.com/postgresqls-jsonb-type-mapping-using-hibernate/</a></p>
  
  <p>I just modified the original source as URL above to run a native SQL query.</p>
  
  <p>Many Thanks,</p>