Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » [Teneo] Error in table creation, unusual table names
[Teneo] Error in table creation, unusual table names [message #111881] Thu, 07 February 2008 15:25 Go to next message
David Wynter is currently offline David WynterFriend
Messages: 4624
Registered: July 2009
Senior Member
Still getting errors of this kind

424813 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
Unsuccessful: alter table `dtrmntnsrc_dtrmintinsrcchildrn` add index
determintinsrce_mrketstatstype (`dtrmntinsrcchildrn_mrktsttstyp`), add
constraint determintinsrce_mrketstatstype foreign key
(`dtrmntinsrcchildrn_mrktsttstyp`) references `marketstatustype` (`id`)
424813 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Can't
create table 'gensec.#sql-55c_12c' (errno: 121)

David
Re: [Teneo] Error in table creation, unusual table names [message #111882 is a reply to message #111881] Thu, 07 February 2008 15:44 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hmm, according to some mysql forum error 121 is this:
errno 121 means a duplicate key error. Probably the table already exists in the InnoDB internal data
dictionary, though the .frm file for the table has been deleted. This is the most common reason for
getting errno 121 in table creation. Another possible reason is a name conflict in a foreign key
constraint name. Constraint names must be unique in a database, like table names are.

So this can be a nameclash, can you try the following setting:
SET_FOREIGN_KEY_NAME to false

gr. Martin

david wrote:
> Still getting errors of this kind
>
> 424813 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Unsuccessful: alter table `dtrmntnsrc_dtrmintinsrcchildrn` add index
> determintinsrce_mrketstatstype (`dtrmntinsrcchildrn_mrktsttstyp`), add
> constraint determintinsrce_mrketstatstype foreign key
> (`dtrmntinsrcchildrn_mrktsttstyp`) references `marketstatustype` (`id`)
> 424813 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Can't
> create table 'gensec.#sql-55c_12c' (errno: 121)
>
> David


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
Re: [Teneo] Error in table creation, unusual table names [message #615432 is a reply to message #111881] Thu, 07 February 2008 15:44 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hmm, according to some mysql forum error 121 is this:
errno 121 means a duplicate key error. Probably the table already exists in the InnoDB internal data
dictionary, though the .frm file for the table has been deleted. This is the most common reason for
getting errno 121 in table creation. Another possible reason is a name conflict in a foreign key
constraint name. Constraint names must be unique in a database, like table names are.

So this can be a nameclash, can you try the following setting:
SET_FOREIGN_KEY_NAME to false

gr. Martin

david wrote:
> Still getting errors of this kind
>
> 424813 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Unsuccessful: alter table `dtrmntnsrc_dtrmintinsrcchildrn` add index
> determintinsrce_mrketstatstype (`dtrmntinsrcchildrn_mrktsttstyp`), add
> constraint determintinsrce_mrketstatstype foreign key
> (`dtrmntinsrcchildrn_mrktsttstyp`) references `marketstatustype` (`id`)
> 424813 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Can't
> create table 'gensec.#sql-55c_12c' (errno: 121)
>
> David


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
Previous Topic:[Teneo] Error in table creation, unusual table names
Next Topic:[EMF Compare] version number for EMF 2.3
Goto Forum:
  


Current Time: Thu Sep 24 06:30:55 GMT 2020

Powered by FUDForum. Page generated in 0.01963 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top