File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes No Dialect mapping for JDBC type: -101 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "No Dialect mapping for JDBC type: -101" Watch "No Dialect mapping for JDBC type: -101" New topic

No Dialect mapping for JDBC type: -101

Partha Rai

Joined: Apr 08, 2014
Posts: 1
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

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

Joined: Aug 22, 2010
Posts: 3733

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.
I agree. Here's the link:
subject: No Dialect mapping for JDBC type: -101
It's not a secret anymore!