@Test
public void generateDdl(){
String[] locations = {
"classpath*:appContext-hibernate.xml"
};
ApplicationContext ctx = new ClassPathXmlApplicationContext(locations);
System.out.println(ctx.getBean("&sessionFactory"));
AnnotationSessionFactoryBean sf = (AnnotationSessionFactoryBean) ctx.getBean("&sessionFactory");
System.out.println(ctx);
SchemaExport dbExport = new SchemaExport(sf.getConfiguration());
dbExport.setFormat(true);
dbExport.setOutputFile("c:\\test.sql");
dbExport.create(true, false);
}
appContext-hibernate.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans default-lazy-init="true"
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd">
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<!--<property name="dataSource" ref="dataSource"/>-->
<property name="packagesToScan">
<list>
<value>com.xx.**.model</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<!-- use auto detection -->
<prop key="hibernate.dialect">org.hibernate.dialect.SQLServer2008Dialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.connection.url">jdbc:sqlserver://localhost;DatabaseName=ISPM</prop>
<prop key="hibernate.connection.username">xx</prop>
<prop key="hibernate.connection.password">app</prop>
</props>
</property>
</bean>
</beans>