Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

No Dialect mapping for JDBC type: -101

 
Partha Rai
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
0 down vote favorite


I am firing following query

Transaction tx3 = session.beginTransaction();
Query query3 = session.createSQLQuery("SELECT SYSTIMESTAMP FROM DUAL");
Object x = (Object)query3.uniqueResult(); //line 3
System.out.println(x);
tx3.commit();

while executing line 3 i am getting following error

exceptiontsorg.hibernate.MappingException: No Dialect mapping for JDBC type: -101

I am getting same exception with the following query also

/* String dateQuery = "select to_timestamp_tz(to_char(TO_DATE('19700101000000','YYYYMMDDHH24MISS') ,'mm/ddyyyy hh24:mi:ss'),'mm/ddyyyy hh24:mi:ss TZH:TZM')"+
"at time zone 'america/los_angeles' from dual";
Query dateQueryTZ = session.createSQLQuery(dateQuery);*/

Can any one tell me how to fix this and get the timestamp value. Please tell me if any alternative are there for the above query.

Thanks in advance Partha
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the Ranch!

Can you post the contents of your persistence.xml file? Perhaps your Hibernate dialect is not set correctly for Oracle database.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic