You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-user@db.apache.org by Laurent ROCHE <la...@yahoo.com> on 2006/12/20 13:05:44 UTC
Re : Re : Not much info with: "Could not parse or write data file"
Hi,
Find at the end of the message, the output of two runs one with -v the other with -debug.
Reading it I could not figure out what's wrong ! Obviously, something with the data ... but I can not find an error message pointing me to the error.
Has anyone an idea about this ?
Cheers,
L@u
The Computing Froggy
----- Message d'origine ----
De : Thomas Dudziak <to...@gmail.com>
À : ddlutils-user@db.apache.org
Envoyé le : Jeudi, 14 Décembre 2006, 6h11mn 31s
Objet : Re: Re : Not much info with: "Could not parse or write data file"
On 12/13/06, Laurent ROCHE <la...@yahoo.com> wrote:
> Yes, the file does exist.
> I should have said that I have managed to make it work previously with a tiny version of the database, but as soon as I take the full db, the import fails.
> Also DB-unit manages to import the data without failing.
>
> There's no error message in derby.log, last line is:
> Chargeur de classe de la base de données démarré - derby.database.classpath=''
> (excuse my French ;-) ! )
>
> The schema makes sense in dblook, Cloudscape Workbench, Squirrel, ...
>
> I still need a way to find out what the IMPORT error is !
As I said earlier, please run Ant with the -v or -debug flag. This
should give you the full stacktrace which will give us more info about
what's going on.
Tom
======== ant -v import-derby =================
...
...
[ddlToDatabase] INFO: Executed 193 SQL command(s) with 0 error(s)
[ddlToDatabase] Written schema to database
BUILD FAILED
C:\apps\Ddlutils-test\build.xml:35: Could not parse or write data file C:\apps\Ddlutils-test\data.xml
at org.apache.ddlutils.task.WriteDataToDatabaseCommand.readSingleDataFile(WriteDataToDatabaseCommand.java:224)
at org.apache.ddlutils.task.WriteDataToDatabaseCommand.execute(WriteDataToDatabaseCommand.java:161)
at org.apache.ddlutils.task.DatabaseTaskBase.executeCommands(DatabaseTaskBase.java:279)
at org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.java:303)
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.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.Main.runBuild(Main.java:668)
at org.apache.tools.ant.Main.startAnt(Main.java:187)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
Caused by: org.apache.ddlutils.io.DataSinkException: There are 67 objects still not written because of missing reference
d objects
at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:190)
at org.apache.ddlutils.io.DataReader.endDocument(DataReader.java:167)
at org.apache.xerces.parsers.AbstractSAXParser.endDocument(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.skipSpaces(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1631)
at org.apache.ddlutils.task.WriteDataToDatabaseCommand.readSingleDataFile(WriteDataToDatabaseCommand.java:217)
... 15 more
--- Nested Exception ---
org.apache.ddlutils.io.DataSinkException: There are 67 objects still not written because of missing referenced objects
at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:190)
at org.apache.ddlutils.io.DataReader.endDocument(DataReader.java:167)
at org.apache.xerces.parsers.AbstractSAXParser.endDocument(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.skipSpaces(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1631)
at org.apache.ddlutils.task.WriteDataToDatabaseCommand.readSingleDataFile(WriteDataToDatabaseCommand.java:217)
at org.apache.ddlutils.task.WriteDataToDatabaseCommand.execute(WriteDataToDatabaseCommand.java:161)
at org.apache.ddlutils.task.DatabaseTaskBase.executeCommands(DatabaseTaskBase.java:279)
at org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.java:303)
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.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.Main.runBuild(Main.java:668)
at org.apache.tools.ant.Main.startAnt(Main.java:187)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
Total time: 32 seconds
===== ant -debug import-derby ==========
...
...
[ddlToDatabase] INFO: Executed 193 SQL command(s) with 0 error(s)
[ddlToDatabase] Written schema to database
Finding class org.apache.ddlutils.io.DataToDatabaseSink
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/DataToDatabaseSink.class
Class org.apache.ddlutils.io.DataToDatabaseSink loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.DataSinkException
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/DataSinkException.class
Class org.apache.ddlutils.io.DataSinkException loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.DataReader
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/DataReader.class
Class org.apache.ddlutils.io.DataReader loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.DynaSqlCreateRule
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/DynaSqlCreateRule.class
Class org.apache.ddlutils.io.DynaSqlCreateRule loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.SetColumnPropertyRule
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/SetColumnPropertyRule.class
Class org.apache.ddlutils.io.SetColumnPropertyRule loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.SetColumnPropertyFromSubElementRule
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/SetColumnPropertyFromSubElementRule.cl
ass
Class org.apache.ddlutils.io.SetColumnPropertyFromSubElementRule loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.ConverterConfiguration
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/ConverterConfiguration.class
Class org.apache.ddlutils.io.ConverterConfiguration loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.converters.SqlTypeConverter
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/converters/SqlTypeConverter.class
Class org.apache.ddlutils.io.converters.SqlTypeConverter loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.converters.NumberConverter
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/converters/NumberConverter.class
Class org.apache.ddlutils.io.converters.NumberConverter loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.converters.ByteArrayBase64Converter
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/converters/ByteArrayBase64Converter.cl
ass
Class org.apache.ddlutils.io.converters.ByteArrayBase64Converter loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.converters.ConversionException
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/converters/ConversionException.class
Class org.apache.ddlutils.io.converters.ConversionException loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.converters.DateConverter
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/converters/DateConverter.class
Class org.apache.ddlutils.io.converters.DateConverter loaded from ant loader (parentFirst)
Class java.util.Calendar loaded from parent loader (parentFirst)
Finding class org.apache.ddlutils.io.converters.TimeConverter
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/converters/TimeConverter.class
Class org.apache.ddlutils.io.converters.TimeConverter loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.converters.TimestampConverter
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/converters/TimestampConverter.class
Class org.apache.ddlutils.io.converters.TimestampConverter loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.DigesterRules
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/DigesterRules.class
Class org.apache.ddlutils.io.DigesterRules loaded from ant loader (parentFirst)
ResourceStream for META-INF/services/javax.xml.parsers.SAXParserFactory loaded from parent loader
Class org.apache.xerces.jaxp.SAXParserFactoryImpl loaded from parent loader (parentFirst)
ResourceStream for META-INF/services/org.apache.xerces.xni.parser.XMLParserConfiguration loaded from parent loader
Class org.apache.xerces.parsers.XML11Configuration loaded from parent loader (parentFirst)
Class org.apache.xerces.impl.dv.dtd.DTDDVFactoryImpl loaded from parent loader (parentFirst)
Class java.lang.InstantiationException loaded from parent loader (parentFirst)
Finding class org.apache.ddlutils.dynabean.SqlDynaProperty
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/dynabean/SqlDynaProperty.class
Class org.apache.ddlutils.dynabean.SqlDynaProperty loaded from ant loader (parentFirst)
Class java.io.StreamCorruptedException loaded from parent loader (parentFirst)
Finding class org.apache.ddlutils.dynabean.SqlDynaBean
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/dynabean/SqlDynaBean.class
Finding class org.apache.commons.beanutils.BasicDynaBean
Loaded from C:\apps\Ddlutils-test\lib\commons-beanutils-1.7.0.jar org/apache/commons/beanutils/BasicDynaBean.class
Class org.apache.commons.beanutils.BasicDynaBean loaded from ant loader (parentFirst)
Class org.apache.ddlutils.dynabean.SqlDynaBean loaded from ant loader (parentFirst)
Class java.util.Arrays loaded from parent loader (parentFirst)
Finding class org.apache.ddlutils.platform.PlatformImplBase$1
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/platform/PlatformImplBase$1.class
Class org.apache.ddlutils.platform.PlatformImplBase$1 loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.platform.PlatformImplBase$2
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/platform/PlatformImplBase$2.class
Class org.apache.ddlutils.platform.PlatformImplBase$2 loaded from ant loader (parentFirst)
Finding class org.apache.commons.dbcp.DelegatingPreparedStatement
Loaded from C:\apps\Ddlutils-test\lib\commons-dbcp-1.2.1.jar org/apache/commons/dbcp/DelegatingPreparedStatement.class
Class org.apache.commons.dbcp.DelegatingPreparedStatement loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.Identity
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/Identity.class
Class org.apache.ddlutils.io.Identity loaded from ant loader (parentFirst)
Finding class org.apache.ddlutils.io.WaitingObject
Loaded from C:\apps\Ddlutils-test\lib\DdlUtils-1.0-RC1.jar org/apache/ddlutils/io/WaitingObject.class
Class org.apache.ddlutils.io.WaitingObject loaded from ant loader (parentFirst)
Finding class org.apache.commons.lang.exception.NestableDelegate
Loaded from C:\apps\Ddlutils-test\lib\commons-lang-2.1.jar org/apache/commons/lang/exception/NestableDelegate.class
Class org.apache.commons.lang.exception.NestableDelegate loaded from ant loader (parentFirst)
Finding class org.apache.commons.lang.exception.ExceptionUtils
Loaded from C:\apps\Ddlutils-test\lib\commons-lang-2.1.jar org/apache/commons/lang/exception/ExceptionUtils.class
Class org.apache.commons.lang.exception.ExceptionUtils loaded from ant loader (parentFirst)
Class java.lang.NoSuchFieldException loaded from parent loader (parentFirst)
BUILD FAILED
C:\apps\Ddlutils-test\build.xml:35: Could not parse or write data file C:\apps\Ddlutils-test\data.xml
at org.apache.ddlutils.task.WriteDataToDatabaseCommand.readSingleDataFile(WriteDataToDatabaseCommand.java:224)
at org.apache.ddlutils.task.WriteDataToDatabaseCommand.execute(WriteDataToDatabaseCommand.java:161)
at org.apache.ddlutils.task.DatabaseTaskBase.executeCommands(DatabaseTaskBase.java:279)
at org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.java:303)
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.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.Main.runBuild(Main.java:668)
at org.apache.tools.ant.Main.startAnt(Main.java:187)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
Caused by: org.apache.ddlutils.io.DataSinkException: There are 67 objects still not written because of missing reference
d objects
at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:190)
at org.apache.ddlutils.io.DataReader.endDocument(DataReader.java:167)
at org.apache.xerces.parsers.AbstractSAXParser.endDocument(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.skipSpaces(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1631)
at org.apache.ddlutils.task.WriteDataToDatabaseCommand.readSingleDataFile(WriteDataToDatabaseCommand.java:217)
... 15 more
--- Nested Exception ---
org.apache.ddlutils.io.DataSinkException: There are 67 objects still not written because of missing referenced objects
at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:190)
at org.apache.ddlutils.io.DataReader.endDocument(DataReader.java:167)
at org.apache.xerces.parsers.AbstractSAXParser.endDocument(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.skipSpaces(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1631)
at org.apache.ddlutils.task.WriteDataToDatabaseCommand.readSingleDataFile(WriteDataToDatabaseCommand.java:217)
at org.apache.ddlutils.task.WriteDataToDatabaseCommand.execute(WriteDataToDatabaseCommand.java:161)
at org.apache.ddlutils.task.DatabaseTaskBase.executeCommands(DatabaseTaskBase.java:279)
at org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.java:303)
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.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.Main.runBuild(Main.java:668)
at org.apache.tools.ant.Main.startAnt(Main.java:187)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
Total time: 18 seconds
___________________________________________________________________________
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire.
http://fr.mail.yahoo.com
Re: Re : Re : Not much info with: "Could not parse or write data file"
Posted by Thomas Dudziak <to...@gmail.com>.
On 12/20/06, Laurent ROCHE <la...@yahoo.com> wrote:
> Find at the end of the message, the output of two runs one with -v the other with -debug.
>
> Reading it I could not figure out what's wrong ! Obviously, something with the data ... but I can not find an error message pointing me to the error.
>
> Has anyone an idea about this ?
<snip>
> Caused by: org.apache.ddlutils.io.DataSinkException: There are 67 objects still not written because of missing referenced objects
This message basically means that in the data file, there are 67
entries with contain foreign key values pointing to rows that are not
in the data XML. Since DdlUtils by default inserts rows in the correct
order (eg. referenced rows before referencing rows), they will be hold
until the end.
However, there was a tiny bug in this which I fixed a couple of days
ago, so please update DdlUtils and try again. If the problem persists,
then you're probably missing some rows that need to be in the data
XML.
Tom