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
[EMAIL PROTECTED]
=====================================================
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
