title: org.hibernate.MappingException:No Dialect mapping for JDBC type: 1111
body: <p>I am using postgres v8.3 which has a columntype as XML. DDL looks like this:</p>
  
  <pre><code>CREATE TABLE contact (
  "ID" INTEGER NOT NULL , 
  "NAME" VARCHAR NOT NULL,
  "Details" XML , ......
  </code></pre>
  
  <p>In the mapping hbm.xml file I map it like this:</p>
  
  <pre><code>&lt;key-property name="Details" type="java.lang.String" &gt;
  &lt;column name="Details" /&gt;
  &lt;/key-property&gt;
  </code></pre>
  
  <p>and I guess this is the reason of error : 
  No Dialect mapping for JDBC type: 1111
  when I run a select query using :</p>
  
  <pre><code>List&lt;?&gt; contactList= session.createSQLQuery("select * from contact where id=" + val.getId() + " and name= '" + val.getName + "'").list();
  </code></pre>
  
  <p>but what is the other way I can map "XML" type to a java datatype ?</p>