SchemaExport can't find hibernate.cfg.xml

russell · **Joined:** Wed Jul 07, 2004 11:49 am **Posts:** 6

Hello, hoping someone can help me with this problem that is bound to be a result of some stupid oversight of mine.

The problem is that SchemaExport can't find hibernate.cfg.xml , despite the fact that it's in the classpath. Configuration(), called from my own code with the same classpath, can find it (and the .hbm.xml files, which live in the same place). I have tried it both from ant:

Code:

  <project name="lockup" basedir="../" default="all">
[...]
  <path id="compile.classpath">
[...]
        <pathelement path="classes"/>
[...]
    <target name="schemaexport" depends="project">
        <taskdef name="schemaexport"  classname="net.sf.hibernate.tool.hbm2ddl.SchemaExportTask" classpathref="compile.classpath"/>

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

and on the command line:

Code:

java -cp ../classes:../lib/hibernate-tools.jar:../lib/hibernate2.jar:../lib/commons-collections.jar:../lib/commons-logging.jar:../lib/jdom.jar:../lib/commons-lang.jar:../lib/dom4j-1.4.jar:../lib/odmg-3.0.jar net.sf.hibernate.tool.hbm2ddl.SchemaExport --config="hibernate.cfg.xml"

Either way, I get

Code:

[...]
INFO: configuring from resource: hibernate.cfg.xml
Jul 8, 2004 3:39:18 PM net.sf.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: hibernate.cfg.xml
Jul 8, 2004 3:39:18 PM net.sf.hibernate.cfg.Configuration getConfigurationInputStream
WARNING: hibernate.cfg.xml not found
Jul 8, 2004 3:39:18 PM net.sf.hibernate.tool.hbm2ddl.SchemaExport main
SEVERE: Error creating schema 
net.sf.hibernate.HibernateException: hibernate.cfg.xml not found
        at net.sf.hibernate.cfg.Configuration.getConfigurationInputStream(Configuration.java:849)
[...]

, despite the fact that hibernate.cfg.xml exists in ../classes.

This is with Hibernate 2.1. Thanks in advance for any help you can give.

russell · **Joined:** Wed Jul 07, 2004 11:49 am **Posts:** 6

I should add, SchemaExport works fine when I use a hibernate.properties file in ../classes instead. (But I don't want to do this as it makes the session factory producing code uglier. At the moment I have both, which is pretty silly and dangerous of course)

lixin_chu · **Posted:** Tue Jul 13, 2004 11:09 am

I am having the same problem. still do not know why !

christian · **Posted:** Tue Jul 13, 2004 11:13 am

the --config switch to SchemaExport is a File, that means you need to specify the full path:

<schemaexport config="${classes.dir}/hibernate.cfg.xml"
quiet="no"
text="no"/>

lixin_chu · **Posted:** Tue Jul 13, 2004 11:59 am

tried. here is my build.xml file, but still does not work
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<?xml version="1.0"?>

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

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

<path id="classpath">
<pathelement location="${lib.dir}/hibernate2.jar"/>
<pathelement location="${lib.dir}/dom4j.jar"/>
<pathelement location="${lib.dir}/commons-logging.jar"/>
<pathelement location="${lib.dir}/commons-collections.jar"/>
<pathelement location="${lib.dir}/hibernate-2.1.1/odmg.jar"/>
<pathelement location="${lib.dir}/"/>
<pathelement location="../classes"/>
</path>

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

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

</project>

russell · **Joined:** Wed Jul 07, 2004 11:49 am **Posts:** 6

Thanks!

lixin_chu · **Posted:** Tue Jul 13, 2004 12:02 pm

my folder structure is:
/src/build.xml
/src/resources/hibernate.cfg.xml

Kaneda · **Posted:** Tue Jul 13, 2004 12:09 pm

@lixin_chu if using eclipse you should try to define resource.dir like
<property name="resource.dir" value="${basedir}/src/resources"/>

lixin_chu · **Posted:** Tue Jul 13, 2004 12:13 pm

No, I am using command promopt at this moment.

If I change "config=...." to:
properties="${resource.dir}/hibernate.properties"

everything works.

a side note, text="yes" not "no" otherwise I can only get an empty .sql file !

Kaneda · **Posted:** Tue Jul 13, 2004 12:31 pm

If you put the cfg.xml into the lib dir and use the config=${lib.dir}/hibernate.cfg.xml this also doesn't work ?

lixin_chu · **Posted:** Wed Jul 14, 2004 7:22 am

tried. It does not work.

Kaneda · **Posted:** Wed Jul 14, 2004 8:31 am

Sounds to me like a problem with the relativ paths you are using. Ensure that they point to the right directories, or as Christian mentioned use a full path to the config file that should do the job not a good solution but a working one.