title: Querying JSON array from postgresql in hibernate throws No Dialect mapping for JDBC type: 1111
body: <p>I'm using PostgreSQL database and having a JSON type column in a table. The JSON value which is stored there in the column is having an iterative section which i do need to be retrieved from the database as an list.</p>
  <pre><code>@Query(value = &quot;SELECT json_array_elements(table_column_name-&gt;'BBList') FROM table_name&quot;, nativeQuery = true)
  public List &lt;Object[]&gt; findJsonList();
  </code></pre>
  <p>And the query returns this error:</p>
  <blockquote>
  <p>org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111</p>
  </blockquote>
  <p>What would be the correct return type of this?</p>
  <p>(<a href="https://i.stack.imgur.com/raLaR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/raLaR.png" alt="see the JSON image" /></a></p>