hello, I've been trying to do what I thought would be a simple task for ablmost one hour (with the typing of this topic it becomes one hour). I tried to look into hibernate doc, but I cant find anything, maybe I missed something somewhere?


Hibernate version: 3.0
Name and version of the database you are using: postgreSQL 8.0

problem:

( from console running ant task )

BUILD FAILED: E:\eclipse_workspace\persistance-prototype\build.xml:143: Schema text failed: Could not configure datastore from file: E:\eclipse_workspace\persistance-prototype\dev\config\hibernate\Cat.hbm.xml

aim:
I am trying to generate database schema based on a very simple
mapping file, Cat.hbm.xml. I uses ant task to achieve this, the
schemaexport, as such:

<target name="schemaexport">

<taskdef name="schemaexport"
classname="org.hibernate.tool.hbm2ddl.SchemaExportTask"
classpathref="classpath"/>

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

where $dev.config.hibernate points to a folder containing
Cat.hbm.xml, hibernate.cfg.xml and hibernate.properties

hibernate properties:
hibernate.connection.driver_class=org.postgresql.Driver
hibernate.connection.url=jdbc:postgresql://localhost:5432/dbtest
hibernate.connection.username=root
hibernate.connection.password=somepass
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect

Cat.hbm.xml
unchanged from the original Cat.hbm.xml in the first example,
except for a change in the name attribute to:

<class name="prototypeDP.dataObject.Cat" table="CAT">
( changed class name to reflect my package structure)

Full stack trace of any exception that occurs:

a super-long exception when executing the ant task..
this happen just before the
E:\eclipse_workspace\persistance-prototype\build.xml:143: Schema text failed: Could not configure datastore from file: E:\eclipse_workspace\persistance-prototype\dev\config\hibernate\Cat.hbm.xml
[/i] line

[schemaexport] java.util.zip.ZipException: error in opening zip file
[schemaexport] at java.util.zip.ZipFile.open(Native Method)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResourceURL(AntClassLoader.java:903)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResource(AntClassLoader.java:832)
[schemaexport] at org.apache.log4j.helpers.Loader.getResource(Loader.java:91)
[schemaexport] at org.apache.log4j.LogManager.<clinit>(LogManager.java:94)
[schemaexport] at org.apache.log4j.Logger.getLogger(Logger.java:94)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:229)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:65)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at java.lang.reflect.Constructor.newInstance(Unknown Source)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:235)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:209)
[schemaexport] at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
[schemaexport] at org.hibernate.cfg.Configuration.<clinit>(Configuration.java:110)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.getConfiguration(SchemaExportTask.java:182)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.execute(SchemaExportTask.java:135)
[schemaexport] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269)
[schemaexport] at org.apache.tools.ant.Task.perform(Task.java:364)
[schemaexport] at org.apache.tools.ant.Target.execute(Target.java:301)
[schemaexport] at org.apache.tools.ant.Target.performTasks(Target.java:328)
[schemaexport] at org.apache.tools.ant.Project.executeTarget(Project.java:1215)
[schemaexport] at org.apache.tools.ant.Project.executeTargets(Project.java:1063)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:377)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:135)
[schemaexport] java.util.zip.ZipException: error in opening zip file
[schemaexport] at java.util.zip.ZipFile.open(Native Method)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResourceURL(AntClassLoader.java:903)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResource(AntClassLoader.java:832)
[schemaexport] at org.apache.log4j.helpers.Loader.getResource(Loader.java:91)
[schemaexport] at org.apache.log4j.LogManager.<clinit>(LogManager.java:94)
[schemaexport] at org.apache.log4j.Logger.getLogger(Logger.java:94)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:229)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:65)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at java.lang.reflect.Constructor.newInstance(Unknown Source)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:235)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:209)
[schemaexport] at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
[schemaexport] at org.hibernate.cfg.Configuration.<clinit>(Configuration.java:110)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.getConfiguration(SchemaExportTask.java:182)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.execute(SchemaExportTask.java:135)
[schemaexport] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269)
[schemaexport] at org.apache.tools.ant.Task.perform(Task.java:364)
[schemaexport] at org.apache.tools.ant.Target.execute(Target.java:301)
[schemaexport] at org.apache.tools.ant.Target.performTasks(Target.java:328)
[schemaexport] at org.apache.tools.ant.Project.executeTarget(Project.java:1215)
[schemaexport] at org.apache.tools.ant.Project.executeTargets(Project.java:1063)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:377)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:135)
[schemaexport] java.util.zip.ZipException: error in opening zip file
[schemaexport] at java.util.zip.ZipFile.open(Native Method)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResourceURL(AntClassLoader.java:903)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResource(AntClassLoader.java:832)
[schemaexport] at org.apache.log4j.helpers.Loader.getResource(Loader.java:91)
[schemaexport] at org.apache.log4j.LogManager.<clinit>(LogManager.java:94)
[schemaexport] at org.apache.log4j.Logger.getLogger(Logger.java:94)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:229)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:65)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at java.lang.reflect.Constructor.newInstance(Unknown Source)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:235)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:209)
[schemaexport] at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
[schemaexport] at org.hibernate.cfg.Configuration.<clinit>(Configuration.java:110)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.getConfiguration(SchemaExportTask.java:182)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.execute(SchemaExportTask.java:135)
[schemaexport] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269)
[schemaexport] at org.apache.tools.ant.Task.perform(Task.java:364)
[schemaexport] at org.apache.tools.ant.Target.execute(Target.java:301)
[schemaexport] at org.apache.tools.ant.Target.performTasks(Target.java:328)
[schemaexport] at org.apache.tools.ant.Project.executeTarget(Project.java:1215)
[schemaexport] at org.apache.tools.ant.Project.executeTargets(Project.java:1063)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:377)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:135)
[schemaexport] java.util.zip.ZipException: error in opening zip file
[schemaexport] at java.util.zip.ZipFile.open(Native Method)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResourceURL(AntClassLoader.java:903)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResource(AntClassLoader.java:832)
[schemaexport] at org.apache.log4j.helpers.Loader.getResource(Loader.java:91)
[schemaexport] at org.apache.log4j.LogManager.<clinit>(LogManager.java:96)
[schemaexport] at org.apache.log4j.Logger.getLogger(Logger.java:94)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:229)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:65)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at java.lang.reflect.Constructor.newInstance(Unknown Source)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:235)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:209)
[schemaexport] at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
[schemaexport] at org.hibernate.cfg.Configuration.<clinit>(Configuration.java:110)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.getConfiguration(SchemaExportTask.java:182)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.execute(SchemaExportTask.java:135)
[schemaexport] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269)
[schemaexport] at org.apache.tools.ant.Task.perform(Task.java:364)
[schemaexport] at org.apache.tools.ant.Target.execute(Target.java:301)
[schemaexport] at org.apache.tools.ant.Target.performTasks(Target.java:328)
[schemaexport] at org.apache.tools.ant.Project.executeTarget(Project.java:1215)
[schemaexport] at org.apache.tools.ant.Project.executeTargets(Project.java:1063)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:377)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:135)
[schemaexport] java.util.zip.ZipException: error in opening zip file
[schemaexport] at java.util.zip.ZipFile.open(Native Method)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResourceURL(AntClassLoader.java:903)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResource(AntClassLoader.java:832)
[schemaexport] at org.apache.log4j.helpers.Loader.getResource(Loader.java:91)
[schemaexport] at org.apache.log4j.LogManager.<clinit>(LogManager.java:96)
[schemaexport] at org.apache.log4j.Logger.getLogger(Logger.java:94)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:229)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:65)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at java.lang.reflect.Constructor.newInstance(Unknown Source)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:235)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:209)
[schemaexport] at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
[schemaexport] at org.hibernate.cfg.Configuration.<clinit>(Configuration.java:110)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.getConfiguration(SchemaExportTask.java:182)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.execute(SchemaExportTask.java:135)
[schemaexport] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269)
[schemaexport] at org.apache.tools.ant.Task.perform(Task.java:364)
[schemaexport] at org.apache.tools.ant.Target.execute(Target.java:301)
[schemaexport] at org.apache.tools.ant.Target.performTasks(Target.java:328)
[schemaexport] at org.apache.tools.ant.Project.executeTarget(Project.java:1215)
[schemaexport] at org.apache.tools.ant.Project.executeTargets(Project.java:1063)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:377)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:135)
[schemaexport] java.util.zip.ZipException: error in opening zip file
[schemaexport] at java.util.zip.ZipFile.open(Native Method)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at java.util.zip.ZipFile.<init>(Unknown Source)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResourceURL(AntClassLoader.java:903)
[schemaexport] at org.apache.tools.ant.AntClassLoader.getResource(AntClassLoader.java:832)
[schemaexport] at org.apache.log4j.helpers.Loader.getResource(Loader.java:91)
[schemaexport] at org.apache.log4j.LogManager.<clinit>(LogManager.java:96)
[schemaexport] at org.apache.log4j.Logger.getLogger(Logger.java:94)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:229)
[schemaexport] at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:65)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[schemaexport] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[schemaexport] at java.lang.reflect.Constructor.newInstance(Unknown Source)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:235)
[schemaexport] at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:209)
[schemaexport] at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
[schemaexport] at org.hibernate.cfg.Configuration.<clinit>(Configuration.java:110)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.getConfiguration(SchemaExportTask.java:182)
[schemaexport] at org.hibernate.tool.hbm2ddl.SchemaExportTask.execute(SchemaExportTask.java:135)
[schemaexport] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269)
[schemaexport] at org.apache.tools.ant.Task.perform(Task.java:364)
[schemaexport] at org.apache.tools.ant.Target.execute(Target.java:301)
[schemaexport] at org.apache.tools.ant.Target.performTasks(Target.java:328)
[schemaexport] at org.apache.tools.ant.Project.executeTarget(Project.java:1215)
[schemaexport] at org.apache.tools.ant.Project.executeTargets(Project.java:1063)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:377)
[schemaexport] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:135)
[schemaexport] log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
[schemaexport] log4j:WARN Please initialize the log4j system properly.


any help would be GREATLY appreciated.

cheers,
zen.