title: org.hibernate.MappingException: No Dialect mapping for JDBC type: 3
body: <p>I want to return the rows on like criteria i have 5 records at this criteria in the database but this code does not return , an exception is throws <strong>org.hibernate.MappingException: No Dialect mapping for JDBC type: 3</strong></p>
  
  <pre><code> Query selectTxnList = session.createSQLQuery("select * from TxnList where txnRecNo in (select txnRecNo from TxnAdditionalInsured where clientName like :clientName)");
  
   selectTxnList.setParameter("clientName", "%" + istHelper.getAdditionalInsured() + "%");
  
   List list = selectTxnList.list();
  </code></pre>