Hi!

I am just picking up Hibernate, and bumped into a problem that could not solve on my own.

I am running a long sql query, I suppose the query runs OK, but I receive the following message:
No Dialect mapping for JDBC type: 7

I searched for JDBC type 7, but could not find anything.


Hibernate version:
Hibernate 3

Code between sessionFactory.openSession() and session.close():
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
List full = session.createSQLQuery(SqlText).list();
session.close();

Full stack trace of any exception that occurs:
does not throw any

Name and version of the database you are using:

INFO: RDBMS: PostgreSQL, version: 7.4.13
INFO: JDBC driver: PostgreSQL Native Driver, version: PostgreSQL 7.4.5 JDBC3 with SSL (build 216)
INFO: Using dialect: org.hibernate.dialect.PostgreSQLDialect

Debug level Hibernate log excerpt:

add a type mapping to the dialect or list the types explicitly with .addScalar

.addScalar does not work, since the query is generated dinamically with changing number of columns columns.

adding a type mapping would work, but I don't know what type is jdbc type 7

From java.sql.Types:

public final static int REAL = 7;