db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Laurent ROCHE <laurent_ro...@yahoo.com>
Subject Re : Tr : Still annoyed with identity
Date Wed, 24 Jan 2007 21:17:45 GMT

Yes, that's fixed !

But now when using a table with a foreign key on it-self all the rows with this (self)foreign-key
do not get inserted :
extract of error:
[ddlToDatabase]   equipments_on_vessels:equip_vess_id=18
[ddlToDatabase] Row visits:visit_id=51 is still not written because it depends on these yet
unwritten rows
[ddlToDatabase]   equipments_on_vessels:equip_vess_id=19
[ddlToDatabase] Row visits:visit_id=52 is still not written because it depends on these yet
unwritten rows
[ddlToDatabase]   equipments_on_vessels:equip_vess_id=20
[ddlToDatabase] Borrowed connection org.apache.commons.dbcp.PoolableConnection@73305c from
data source
[ddlToDatabase] Returning connection org.apache.commons.dbcp.PoolableConnection@73305c to
data source.
[ddlToDatabase] Remaining connections: None

C:\Projects\fims\trunk\sql\build.xml:51: org.apache.ddlutils.io.DataSinkException: There are
32 rows still not written
because of missing referenced rows
Tom, I will send you the schema.xml and data.xml off list, if you want to investigate again.


The Computing Froggy

----- Message d'origine ----
De : Thomas Dudziak <tomdzk@gmail.com>
À : ddlutils-user@db.apache.org
Envoyé le : Mardi, 23 Janvier 2007, 6h17mn 21s
Objet : Re: Tr : Still annoyed with identity

On 1/19/07, Laurent ROCHE <laurent_roche@yahoo.com> wrote:

> As you were kind enough to look at my problem last time, I am mailing you with another
test case.
> I thought the identity problem was solved (because the data went in), but the data are
still inserted with a generated ID no matter what value I set useexplicitidentityvalues to.

There was a small bug in the subtask itself that lead to the value for
useExplicitIdentityValues being ignored. I fixed this in SVN.



Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses


View raw message