Return-Path: 
 <ddlutils-user-return-149-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org
Received: (qmail 65490 invoked from network); 9 Feb 2006 02:46:47 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 9 Feb 2006 02:46:47 -0000
Received: (qmail 1399 invoked by uid 500); 9 Feb 2006 02:46:47 -0000
Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org
Received: (qmail 1342 invoked by uid 500); 9 Feb 2006 02:46:46 -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 1330 invoked by uid 99); 9 Feb 2006 02:46:46 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Feb 2006 18:46:46 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of allanjunli@gmail.com designates
 64.233.184.205 as permitted sender)
Received: from [64.233.184.205] (HELO wproxy.gmail.com) (64.233.184.205)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Feb 2006 18:46:45 -0800
Received: by wproxy.gmail.com with SMTP id 69so8886wra
        for <ddlutils-user@db.apache.org>;
 Wed, 08 Feb 2006 18:46:24 -0800 (PST)
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:references;
        b=U9UlnFsNz0ugSigPMAK0e29qvuGsUoqSjPDoQEVzGbU2tw57SMlp49Grinrf72GeGBAOyh5cbY/oz4NXxBrEp7lQh9IPmtKJ1vne8ffMOnNXQFHiLR+eU1jTKx3mTbeCDeJsiElq5CCWLwhzxTO4xdywHIw7Z58qMOzh2KZgm5g=
Received: by 10.65.241.11 with SMTP id t11mr427397qbr;
        Wed, 08 Feb 2006 18:46:24 -0800 (PST)
Received: by 10.65.121.19 with HTTP; Wed, 8 Feb 2006 18:46:24 -0800 (PST)
Message-ID: <e84303e30602081846n15981dccp303d7f9796ca2572@mail.gmail.com>
Date: Thu, 9 Feb 2006 13:46:24 +1100
From: Jun Li <allanjunli@gmail.com>
To: ddlutils-user@db.apache.org
Subject: Re: Problem with reading XML.
In-Reply-To: <224f32340602081546x76311a62uf16227c05447756b@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_13471_13384669.1139453184474"
References: <e84303e30602072057o48dd176fvebcb16a0c6932dbb@mail.gmail.com>
	 <224f32340602080004n3ef26f38wa3872104e368f8a9@mail.gmail.com>
	 <e84303e30602081531l76c7548fva6cbc03739c1e4e3@mail.gmail.com>
	 <224f32340602081546x76311a62uf16227c05447756b@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_13471_13384669.1139453184474
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Good. Now it works. However the new problem is, the databases are not
identical. I mean the database generated from the XML file has some
differences with the database which generates the XML file. I found the
difference simply by comparing the XML file.

The part of the original XML file.
    <table name=3D"Accrual">
      <column name=3D"AccrualID" primaryKey=3D"true" required=3D"true"
type=3D"NUMERIC" size=3D"8" autoIncrement=3D"false"/>
      <column name=3D"PeriodFK" primaryKey=3D"false" required=3D"true"
type=3D"NUMERIC" size=3D"8" autoIncrement=3D"false"/>
      <column name=3D"FileName" primaryKey=3D"false" required=3D"true"
type=3D"VARCHAR" size=3D"50" autoIncrement=3D"false"/>
      <column name=3D"AccruedByFK" primaryKey=3D"false" required=3D"true"
type=3D"NUMERIC" size=3D"8" autoIncrement=3D"false"/>
      <column name=3D"AccruedOn" primaryKey=3D"false" required=3D"true"
type=3D"TIMESTAMP" size=3D"23" autoIncrement=3D"false"/>
      <foreign-key foreignTable=3D"Employee" name=3D"FK_Accrual_Employee">
        <reference local=3D"AccruedByFK" foreign=3D"EmployeeID"/>
      </foreign-key>
      <foreign-key foreignTable=3D"Period" name=3D"FK_Accrual_Period">
        <reference local=3D"PeriodFK" foreign=3D"PeriodID"/>
      </foreign-key>
      <unique name=3D"PK_Accrual">
        <unique-column name=3D"AccrualID"/>
      </unique>
      <index name=3D"IX_Accrual_Employee">
        <index-column name=3D"AccruedByFK"/>
      </index>
      <index name=3D"IX_Accrual_Period">
        <index-column name=3D"PeriodFK"/>
      </index>
    </table>

The new XML file generated from the new database which creates from the
above XML file.

    <table name=3D"Accrual">
      <column name=3D"AccrualID" primaryKey=3D"true" required=3D"true"
type=3D"NUMERIC" size=3D"8" autoIncrement=3D"false"/>
      <column name=3D"PeriodFK" primaryKey=3D"false" required=3D"true"
type=3D"NUMERIC" size=3D"8" autoIncrement=3D"false"/>
      <column name=3D"FileName" primaryKey=3D"false" required=3D"true"
type=3D"VARCHAR" size=3D"50" autoIncrement=3D"false"/>
      <column name=3D"AccruedByFK" primaryKey=3D"false" required=3D"true"
type=3D"NUMERIC" size=3D"8" autoIncrement=3D"false"/>
      <column name=3D"AccruedOn" primaryKey=3D"false" required=3D"true"
type=3D"TIMESTAMP" size=3D"23" autoIncrement=3D"false"/>
      <foreign-key foreignTable=3D"Employee" name=3D"FK_Accrual_Employee">
        <reference local=3D"AccruedByFK" foreign=3D"EmployeeID"/>
      </foreign-key>
      <foreign-key foreignTable=3D"Period" name=3D"FK_Accrual_Period">
        <reference local=3D"PeriodFK" foreign=3D"PeriodID"/>
      </foreign-key>
      <unique name=3D"PK__Accrual__379B24DB">
        <unique-column name=3D"AccrualID"/>
      </unique>
      <unique name=3D"PK_Accrual">
        <unique-column name=3D"AccrualID"/>
      </unique>
      <index name=3D"IX_Accrual_Employee">
        <index-column name=3D"AccruedByFK"/>
      </index>
      <index name=3D"IX_Accrual_Period">
        <index-column name=3D"PeriodFK"/>
      </index>
    </table>

Look at the hightlighted part. It happened to every table in the database. =
A
newly added unique constraint.



On 2/9/06, Thomas Dudziak <tomdzk@gmail.com> wrote:
>
> On 2/9/06, Jun Li <allanjunli@gmail.com> wrote:
>
> > OK, Here is the info.
>
> <snip>
>
> > Here are the exceptions:
> >
> > ........
> >
> > 9/02/2006 09:57:04 org.apache.commons.betwixt.expression.ContextpopOpti=
ons
> >
> > INFO: Cannot pop options off empty stack
>
>
> You seem to be running an older version of DdlUtils (this particular
> INFO message comes from an older commons-betwixt version which we
> replaced a couple of weeks ago).
> Could you update DdlUtils to newest SVN and try again ?
>
> Tom
>

------=_Part_13471_13384669.1139453184474--