writeschemasqltofile creates blank file

[gla-001]

Hi everybody,

similar to other posts
(http://www.nabble.com/problem-writing-sql-to-file-td3876914.html#a3876914,
http://www.nabble.com/No-output-from-writeSchemaSqlTofile-command-td17453074.html#a17516352),
<writeschemasqltofile> creates a blank file. As recommended i set
alterdatabase="false" without any effect. I tried to convert the generated
xml to sql using <ddlToDatabase>, without success. My Ant-Target looks like
this:

        <target name="database-dump" description="Create dump">

          <mkdir dir="${out.dir}" />
                
          <taskdef name="databaseToDdl"
classname="org.apache.ddlutils.task.DatabaseToDdlTask" />
                
          <databaseToDdl modelname="MyModel" verbosity="debug"
databasetype="oracle9" 
                usedelimitedsqlidentifiers="true" tabletypes="TABLE"
schemapattern="MySchema">
                
            <database url="jdbc:oracle:thin:@[host]:1521:orcl"
                    driverClassName="oracle.jdbc.OracleDriver"
                    username="[usr]"
                    password="[pwd]"
                        initialsize="5"
                        testonborrow="true"
                        testonreturn="true"/>
                
                <writeschemasqltofile failonerror="false"
outputfile="${out.dir}/schema.sql"/>
            <writeSchemaToFile failonerror="false"
outputFile="${out.dir}/schema.xml"/>
          </databaseToDdl>

        </target>

The XML file is created properly.

Does anybody have an idea?

Thanks in advance!

Cheers,

GLA


-- 
View this message in context: 
http://www.nabble.com/writeschemasqltofile-creates-blank-file-tp25330367p25330367.html
Sent from the Apache DdlUtils - User mailing list archive at Nabble.com.