db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anas Mughal" <anas.mug...@bluenog.com>
Subject Data not written to Oracle
Date Fri, 25 Apr 2008 19:17:26 GMT
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
org.apache.commons.dbcp.PoolableConnection@1ae90c 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

 

 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message