db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <..@Bonn.IZ-Soz.de>
Subject Error: Could not parse or write data file referring to "<writeDataToDatabase datafile="data.xml"/>"
Date Tue, 23 Jan 2007 15:01:03 GMT
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
org.apache.commons.dbcp.PoolableConnection@1715510 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: sm@bonn.iz-soz.de
http://www.gesis.org/IZ/  
-----------------------------------

Mime
View raw message