db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sashikanth Maddali" <Sashikan...@warnerpacific.com>
Subject RE: missing references rows issue
Date Fri, 22 Jan 2010 16:55:27 GMT
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:tomdzk@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
<Sashikanthm@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.


Mime
View raw message