Hi, Sorry, I must correct my email from today (Thu, 23 Jan, 2007). The <writeSchemaToDatabase/> process ends with success!!! Only the <writeDataToDatabase> process makes trouble, please look at my following console output and to my additional questions below this output.
error message: ... [ddlToDatabase] Written schema to database [ddlToDatabase] Borrowed connection [EMAIL PROTECTED] from data source [ddlToDatabase] Could not parse or write data file C:\Programme\eclipse 3.2\eclipse\workspace\MigrateDatabaseToDerby\ddlutils\data.xml [ddlToDatabase] org.apache.ddlutils.DdlUtilsException: java.net.MalformedURLException: unknown protocol: c [ddlToDatabase] at org.apache.ddlutils.io.DatabaseDataIO.writeDataToDatabase(DatabaseDataIO .java:642) [ddlToDatabase] at org.apache.ddlutils.task.WriteDataToDatabaseCommand.readSingleDataFile(W riteDataToDatabaseCommand.java:222) [ddlToDatabase] at org.apache.ddlutils.task.WriteDataToDatabaseCommand.execute(WriteDataToD atabaseCommand.java:159) [ddlToDatabase] at org.apache.ddlutils.task.DatabaseTaskBase.executeCommands(DatabaseTaskBa se.java:376) [ddlToDatabase] at org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.java: 402) [ddlToDatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275) [ddlToDatabase] at org.apache.tools.ant.Task.perform(Task.java:364) [ddlToDatabase] at org.apache.tools.ant.Target.execute(Target.java:341) [ddlToDatabase] at org.apache.tools.ant.Target.performTasks(Target.java:369) [ddlToDatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216) [ddlToDatabase] at org.apache.tools.ant.Project.executeTarget(Project.java:1185) [ddlToDatabase] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecut or.java:40) [ddlToDatabase] at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTar gets(EclipseDefaultExecutor.java:32) [ddlToDatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1068) [ddlToDatabase] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAnt Runner.java:423) [ddlToDatabase] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAn tRunner.java:137) [ddlToDatabase] Caused by: java.net.MalformedURLException: unknown protocol: c [ddlToDatabase] at java.net.URL.<init>(URL.java:574) [ddlToDatabase] at java.net.URL.<init>(URL.java:464) [ddlToDatabase] at java.net.URL.<init>(URL.java:413) [ddlToDatabase] at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.setupCurrentEnt ity(XMLEntityManager.java:650) [ddlToDatabase] at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector.determineDocV ersion(XMLVersionDetector.java:186) [ddlToDatabase] at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML1 1Configuration.java:771) [ddlToDatabase] at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML1 1Configuration.java:737) [ddlToDatabase] at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.jav a:107) [ddlToDatabase] at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Abstr actSAXParser.java:1205) [ddlToDatabase] at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.pars e(SAXParserImpl.java:522) [ddlToDatabase] at org.apache.commons.digester.Digester.parse(Digester.java:1704) [ddlToDatabase] at org.apache.ddlutils.io.DatabaseDataIO.writeDataToDatabase(DatabaseDataIO .java:638) [ddlToDatabase] ... 15 more BUILD SUCCESSFUL Total time: 28 seconds ---------------------------- How could I check my created data.xml file? Is there a possibility to check it by a dtd? My data.xml file is well-formed, but by looking through it I see that there are many(!) entries not correct i.e. column names were not been written always correctly into the data.xml file by the <writeDataToFile> process. Please see the following examples (what could be the reason for that?): <CASES CASES_MODCID="1" CASES_CASEID="84" /> <CASES ASES_MODCID="1" CASES_CASEID="85" /> or <CASES_DATA CASESDATA_MODCID="1" CASESDATA_CASEID="84" CASESDATA_VARCODE="wrkhrs" CASESDATA_VALCODE="0" /> <CASES_DATA CID="1" CASESDATA_CASEID="85" CASESDATA_VARCODE="v0" CASESDATA_VALCODE="1" /> Thanks for help in advance Kind regards Siegfried Schomisch ---------------------------------------- Social Science Information Centre Department Research & Development Siegfried Schomisch, M.A. Lennestr. 30, D-53113 Bonn, Germany Phone: (+49) 228 2281 168 Fax: (+49) 228 2281 120 E-mail: [EMAIL PROTECTED] http://www.gesis.org/IZ/ -----------------------------------
