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.

Daniel · Accepted Answer · 2011-01-10 06:18:26Z

2

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?

answered Jan 10, 2011 at 6:18

Daniel

28.2k20 gold badges93 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

digiarnie Over a year ago

I'm planning on using it to dynamically create tables in my app. So the user may say I want to create a table with a column named "foo" that will hold strings.

Daniel Over a year ago

Just infer the type yourself... you know better how to handle your custom types yourself, and don't need a Hibernate function.

digiarnie Over a year ago

Excuse my ignorance but infer how? How would I easily determine what the correct data type is for a specific database? The user could be using any database they wish.

Daniel Over a year ago

So the user can use any mapping he wants or do you provide the mapping files? In this case use the function I mentioned for basic data types and create the @ManyToOnes for yourself. Maybe you want to use Hibernates schema update function to create the userdefined tables?

digiarnie Over a year ago

There are no mapping files in regards to my problem. The user uses a UI and specifies the name of the table and the types of the columns. They will then hit OK and magically the table will be created with the appropriate columns and data types.

|

Collectives™ on Stack Overflow

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

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related