Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Hi!
I have a table JOB, and I modified the definition of the column X from integer
to long. The HBM2DDL is set to UPDATE; I'm using MySQL; when I start JBoss the table is not updated.
I saw in the source code (in the Table class) that the "alter table" statement is created only for columns that don't already exist in the table.
So, is it possible in some way to update the type of an existing column in the table???
Thanks.

Why you dont grab the mapping for that particular table and synchronize it again?

I want to do this very simple; the MySQL statement would be "alter table JOB change X X longint"...can Hibernate do this?

The scenario is as follows:
I have lot of data in the JOB table, where the X column has the type "int".
Due to the new requirements, in the Hibernate mapping file I have to update the column type to "long".
The HBM2DDL is set to UPDATE.
I redeployed the application, but when I started JBoss the column X was not altered to "long".
Any ideas?