Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 62412 invoked from network); 24 Jun 2006 09:05:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 24 Jun 2006 09:05:12 -0000 Received: (qmail 12213 invoked by uid 500); 24 Jun 2006 09:05:12 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 12176 invoked by uid 500); 24 Jun 2006 09:05:11 -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 12165 invoked by uid 99); 24 Jun 2006 09:05:11 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 24 Jun 2006 02:05:11 -0700 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=DNS_FROM_RFC_ABUSE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of tomdzk@gmail.com designates 66.249.92.169 as permitted sender) Received: from [66.249.92.169] (HELO ug-out-1314.google.com) (66.249.92.169) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 24 Jun 2006 02:05:11 -0700 Received: by ug-out-1314.google.com with SMTP id m3so210184uge for ; Sat, 24 Jun 2006 02:04:47 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=S8CZIvHUrd0hXmSV+YxrJGgDdzEfasXMOt0HwLr47KiKb8oHDO/L+5jkRdSQWisegzkwfepa6D9MwBgxClHcKF0/MMlepOKGVlJt0snOS5HhAhKLViFmMy9Zap7LJAQubQiE3aNHROV1c+ssCQuHagVLlo/7wuXicoTDzQU4unw= Received: by 10.67.29.12 with SMTP id g12mr3102263ugj; Sat, 24 Jun 2006 02:04:47 -0700 (PDT) Received: by 10.67.95.19 with HTTP; Sat, 24 Jun 2006 02:04:47 -0700 (PDT) Message-ID: <224f32340606240204i3641d4f7tc00f2429643a4b33@mail.gmail.com> Date: Sat, 24 Jun 2006 11:04:47 +0200 From: "Thomas Dudziak" To: ddlutils-user@db.apache.org Subject: Re: Exceptions when using DdlUtils and Platform.readModelFromDatabase() In-Reply-To: <20060623114115.40AF.SHAUN@shaunc.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <224f32340606230834vb8eac0aw1a9c856280046038@mail.gmail.com> <20060623110323.40A9.SHAUN@shaunc.com> <20060623114115.40AF.SHAUN@shaunc.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On 6/23/06, Shaun wrote: > On Fri, 23 Jun 2006 11:24:50 -0500 > Shaun wrote: > > > Exception in thread "main" org.apache.ddlutils.DynaSqlException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'Zip'. > > at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1706) > > Actually, this boils down to the same problem as the other exception. > The column name is [Zip Code], not Zip (threw me off because we do have > tables with a column named Zip), and the brackets are being stripped > there, too. > > Apologies to the list - it appears this was not a DdlUtils issue. Actually, your database uses delimited identifiers (http://msdn2.microsoft.com/en-us/library/ms176027.aspx). So, in order to properly read the database with DdlUtils, you must turn on delimited identifiers support via the corresponding useDelimitedSqlIdentifiers attribute of the Ant task (http://db.apache.org/ddlutils/ant-tasks.html#DdlToDatabaseTask+reference). Tom