Hi
I'm using ddlutils-1.0.jar (built checking out latest code from SVN, ran ANT
JAR and collected jar file from dist folder). Below are the steps I'm doing.
1. Using MS SQL Server 2005 database
2. With the help of ddlutils created two xml files one for DB Schema and
another for data from MS SQL Server 2005
3. Now I have two xml files
4. Now again with the help of ANT and ddlutils re-creating schema and
data back into the same database (MS SQL server from which these files
created before)
5. I'm getting below exception
[ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec4 is
still not written because it depends on these yet unwritten rows
[ddlToDatabase] BENEFIT_DESCRIPTOR:ID=7855bba3caed4543b07d92c2eac21241
[ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec5 is
still not written because it depends on these yet unwritten rows
[ddlToDatabase] BENEFIT_DESCRIPTOR:ID=89d2272bdd4540ad98a04ac4a29ef239
[ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec6 is
still not written because it depends on these yet unwritten rows
[ddlToDatabase] BENEFIT_DESCRIPTOR:ID=902769f777c248eba6a992ca4275ba35
[ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec7 is
still not written because it depends on these yet unwritten rows
[ddlToDatabase] BENEFIT_DESCRIPTOR:ID=98996ee1b4a54eddb57ee847698a4258
[ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec8 is
still not written because it depends on these yet unwritten rows
[ddlToDatabase] BENEFIT_DESCRIPTOR:ID=c40a35f55356411982f8b49bf32b0654
[ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec9 is
still not written because it depends on these yet unwritten rows
[ddlToDatabase] BENEFIT_DESCRIPTOR:ID=d6d16dc6d8f8473b8769d079349fae24
[ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21eca is
still not written because it depends on these yet unwritten rows
[ddlToDatabase] BENEFIT_DESCRIPTOR:ID=f032756a426e47f1b3b57f07a2a44ebc
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 7880 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.j
ava: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(InternalAntRunn
er.java:423)
at
org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRun
ner.java:137)
I tried my best to investigate on where I'm going wrong. When I start
working on this requirement, we were using ddlutils-1.0.jar which is
downloaded from internet. Now I'm using ddlutils version 1.1 which is
checked out from SVN and build locally. I looked at generated data file
(created from SQL Server 2005 database) too. It looks good to me. Is that
because of data reading from MS SQL Server 2005 or is that because of too
many rows are waiting for other rows to be inserted and the waiting rows
increased to a stage where ddlutils cannot handle them? Any point/hint to
solve my problem is greatly appreciated.
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.
