Return-Path: 
 <ddlutils-user-return-849-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org
Received: (qmail 69402 invoked from network); 23 May 2008 07:59:15 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 23 May 2008 07:59:15 -0000
Received: (qmail 39926 invoked by uid 500); 23 May 2008 07:59:16 -0000
Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org
Received: (qmail 39909 invoked by uid 500); 23 May 2008 07:59:16 -0000
Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:ddlutils-user-help@db.apache.org>
List-Unsubscribe: <mailto:ddlutils-user-unsubscribe@db.apache.org>
List-Post: <mailto:ddlutils-user@db.apache.org>
List-Id: <ddlutils-user.db.apache.org>
Reply-To: ddlutils-user@db.apache.org
Delivered-To: mailing list ddlutils-user@db.apache.org
Received: (qmail 39898 invoked by uid 99); 23 May 2008 07:59:16 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 May 2008 00:59:16 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [88.198.38.107] (HELO mx4.synyx.de) (88.198.38.107)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 May 2008 07:58:21 +0000
Received: from localhost (localhost [127.0.0.1])
	by mx4.synyx.de (Postfix) with ESMTP id 6D34A10640A9
	for <ddlutils-user@db.apache.org>; Fri, 23 May 2008 09:58:43 +0200 (CEST)
Received: from mx4.synyx.de ([127.0.0.1])
	by localhost (synyx.de [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id Reg1NwQr+Tc0 for <ddlutils-user@db.apache.org>;
	Fri, 23 May 2008 09:58:43 +0200 (CEST)
Received: from [192.168.0.231]
 (HSI-KBW-091-089-242-118.hsi2.kabel-badenwuerttemberg.de [91.89.242.118])
	by mx4.synyx.de (Postfix) with ESMTP id 33BD410640A2
	for <ddlutils-user@db.apache.org>; Fri, 23 May 2008 09:58:43 +0200 (CEST)
Message-ID: <48367932.1080607@synyx.de>
Date: Fri, 23 May 2008 09:58:42 +0200
From: Markus Daniel <daniel@synyx.de>
User-Agent: Thunderbird 2.0.0.14 (X11/20080505)
MIME-Version: 1.0
To: ddlutils-user@db.apache.org
Subject: Re: DatabaseToDdl schemapattern -> writeDataToFile
References: <4832D9DA.9040908@synyx.de>
 <224f32340805210914p4194cf6n60cb0aba90682867@mail.gmail.com>
In-Reply-To: <224f32340805210914p4194cf6n60cb0aba90682867@mail.gmail.com>
X-Enigmail-Version: 0.95.6
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Checked: Checked by ClamAV on apache.org

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Tom,

Thomas Dudziak schrieb:
| On Tue, May 20, 2008 at 7:02 AM, Markus Daniel <daniel@synyx.de> wrote:
|
|> Hello,
|> I have a Oracle Database which contains ddl and data generated by
|> torque, now it is necessary to migrate these data to mysql.
|> Since torque is not the best tool to dump ddl and data and insert it in
|> an other database I try to use DdlUtils.
|>
|> <databaseToDdl schemapattern="MINOS" modelname="MINOS"
|> catalogpattern="MINOS">
|> ~    <database url="jdbc:oracle:thin:@192.168.0.82:1521:minos"
|> ~              driverClassName="oracle.jdbc.OracleDriver"
|> ~              username="minos"
|> ~              password="password"/>
|>
|> ~    <writeSchemaToFile outputFile="oracle-db-schema.xml"/>
|> ~    <writeDataToFile determineschema="true"
outputFile="oracle-data.xml"/>
|> ~  </databaseToDdl>
|>
|> The schema looks good but not tested at the moment.
|>
|> The dataDump failed with the message:
|> There are multiple columns with the name OBJ_TYPE in the table
KU_NOEXP_TAB
|>
|> This table is not in the schema MINOS it is in the schema system.
|>
|> Does "writeDataToFile" ignore the schemapattern or it there something
|> wrong with my ant target?
|
| DdlUtils shouldn't ignore the schemapattern. Have you tried this with
| determineschema='false' ?

yes, same result

<databaseToDdl schemapattern="MINOS" modelname="MINOS"
catalogpattern="MINOS">
~    <database url="jdbc:oracle:thin:@192.168.0.82:1521:minos"
~              driverClassName="oracle.jdbc.OracleDriver"
~              username="minos"
~              password="password"/>

~    <writeDataToFile determineschema="false" outputFile="oracle-data.xml"/>
~  </databaseToDdl>

BUILD FAILED
build.xml:16: There are multiple columns with the name OBJ_TYPE in the
table KU_NOEXP_TAB

The table KU_NOEXP_TAB is not in the schema minos it is in system...

Any ideas?

Thanks in advance,
Markus


- --
/**
~ * Markus Daniel
~ * Bachelor of Science
~ *
~ * Synyx GmbH & Co. KG
~ * OpenSource Solutions
~ * Karlstr. 68
~ * 76137 Karlsruhe
~ *
~ * phone +49(0)721 66 48 79 31
~ * fax   +49(0)721 66 48 877
~ * eMail markus.daniel@synyx.de
~ * www   http://www.synyx.de
~ * skype synyx_daniel
~ * irc   irc.synyx.de
~ *
~ * Sitz der Gesellschaft: Karlsruhe
~ * Registergericht: Mannheim
~ * Handelsregisternummer: HRA 4793
~ * USt-IdNr.: DE249264296
~ *
~ * Komplement�rin: Elatech Verwaltungs GmbH
~ * Sitz der Gesellschaft: Karlsruhe
~ * Gesch�ftsf�hrer: Markus Daniel
~ * Registergericht: Mannheim
~ * Handelsregisternummer: HRB 7250
~ */
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFINnkyA6KmbVkuXQkRApQMAKCDisN8m72/5PSD3gTq2RFDVI8ZPACg4pWc
azNym7GcltfzpSPd1ZRU+0c=
=ZKUu
-----END PGP SIGNATURE-----