title: H2 Database simulate Oracle XMLtype - Hibernate
body: <p>I have the following column in one of my hibernate entities:</p>
  
  <pre><code>    @Lob
      @Basic(fetch=FetchType.LAZY)
      @ColumnTransformer(read = "to_clob(xmlContent)", write = "?")
      @Column(name="XMLCONTENT", updatable = false, columnDefinition = "XMLType")
      private String xmlContent;
  </code></pre>
  
  <p>However when I have <code>hibernate.hbm2ddl.auto = create</code> on hibernate it fails to create the particular table giving me the following error:</p>
  
  <p><code>Unknown data type: "XMLTYPE"; SQL statement:</code></p>
  
  <p>So basically I can't include this table/entity at all in tests with the H2 database. I need to have an XE at least installed.</p>
  
  <p>Is there any workaround/solution to this, possibly another in memory database supports this?</p>