I am trying to load data into Oracle using DDLUtils Ant task. The task
reports that the data is successfully written to the database. However, I do
not see any data in Oracle. I don't understand what I am doing wrong! Please
help.
C:\workshop\DDLUtils>ant
Buildfile: build.xml
database-setup:
[ddlToDatabase] Read schema file C:\etc\schema\phase1-schema.xml
[ddlToDatabase] Read schema file C:\etc\schema\phase2-schema.xml
[ddlToDatabase] Read schema file C:\etc\schema\prefs-schema.xml
[ddlToDatabase] Read schema file C:\etc\schema\registry-schema.xml
[ddlToDatabase] Read schema file C:\etc\schema\security-schema.xml
[ddlToDatabase] Borrowed connection
[EMAIL PROTECTED] from data source
[ddlToDatabase] Written data from file C:\etc\sql\j2-seed.xml to database
BUILD SUCCESSFUL
Total time: 2 seconds
Here is my Ant target:
<target name="database-setup" description="Creates the database structure
and inserts data into the database">
<taskdef name="ddlToDatabase"
classname="org.apache.ddlutils.task.DdlToDatabaseTask">
<classpath refid="runtime-classpath"/>
</taskdef>
<ddlToDatabase databasetype="oracle" verbosity="debug">
<database url="${db-url}"
driverClassName="${db-driver}"
username="${db-username}"
password="${db-password}" />
<fileset dir="${db-schema-path}">
<include
name="phase1-schema.xml" />
<include
name="phase2-schema.xml" />
<include
name="phase3ojb-schema.xmll" />
<include
name="prefs-schema.xml" />
<include
name="registry-schema.xml" />
<include
name="security-schema.xml" />
</fileset>
<!-- <createDatabase failonerror="false" />
-->
<!-- <writeSchemaToDatabase /> -->
<writeDataToDatabase
datafile="${db-data-file}"/>
</ddlToDatabase>
</target>
Thank you for help.
--
Anas Mughal