I upgraded to Hibernate 3.1.2 and now the hbm2dll output is not formatted as what H2 did before. the table definition is on one long line instead of something like this in H2:

create table ORGS (
ORG_ID bigint not null auto_increment,
NAME varchar(255) not null,
DESCR varchar(255),
ISDELETED bit,
CREATE_TIME datetime,
MODIFY_TIME datetime,
primary key (ORG_ID)
);


I am using Hibernate Tool 3.1 beta 4, running Ant task.
any reason why ?

thanks
lixin

build.xml
------------
<?xml version="1.0"?>

<project name="Canal" default="schemaexport" basedir=".">

<property name="build.dir" value="../../classes"/>
<property name="resource.dir" value="../resources"/>

<path id="libs">
<fileset dir="../../lib">
<include name="**/*.jar"/>
<include name="**/*.properties"/>
</fileset>
</path>

<target name="schemaexport">
<taskdef name="schemaexport"
classname="org.hibernate.tool.hbm2ddl.SchemaExportTask">
<classpath refid="libs"/>
<classpath path="${build.dir}"/>
</taskdef>

<schemaexport
properties="${resource.dir}/hibernate.properties"
quiet="no"
text="yes"
drop="no"
delimiter=";"
output="db-schema.sql">
<fileset dir="../">
<include name="**/*.hbm.xml"/>
</fileset>
</schemaexport>


</target>

</project>

format="true"

i tried. but got error message saying that <schemaexport> does not support the attribute <format>

something is wrong.

this one finally works after working the whole morning !

hibernate.properties
===============

hibernate.query.substitutions yes 'Y', no 'N'


## MySQL

hibernate.dialect org.hibernate.dialect.MySQLDialect
#hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect
#hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect
hibernate.connection.driver_class com.mysql.jdbc.Driver
hibernate.connection.url jdbc:mysql://localhost/canalDB
hibernate.connection.username root
hibernate.connection.password root


build.xml
=======
<?xml version="1.0"?>

<project name="Canal" default="schemaexport" basedir=".">

<property name="build.dir" value="../../classes"/>
<property name="resource.dir" value="../resources"/>

<path id="classpath">
<fileset dir="C:/Canal/eclipse/workspace/Canal/WEB-INF/lib">
<include name="**/*.jar"/>
</fileset>
<fileset dir="C:/Canal/eclipse/plugins/org.hibernate.eclipse_3.1.0.beta4">
<include name="**/*.jar"/>
</fileset>
</path>

<target name="schemaexport">
<taskdef name="hibernatetool"
classname="org.hibernate.tool.ant.HibernateToolTask"
classpathref="classpath"/>

<hibernatetool destdir=".">
<classpath>
<path refid="classpath"/>
<pathelement path="${build.dir}"/>
</classpath>
<configuration propertyfile="${resource.dir}/hibernate.properties">
<fileset dir="../">
<include name="**/*.hbm.xml"/>
</fileset>
</configuration>
<hbm2ddl
drop="false"
create="false"
delimiter=";"
outputfilename="db-schema.sql"
format="true">
</hbm2ddl>

</hibernatetool>

</target>

</project>

I were just about suggesting you to try and use hbm2ddl from tools..