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, [EMAIL PROTECTED] The Computing Froggy ----- Message d'origine ---- De : Thomas Dudziak <[EMAIL PROTECTED]> À : [email protected] 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 <[EMAIL PROTECTED]> 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
