Using Hibernate to find the specific database type for a given Java type

Question

Is there a class that I could use in Hibernate so that I could pass in a class and it would return the appropriate database type name?

For example,

String type = HibernateTypeGod.getTypeName(String.class);

Hibernate would determine the dialect I specified and return me VARCHAR2 in the case of Oracle.

Answer 1

It's not that easy. All the mapping stuff is in the classes Configuration, Table, Column and Dialect, so you will need some kind of valid config to query this from Hibernate. But you can for example use:

String s = myDialect.getTypeName(sqlType,length,precision,scale);

Of course you need to find the dialect and the sqlType, but this isn't fixed in Hibernate on a class basis, but can be configured per column anyway, so what is the reason to ask by Class and not by column name?