MetaBossMetaBoss



Site Map
 

How to start with MetaBoss

So, you’ve read some papers on this site and think that you would like to try MetaBoss in action. Well, MetaBoss can be downloaded


free of charge, so there is nothing really to stop you from discovering MetaBoss further. Simply read and follow our installation instructions. 

Latest News

Thu Dec 15, 2005

This is minor bug fixes and feature enhancements release. The main change is the ability to place Message elements in the Data Dictionaries where they can be referenced by many Operations from unrelated Services. 

Tue Oct 25, 2005

This is the major feature enhancement release. The main new feature is the ability to model and generate support for events - the unsolicited asyncroneous messages produced by servers and consumed by clients.

Log In


 
If you are not a registered user, you can register now for free.
Forum

Code Generation And Programming Model

MySql & Constraints in AlmaMater

You have no permissions to create new topic   You have no permissions to post reply   Search

Author Message

Adjutant

Date:  Wed Feb 23, 2005 04:01 PM
Subject:  Re: MySql & Constraints in AlmaMater

For those, who are interested. The bug report is now on Sourcefoge.

Bug ID 1149503

Adjutant

Date:  Wed Feb 23, 2005 12:28 PM
Subject:  Re: MySql & Constraints in AlmaMater

JJS !

This does appear to be a bug. It occurs when entity association is an aggregation with cardinality of exactly one.

Please report this as a bug via Sourceforge.

Thank you

JJS

Date:  Wed Feb 23, 2005 02:22 AM
Subject:  MySql & Constraints in AlmaMater

The script DBScript_AlmaMaterJJS_CRS_Courses_CreateFromScratch.sql has an error for the following statement:

ALTER TABLE e_COURSE ADD CONSTRAINT fk_SUPERVISOR_FROM_COURSE_HAS_SUPERVISOR FOREIGN KEY (r_SUPERVISOR) REFERENCES e_TEACHER(recordid) ON DELETE SET NULL;

The MySQL Documentation 15.7.4 says:
If you specify a SET NULL action, make sure that you have not declared the columns in the child table as NOT NULL.
e_TEACHER(recordid) is defined as NOT NULL in:

CREATE TABLE e_TEACHER (recordid VARCHAR(40) CHECK (recordid IS NOT NULL AND LENGTH(recordid) >= 6),versionid BIGINT NOT NULL,FIRST_NAME VARCHAR(100) NOT NULL,SECOND_NAME VARCHAR(100),FAMILY_NAME VARCHAR(100) NOT NULL,CONSTRAINT pke_TEACHER PRIMARY KEY (recordid));

It makes sense when you think about it,

Display posts from previous:    Sort posts:    

 
Company | Contact Us | News | Documentation | Support | Downloads | Buy Now | FAQ | Forum