title: No Dialect mapping for JDBC type: -102
body: <p>i have a problem. Some sql in my program could be written by the user. So I don't know which table or which columns are in this sql. Therefore i want to detect which column names are in the sql. But if a date is in the sql i get the No Dialect mapping for JDBC type: -102 error.
  How could i handle that? I am using hibernate 3.6 or 4.1.3 with java. My database is an oracle database. The dialect is org.hibernate.dialect.Oracle10gDialect.</p>
  
  <p>I really don't know what is in the sql.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>SQLQuery q=session.createSQLQuery("SELECT * FROM tbl WHERE id = 2"); 
  q.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE); 
  List&lt;Map&lt;String,Object&gt;&gt; aliasToValueMapList=q.list();
  for(Map&lt;String,Object&gt; map : aliasToValueMapList){
      System.out.println(map.keySet());
      break;
  }
  </code></pre>
  
  <p>I hope anyone knows a solution for this problem. </p>
  
  <p>Greetz</p>