Hi, After changing of my build.xm file and successful doing of Step 4 "Export Schema and Data" (see my email from Thu, 18 Jan) I get an error message when I process Step 5 "Create Database and Import Schema and Data":
error message: [ddlToDatabase] Read schema file C:\Programme\eclipse 3.2\eclipse\workspace\MigrateDatabaseToDerby\ddlutils\project-schema.xml [ddlToDatabase] About to create database using this URL: jdbc:derby:C:\\Programme\\eclipse\\ISSPDataWizard\\Runtimes\\ISSPPartner \\Derby_Apache_10.2.2.0\\database\\issp_Import_DdlUtils;create=true [ddlToDatabase] Database 'C:\\Programme\\eclipse\\ISSPDataWizard\\Runtimes\\ISSPPartner\\Derby_Ap ache_10.2.2.0\\database\\issp_Import_DdlUtils' not created, connection made to existing database instead. [ddlToDatabase] Created database [ddlToDatabase] Borrowed connection [EMAIL PROTECTED] from data source [ddlToDatabase] Table CASES needs to be added [ddlToDatabase] Table CASES_DATA needs to be added ... [ddlToDatabase] About to execute SQL CREATE TABLE CASES [ddlToDatabase] ( [ddlToDatabase] CASES_MODCID NUMERIC(10,0) NOT NULL, [ddlToDatabase] CASES_CASEID NUMERIC(10,0) NOT NULL, [ddlToDatabase] CASES_COM VARCHAR(2000), [ddlToDatabase] PRIMARY KEY (CASES_MODCID, CASES_CASEID) [ddlToDatabase] ) [ddlToDatabase] SQL Command CREATE TABLE CASES [ddlToDatabase] ( [ddlToDatabase] CASES_MODCID NUMERIC(10,0) NOT NULL, [ddlToDatabase] CASES_CASEID NUMERIC(10,0) NOT NULL, [ddlToDatabase] CASES_COM VARCHAR(2000), [ddlToDatabase] PRIMARY KEY (CASES_MODCID, CASES_CASEID) [ddlToDatabase] ) failed with: Table/View 'CASES' already exists in Schema 'APP'. [ddlToDatabase] java.sql.SQLException: Table/View 'CASES' already exists in Schema 'APP'. [ddlToDatabase] About to execute SQL CREATE TABLE CASES_DATA ... [ddlToDatabase] Executed 50 SQL command(s) with 50 error(s) [ddlToDatabase] Returning connection [EMAIL PROTECTED] to data source. [ddlToDatabase] Remaining connections: None [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: 7 seconds Could anyone help me? What should I change in my programm (build.xml, parameters etc.)? Thanks in advance 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/ -----------------------------------
