From ddlutils-user-return-677-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org Tue Jul 31 16:04:08 2007 Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 95881 invoked from network); 31 Jul 2007 16:04:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 31 Jul 2007 16:04:07 -0000 Received: (qmail 36070 invoked by uid 500); 31 Jul 2007 16:04:03 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 36006 invoked by uid 500); 31 Jul 2007 16:04:02 -0000 Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-user@db.apache.org Delivered-To: mailing list ddlutils-user@db.apache.org Received: (qmail 35975 invoked by uid 99); 31 Jul 2007 16:04:02 -0000 Received: from Unknown (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2007 09:04:02 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of tomdzk@gmail.com designates 209.85.198.189 as permitted sender) Received: from [209.85.198.189] (HELO rv-out-0910.google.com) (209.85.198.189) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2007 16:03:57 +0000 Received: by rv-out-0910.google.com with SMTP id b22so567085rvf for ; Tue, 31 Jul 2007 09:03:37 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Q40LgAFrI8LzhCWdc9KPEliyOqkRmOTN2Iekn76vdSf4510Jz832+7Oufh7oqWui035uS+kQN9XUaKF/pdBIeEneKVjoR8gHhFpKjsJm0Lc1XwauzvhJ/ZHlLdWuUgo3bThLUKCT3phRNOD5L/NjfeJ1Ic1y8ZkpKyTZuTQvO2o= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=YbIdtAiyTx3fAh39CbmyPaEd6u9GoPS08r4VQSrcWmzenYgaeG7iol+S7KLe0eKtmDgmlshZJQ3TnA/ZmGWK+uqL02LuAHuVvEsP0G40DdLK4LWh10hd0gz9x3HjQ6wexNLD2lLq9GvZitPAQAGH4UQtrYy9ASiY6kqDiwG9FZY= Received: by 10.114.209.1 with SMTP id h1mr6853112wag.1185897816883; Tue, 31 Jul 2007 09:03:36 -0700 (PDT) Received: by 10.115.106.17 with HTTP; Tue, 31 Jul 2007 09:03:36 -0700 (PDT) Message-ID: <224f32340707310903y1cc7be5flc139f3de544b9b51@mail.gmail.com> Date: Tue, 31 Jul 2007 09:03:36 -0700 From: "Thomas Dudziak" To: ddlutils-user@db.apache.org Subject: Re: Error while Reading Model from Database In-Reply-To: <46AEE8C4.9020806@einsle.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46AEE8C4.9020806@einsle.de> X-Virus-Checked: Checked by ClamAV on apache.org On 7/31/07, Robert Einsle wrote: > DDL-Utils creates here an SQL-Statement: > > --- cut --- > SELECT FROM WHERE 1 = 0 > --- cut ... > > but i think, this is wrong, i muss the Database-Schema. The correct > Statement should be: > > --- cut --- > SELECT FROM .
WHERE 1 = 0 > --- cut ... > > I think, this is a Bug. DdlUtils does not fully support qualified table/sequence/... names (incl. the schema) yet. For now, you'll probably have to qualify them in the schema XML or, if all tables etc. are in the same schema which is corresponds to a user, access the db as this user. Tom