Hello I am trying to progromatically create tables using the API.

So far I have managed to create tables OK. However I cannot manage to create table where some of the columns have length e.g varchar(25)...

I am using:

Configuration configForMysql = getConfigForMysql5();
Mappings mappings = configForMysql.createMappings();
Table table = mappings.addTable( null, null, "name", null, false );
Column column = new Column( "id" );
SimpleValue simpleValue = new SimpleValue( table );
simpleValue.setTypeName( "int" );
Properties properties = new Properties();
properties.setProperty( "not-null", "true" );
simpleValue.setTypeParameters( properties );
column.setValue( simpleValue );

// column.setPrecision( 4 );
// column.setLength( 5 );
// column.setScale( 5 );
table.addColumn( column );

Connection connection = DriverManager.getConnection( "jdbc:mysql://localhost:3306/hbm2ddl", "username", "password" );
SchemaExport export = new SchemaExport( configForMysql, connection );
export.setOutputFile( "C:/make.sql" );
export.execute( true, true, false, false );

Well, first I will ask the obvious. Why are you creating tables yourself? Are you using the mapping files and the hibernate configuration file? If so, there is a property you can set in the hibernate mapping file that looks like this:



Just make sure it is set to update and hibernate will create it all for you. In addition, when defining your properties in your mapping files, be sure to set the "length" property of your mapped object's property.

Now, if you really, really want to do this manually (crazy in my book) then you can set the Column.setLength(n) property in your example code in this post.

If this helps, don't forget to rate! :)