title: No Dialect mapping for JDBC type: 2003
body: <p>Though there are some question exists with this title , but my query does not solve from those thread.</p>
  
  <p>I am executing recursive (using with clause) query through hibernate in postgres, query's result contains path of search also</p>
  
  <p>ex: one row of query result</p>
  
  <pre><code>5811;"axyz_3_3";"ABC";5782;5811;5797;4;"**{acl_3_3,acl3_4,acl3,acl_3_3}**";t;t
  </code></pre>
  
  <p>Does hibernate has any mapping type for <code>"{acl_3_3,acl3_4,acl3,acl_3_3}"</code> other than String,
  something similar to <code>CHARACTER_ARRAY</code> or <code>CHAR_ARRAY</code>.</p>
  
  <p>Below is the sample of the query's output</p>
  
  <pre><code>id   |name|discri|pId|asscID|immeId|depth|path|cycle|canDelete
  5797;"abc3";"abc";5782;5811;5788;7;"{abc_3_3,abc3_4,abc3,abc4}";t;f
  5797;"abc3";"abc";5782;5786;5813;6;"{abc1,abc2,abc3,abc3}";t;f
  5799;"abc4";"abc";5782;5811;5786;6;"{abc_3_3,abc3_4,abc4}";t;f
  5788;"abc2";"abc";5782;5811;5786;6;"{abc_3_3,abc3_4,abc2}";f;f
  5786;"abc1";"abc";5782;5786;5799;5;"{abc1,abc2,abc3,abc1}";t;f
  5797;"abc3";"abc";5782;5786;5813;5;"{abc1,abc2,abc3,abc3}";t;f
  5813;"abc3_4";"abc";5782;5786;5811;5;"{abc1,abc2,abc3_4}";f;f
  5786;"abc1";"abc";5782;5811;5799;5;"{abc_3_3,abc4,abc1}";f;f
  5813;"abc3_4";"abc";5782;5811;5797;4;"{abc3_4,abc3,abc3_4}";t;f
  5811;"abc_3_3";"abc";5782;5811;5797;4;"{abc_3_3,abc3,abc_3_3}";t;t
  5799;"abc4";"abc";5782;5811;5797;4;"{abc3,abc4}";f;f
  </code></pre>
  
  <p>Hibernate is throwing below exception</p>
  
  <pre><code>Caused by: com.vik.prod.service.UnidentifiedException: No Dialect mapping for JDBC type: 2003
  at com.vik.prod.service.ServiceExecutorUtils.execute(ServiceExecutorUtils.java:93)
  at com.vik.prod.service.ServerServiceExecutor.execute(ServerServiceExecutor.java:76)
  at com.vik.prod.service.ClientDelegate.execute(ClientDelegate.java:197)
  ... 33 more
  </code></pre>
  
  <p>Caused by: org.hibernate.MappingException: No Dialect mapping for JDBC type: 2003</p>