Hibernate version: hibernate-3.0beta1 with hibernate-annotations-3.0alpha1

I found that I was able to specify the data type for a column using the following EJB 3.0 annotation.

@Column(columnDefinition="TEXT")

This works great. However, I'm wondering if there is a way to specify the type in a DBMS-independent fashion.

For example, if I use the annotation above, it will work with MySQL and with Microsoft SQL server because they have a TEXT data type. However, in Derby, the equivalent data type appears to be "LONG VARCHAR."

Maybe I can use the Column length property and just set it to a large value (i.e. something greater than 255)...

Post it as a new feature in JIRA please.

please post the JIRA url here - this is something I would like to vote for!!