Hello,
Ant task schemaupdate runs without errors, but it won't update the DB, even though the SQL statements are displayed, and they're correct.
Here is the task:
Code:
<taskdef name="schemaupdate"
classname="net.sf.hibernate.tool.hbm2ddl.SchemaUpdateTask">
<classpath refid="libs"/>
<classpath path="${classes}"/>
</taskdef>
<target name="schemaupdate"
description="Schema Update "
depends="copymappings">
<schemaupdate
config="classes/hibernate.cfg.xml"
quiet="no">
</schemaupdate>
</target>
A similar Export task uns perfectly.
Here is the log file of the Update task:
Code:
INFO main net.sf.hibernate.cfg.Configuration - Configured SessionFactory: null
INFO main net.sf.hibernate.dialect.Dialect - Using dialect: net.sf.hibernate.dialect.MySQLDialect
INFO main net.sf.hibernate.connection.ConnectionProviderFactory - Initializing connection provider: net.sf.hibernate.connection.ProxoolConnectionProvider
INFO main net.sf.hibernate.connection.ProxoolConnectionProvider - Configuring Proxool Provider using Hibernate properties
INFO main net.sf.hibernate.connection.ProxoolConnectionProvider - Proxool Provider properties: {proxool.maximum-connection-count=3, proxool.house-keeping-test-sql=select 1 from dual, proxool.house-keeping-sleep-time=30000}
INFO main net.sf.hibernate.connection.ProxoolConnectionProvider - Delegate JDBC Driver Connection properties: {user=root, password=secret}
INFO main net.sf.hibernate.connection.ProxoolConnectionProvider - Proxool Provider using delegate JDBC Driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://127.0.0.1/asp
INFO main net.sf.hibernate.connection.ProxoolConnectionProvider - Proxool Provider Connection URL: proxool.hibernate-1:com.mysql.jdbc.Driver:jdbc:mysql://127.0.0.1/dbname
INFO main org.logicalcobwebs.proxool.ProxoolFacade - Proxool 0.8.3 (14-Dec-2003 16:06)
INFO main net.sf.hibernate.connection.ProxoolConnectionProvider - JDBC isolation level: left to driver default
INFO main net.sf.hibernate.tool.hbm2ddl.SchemaUpdate - Running hbm2ddl schema update
INFO main net.sf.hibernate.tool.hbm2ddl.SchemaUpdate - fetching database metadata
INFO main net.sf.hibernate.tool.hbm2ddl.SchemaUpdate - updating schema
INFO main net.sf.hibernate.cfg.Configuration - processing one-to-many association mappings
INFO main net.sf.hibernate.cfg.Binder - Mapping collection: net.bookingasp.settings.LayoutPage.columns -> settings_layout_column
INFO main net.sf.hibernate.cfg.Binder - Mapping collection: net.bookingasp.settings.LayoutColumn.boxes -> settings_layout
INFO main net.sf.hibernate.cfg.Configuration - processing one-to-one association property references
INFO main net.sf.hibernate.cfg.Configuration - processing foreign key constraints
INFO main net.sf.hibernate.tool.hbm2ddl.SchemaUpdate - schema update complete
INFO main org.logicalcobwebs.proxool.hibernate-1 - Shutting down 'hibernate-1' pool immediately [main]
Thanks,