cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tore Halset <hal...@pvv.ntnu.no>
Subject Re: DbGenerator vs. MergeContext
Date Tue, 26 Aug 2008 20:59:41 GMT
On Aug 26, 2008, at 22:39, Scott Anderson wrote:

> Moving this to the list, since it maybe useful to others-
>
> I have been poking around, and I think I've figured out how to use it.
> If I use DbGenerator, everything works great, but if I try to merge in
> changes from a slightly out of sync schema with DbMerger, it looks  
> like
> invalid SQL is generated.
>
> I'm using Derby with 3.0M4, and the relevant offending samples are:
>
> 1)
> Syntax error: Encountered "SET" at line 1, column 43.
> ALTER TABLE bnlogin ALTER COLUMN lastSeen SET NOT NULL

I think this one is fixed in trunk
http://issues.apache.org/cayenne/browse/CAY-1063

> 2)
> Foreign  Key 'SQL080826163049030' is invalid because 'The table cannot
> be defined as a dependent of table APP.ACCOUNT because of delete rule
> restrictions. (The relationship causes the table to be delete- 
> connected
> to the indicated table through multiple relationships and the delete
> rule of the existing relationship is SET NULL.).  '.
> ALTER TABLE mail ADD FOREIGN KEY (sentto) REFERENCES account (id)

Could you create a jira for this one?

> 3)
> Syntax error: Encountered "DROP" at line 1, column 39.
> ALTER TABLE rank ALTER COLUMN verbstr DROP NOT NULL

This one should also be fixed in trunk.

> Is it safe to assume that problems like this are a product of the
> package being incomplete, or is it indeed a bug?

It is not complete, but please report anything you find.

Regards,
  - Tore.


Mime
View raw message