Hi,
I have run ant with -debug, please see attached console output.
It appears that the writeDataToFile task is running though other schemas
in the same database. I dropped the other schema with the
ACCOUNT_DETAILS table and now it is reporting the same error with a
different table (which exists in a another schema on the database).
Thanks,
Pentti
-----Original Message-----
From: Thomas Dudziak [mailto:[EMAIL PROTECTED]
Sent: 16 March 2007 01:33
To: [email protected]
Subject: Re: Error when running databaseToDdl task to dump data to xml
file on oracle10 database
On 3/12/07, Pentti Kavanagh <[EMAIL PROTECTED]> wrote:
> I am using the ddlutils ant task 'databaseToDdl' to dump some data to
> an xml file.
>
> The task fails with this error:-
>
> org.apache.ddlutils.model.ModelException: There are multiple column
> with the name V2_ACCOUNT_NO in the table ACCOUNT_DETAILS
>
> Here is my ant script:-
>
> <target name="data-dump" description="Dumps the database data">
> <taskdef name="databaseToDdl"
>
> classname="org.apache.ddlutils.task.DatabaseToDdlTask">
> <classpath refid="runtime-classpath" />
> </taskdef>
> <databaseToDdl modelName="PerfModel" verbosity="debug"
> databaseType="oracle10"
schemapattern="TEST34">
> <database
> url="jdbc:oracle:thin:@devperfdb3:1521:perf"
>
> driverClassName="oracle.jdbc.driver.OracleDriver"
> username="TEST34"
password="password"/>
> <writeDataToFile outputFile="perf-data.xml"/>
> </databaseToDdl>
> </target>
>
> I can successfully run the writeSchemaToFile element on the same
> database schema.
>
> Obviously my the table ACCOUNT_DETAILS only has one V2_ACCOUNT_NO
> column.
>
> Any ideas why I am getting this problem?
That is odd. Could you turn on debug logging to see whether there is
something interesting in there ?
Tom
Apache Ant version 1.6.5 compiled on June 2 2005
Setting ro project property: ant.file ->
C:\Data\EclipseProjects\ddlutils\build-test.xml
Buildfile: C:\Data\EclipseProjects\ddlutils\build-test.xml
Adding reference: ant.projectHelper
Adding reference: ant.parsing.context
Adding reference: ant.targets
parsing buildfile C:\Data\EclipseProjects\ddlutils\build-test.xml with URI =
file:///C:/Data/EclipseProjects/ddlutils/build-test.xml
Setting ro project property: ant.project.name -> DdlUtils
Adding reference: DdlUtils
Setting ro project property: ant.file.DdlUtils ->
C:\Data\EclipseProjects\ddlutils\build-test.xml
Project base dir set to: C:\Data\EclipseProjects\ddlutils
+Target:
Adding reference: runtime-classpath
+Target: data-dump
Could not load a dependent class (com/sun/media/jai/codec/FileSeekableStream)
for type image
Could not load a dependent class (com/jcraft/jsch/UserInfo) for type sshexec
Could not load a dependent class (com/jcraft/jsch/UserInfo) for type scp
Adding reference: runtime-classpath
Adding reference: eclipse.ant.targetVector
Build sequence for target(s) `data-dump' is [data-dump]
Complete build sequence is [data-dump, ]
data-dump:
Could not load a dependent class (com/sun/media/jai/codec/FileSeekableStream)
for type image
Could not load a dependent class (com/jcraft/jsch/UserInfo) for type sshexec
Could not load a dependent class (com/jcraft/jsch/UserInfo) for type scp
Could not load a dependent class (jdepend/xmlui/JDepend) for type jdepend
Could not load a dependent class (junit/framework/TestListener) for type junit
fileset: Setup scanner in dir C:\Data\EclipseProjects\ddlutils\lib with
patternSet{ includes: [**/*.jar, **/*.zip] excludes: [] }
Class org.apache.ddlutils.task.DatabaseToDdlTask loaded from parent loader
(parentFirst)
+Datatype databaseToDdl org.apache.ddlutils.task.DatabaseToDdlTask
[databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source
[databaseToDdl] Returning connection [EMAIL PROTECTED] to data source.
[databaseToDdl] Remaining connections: None
[databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source
[databaseToDdl] Returning connection [EMAIL PROTECTED] to data source.
[databaseToDdl] Remaining connections: None
BUILD FAILED
C:\Data\EclipseProjects\ddlutils\build-test.xml:31:
org.apache.ddlutils.model.ModelException: There are multiple column with the
name V2_ACCOUNT_NO in the table ACCOUNT_DETAILS
at
org.apache.ddlutils.task.WriteDataToFileCommand.execute(WriteDataToFileCommand.java:94)
at
org.apache.ddlutils.task.DatabaseTaskBase.executeCommands(DatabaseTaskBase.java:376)
at
org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.java:402)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at
org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at
org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
at
org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
Caused by: org.apache.ddlutils.model.ModelException: There are multiple column
with the name V2_ACCOUNT_NO in the table ACCOUNT_DETAILS
at org.apache.ddlutils.model.Database.initialize(Database.java:295)
at
org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:484)
at
org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:432)
at
org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1876)
at
org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1861)
at
org.apache.ddlutils.io.DatabaseDataIO.writeDataToXML(DatabaseDataIO.java:359)
at
org.apache.ddlutils.io.DatabaseDataIO.writeDataToXML(DatabaseDataIO.java:306)
at
org.apache.ddlutils.task.WriteDataToFileCommand.execute(WriteDataToFileCommand.java:88)
... 13 more
--- Nested Exception ---
org.apache.ddlutils.model.ModelException: There are multiple column with the
name V2_ACCOUNT_NO in the table ACCOUNT_DETAILS
at org.apache.ddlutils.model.Database.initialize(Database.java:295)
at
org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:484)
at
org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:432)
at
org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1876)
at
org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1861)
at
org.apache.ddlutils.io.DatabaseDataIO.writeDataToXML(DatabaseDataIO.java:359)
at
org.apache.ddlutils.io.DatabaseDataIO.writeDataToXML(DatabaseDataIO.java:306)
at
org.apache.ddlutils.task.WriteDataToFileCommand.execute(WriteDataToFileCommand.java:88)
at
org.apache.ddlutils.task.DatabaseTaskBase.executeCommands(DatabaseTaskBase.java:376)
at
org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.java:402)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at
org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at
org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
at
org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
Total time: 1 minute 47 seconds
