Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization 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
Pie
Posts: 3751
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