db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <..@Bonn.IZ-Soz.de>
Subject Using DdlUtils to Migrate Databases to Derby - Step 5 "Create Database and Import Schema and Data"
Date Tue, 23 Jan 2007 09:02:40 GMT
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
org.apache.commons.dbcp.PoolableConnection@131c89c 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
org.apache.commons.dbcp.PoolableConnection@131c89c to data source.
[ddlToDatabase] Remaining connections: None
[ddlToDatabase] Written schema to database
[ddlToDatabase] Borrowed connection
org.apache.commons.dbcp.PoolableConnection@131c89c 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: sm@bonn.iz-soz.de
http://www.gesis.org/IZ/  
----------------------------------- 

Mime
View raw message