Hi
I am using Hibernate version: 3.2 and Name and
version of the database: MySQL 5.0.45win32

my code is as follows:
public List retrieveValues(String sqlData, String tableName) {

Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();

String queryString = "Select "+ sqlData +" FROM " + tableName + ";";

List result = session.createSQLQuery(queryString).list();

session.getTransaction().commit();

HibernateUtil.getSessionFactory().close();

return result;
}


This code written in OTAServerManager.java and i am calling method retrieveValues("*", "databasename") then i am getting following error.
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1

What should i do for this?

Thanks in advance, I am new for Hibernate this is my first programme.

Hi,

I had the same problem and it was caused by the fact that I queried a column of type 'text'. Apparently hibernate cannot map this JDBC type to a java type.

Try it without the text column and you will see that it works.

Bas

workaround: map the columns explicit with addScalar.
see also:
http://opensource.atlassian.com/project ... tion_28333

you can try by writing this code in hibernate.cfn.xml file it may resolve ur error "No Dialect mapping for JDBC type: -1"

<property name="dialect">org.hibernate.dialect.MySQLDialect</property>