Menu
▾
▴
Re: [Wonder-disc] ERAttachment : table not created
|
From: Pascal R. <pr...@ma...> - 2010-04-20 09:31:26
|
Look like it's an issue only with H2, switching to MySQL do create the ERTag, ERAttachment and ERAttachementData tables.
> I'm working against ERExtensions, ERAttachment and ERTaggable source, checkout from yesterday morning. And my installed version of ERExtensions is from February 26, so not that old either.
>
>> is your wonder fairly recent? ERAttachmentMigration should declare that it has a dependency on ERAttachment, which should cause the dependency graph to put it first ...
>>
>> On Apr 18, 2010, at 9:18 AM, Pascal Robert wrote:
>>
>>> I'm trying to merge the work of Travis and the two Davids did for WOWODC East into ERMoviesLogic. One of the things that I'm merging is the use of ERTagggable and ERAttachment (to add a poster). So I moved the migration code to ERMoviesLogic, Movies0 extends ERTaggableEntity0, and Movies1 extends ERAttachmentMigration.
>>>
>>> public class Movies0 extends ERTaggableEntity0 {
>>> public Movies0() {
>>> super(Movie.ENTITY_NAME);
>>> }
>>> }
>>>
>>> public class Movies1 extends ERAttachmentMigration {
>>> public Movies1() {
>>> super("movie", "posterID", true);
>>> }
>>> }
>>>
>>> The migration works well for Movies0 (the MOVIETAG table is created) but Movies1 fails because it try to create the foreign key before creating the ERAttachment :
>>>
>>> avr. 18 09:07:42 Movies[60660] INFO er.extensions.jdbc.ERXJDBCUtilities - Executing ALTER TABLE movie ADD COLUMN posterID INTEGER
>>> avr. 18 09:07:42 Movies[60660] INFO er.extensions.jdbc.ERXJDBCUtilities - Executing ALTER TABLE movie ADD CONSTRAINT "FOREIGN_KEY_MOVIE_POSTERID_ERATTACHMENT_ID" FOREIGN KEY (posterID) REFERENCES ERAttachment (id)
>>> ...
>>> avr. 18 09:07:42 Movies[60660] ERROR er.extensions.appserver.ERXApplication - Movies failed to start.
>>> JdbcSQLException: Table "ERATTACHMENT" not found; SQL statement:
>>> ALTER TABLE movie ADD CONSTRAINT "FOREIGN_KEY_MOVIE_POSTERID_ERATTACHMENT_ID" FOREIGN KEY (posterID) REFERENCES ERAttachment (id) [42102-125]
>>>
>>> I didn't set er.migration.modelNames, so I tried with that too ("er.migration.modelNames=ERAttachment,ERTaggable,Movies"), no luck, same problem.
>>>
>>> --
>>>
>>> Pascal Robert
>>> pr...@ma...
>>>
>>> WOWODC 2010 : August 27th-29th, Montreal. wowodc.com
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Download Intel® Parallel Studio Eval
>>> Try the new software tools for yourself. Speed compiling, find bugs
>>> proactively, and fine-tune applications for parallel performance.
>>> See why Intel Parallel Studio got high marks during beta.
>>> http://p.sf.net/sfu/intel-sw-dev
>>> _______________________________________________
>>> Wonder-disc mailing list
>>> Won...@li...
>>> https://lists.sourceforge.net/lists/listinfo/wonder-disc
>>
>
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Wonder-disc mailing list
> Won...@li...
> https://lists.sourceforge.net/lists/listinfo/wonder-disc
|