Thanks for your response Tom. I appreciate your time in helping us.
Sorry for my typo. I'm using ddlutils-1.0 version. It's how I'm using ddlutils
in our project. I'm making two xml files, one of data and other for schema.
They are successfully created using ddlutils.
Now I'm trying to recreate schema and load data files using ddlutils again.
While loading data back to database it's throwing an exception. I'm using MS
SQL Server database. Below is the stack trace.
With stack trace I understand that there are few referenced rows are not
loaded. But I'm not sure why ddlutils omitting few rows while uploading data?
BUILD FAILED
C:\InIndividual\trunk\Utilities\Build\BuildScript\buildDatabase.xml:530: The
following error occurred while executing this line:
C:\InIndividual\trunk\Utilities\Build\BuildScript\buildDatabase.xml:105:
org.apache.ddlutils.io.DataSinkException: There are 8 rows still not written
because of missing referenced rows
at
org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:541)
at
org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:394)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at
org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
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:
C:\InIndividual\trunk\Utilities\Build\BuildScript\buildDatabase.xml:105:
org.apache.ddlutils.io.DataSinkException: There are 8 rows still not written
because of missing referenced rows
at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:115)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:62)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
at org.apache.tools.ant.Task.perform(Task.java:348)
at
org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:391)
... 16 more
Thanks
Sashi
-----Original Message-----
From: Thomas Dudziak [mailto:tom...@gmail.com]
Sent: Thursday, January 21, 2010 10:47 PM
To: ddlutils-dev@db.apache.org
Subject: Re: missing references rows issue
Hi Sashi,
I think you are confusing DdlUtils with DbUtils. There is no 1.3
version of DdlUtils, the trunk version is 1.1 at the moment.
As for the error you're seeing, if it says that there are 8 rows not
written because of missing referenced rows, that means that you have a
foreign key relationship between the table of those 8 rows and some
other table, and these 8 rows reference rows in that other table that
are not included in the data file.
If you set the verbosity attribute of the ant task to debug, then
DdlUtils should print out whenever it defers insertion of a row
because its foreign key dependency is not satisfied.
Tom
On Wed, Jan 20, 2010 at 10:13, Sashikanth Maddali
<sashikan...@warnerpacific.com> wrote:
> Hi
>
>
>
> I'm a newbie to dbltutils. I was using version 1.0 jar to copy data to MS
> SQL database. While executing my scripts I'm getting
> org.apache.ddlutils.io.DataSinkException: There are 8 rows still not written
> because of missing referenced rows exception. I heard that newer version
> DBUtils 1.3 version has a fix for this issue. Is that true? How can I check
> out 1.3 source files so that I can test JAR'ing version 1.3. I have access
> to trunk only.
>
>
>
> Thanks
>
> Sashi
>
> Confidentiality and HIPAA/GLBA Statement: This email, together with any
> attachments, is intended only for the use of the individual or entity to
> which it is addressed.
> It may contain information which is confidential or prohibited from any
> disclosure under the HIPAA Privacy Rule, Cal-GLBA or other federal or state
> laws.
> If you are not the intended recipient, you are hereby notified that any
> dissemination or copying of this message or attachment is strictly prohibited.
> If you have received this email in error, please notify the original sender
> and delete this email and any attachments. Thank you.
>
Confidentiality and HIPAA/GLBA Statement: This email, together with any
attachments, is intended only for the use of the individual or entity to which
it is addressed.
It may contain information which is confidential or prohibited from any
disclosure under the HIPAA Privacy Rule, Cal-GLBA or other federal or state
laws.
If you are not the intended recipient, you are hereby notified that any
dissemination or copying of this message or attachment is strictly prohibited.
If you have received this email in error, please notify the original sender and
delete this email and any attachments. Thank you.
