Return-Path: 
 <torque-user-return-5515-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 84833 invoked from network); 15 Nov 2004 21:13:17 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 15 Nov 2004 21:13:17 -0000
Received: (qmail 90009 invoked by uid 500); 15 Nov 2004 21:13:15 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 89991 invoked by uid 500); 15 Nov 2004 21:13:15 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 89974 invoked by uid 99); 15 Nov 2004 21:13:15 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from [140.172.175.99] (HELO lucky.ngdc.noaa.gov) (140.172.175.99)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 15 Nov 2004 13:13:15 -0800
Received: from noaa.gov (sente.ngdc.noaa.gov [192.149.148.114])
          by lucky.ngdc.noaa.gov (Netscape Messaging Server 4.15) with
          ESMTP id I78OHV00.G74 for <torque-user@db.apache.org>; Mon, 15
          Nov 2004 14:17:55 -0700
Message-ID: <41991BE9.7090609@noaa.gov>
Date: Mon, 15 Nov 2004 14:13:13 -0700
From: "Kris Nuttycombe" <Kris.Nuttycombe@noaa.gov>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.3) Gecko/20040924
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Apache Torque Users List <torque-user@db.apache.org>
Subject: Re: Key problems - Torque 3.1.1
References: <41990925.4030501@noaa.gov>
 <1100549643.6051.9.camel@guy.guardium.com> <41991AD9.90608@noaa.gov>
In-Reply-To: <41991AD9.90608@noaa.gov>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

A minor update - I dropped the default from the id column just to be 
sure and it didn't change the behavior.

Kris Nuttycombe wrote:

> Unfortunately, I don't think that's the issue. It was one of my first 
> thoughts, as well. Here's the desc of the table:
>
> mysql> desc data_info;
> +----------------+---------------+------+-----+---------+-------+
> | Field          | Type          | Null | Key | Default | Extra |
> +----------------+---------------+------+-----+---------+-------+
> | id             | int(11)       |      | PRI | 0       |       |
> | title          | varchar(100)  | YES  |     | NULL    |       |
> | data_source_id | int(11)       |      |     | 0       |       |
> | fgdc_number    | varchar(24)   | YES  |     | NULL    |       |
> | last_update    | timestamp(14) | YES  |     | NULL    |       |
> +----------------+---------------+------+-----+---------+-------+
> 5 rows in set (0.00 sec)
>
> And my schema.xml entry is listed below, from my initial post.
>
> Could it be the default value that's throwing it off?
>
> Kris
>
> Guy Galil wrote:
>
>> I think the problem is with the id being an auto increment column - if u
>> set it to be autoIncrement="false" on the target database then you will
>> be able to put the correct value in there.
>> Guy
>>
>
>> On Mon, 2004-11-15 at 14:53, Kris Nuttycombe wrote:
>>  
>>
>>> <snip/>
>>>
>>> According to the log, the destination data_info entry looks right. 
>>> Here's the schema.xml entry for the data_info table:
>>>
>>>    <table name="data_info">
>>>        <column name="id" type="INTEGER" primaryKey="true" 
>>> required="true"/>
>>>        <column name="title" size="100" type="VARCHAR"/>
>>>        <column name="data_source_id" required="true" type="INTEGER"/>
>>>        <column name="fgdc_number" size="24" type="VARCHAR"/>
>>>        <column name="last_update" type="TIMESTAMP"/>
>>>              <foreign-key foreignTable="data_source">
>>>            <reference local="data_source_id" foreign="id"/>
>>>        </foreign-key>
>>>    </table>
>>>
>>>   
>>
>

-- 
=====================================================
Kris Nuttycombe
Associate Scientist
Geospatial Data Services Group
CIRES, National Geophysical Data Center/NOAA
(303) 497-6337
Kris.Nuttycombe@noaa.gov
=====================================================



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org