Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » [Teneo] Create table fails in Integration Build I200704230019
[Teneo] Create table fails in Integration Build I200704230019 [message #86732] Mon, 18 June 2007 14:24 Go to next message
Eclipse UserFriend
Originally posted by: bsu.bergauer.ch

Hello Martin,

Maybe this could be of any help to you...?

I upgraded my development enviroment from Eclipse 3.3M5 to Eclipse 3.3RC3
today. As I anyway was retrieving newer builds I thought I might as well
update Teneo. Until now I have successfully been using Integration Build
I200702130950. Now I downloaded and installed Integration Build
I200704230019.

As I started up a new project (where a new Derby database gets created) I
encountered the following problem while creating the tables:

[start extract console log]
....
10594 [ModalContext] DEBUG org.hibernate.tool.hbm2ddl.SchemaUpdate - create
table "connectable" ("id" integer not null unique, "dtype" varchar(255) not
null, "version" integer not null, "name" varchar(255),
"environment_connectables_id" integer, "environment_connectables_idx"
integer, econtainer_class varchar(255), e_container varchar(255),
e_container_featureid integer, primary key ("id")) (SchemaUpdate.java:149)
10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
Unsuccessful: create table "connectable" ("id" integer not null unique,
"dtype" varchar(255) not null, "version" integer not null, "name"
varchar(255), "environment_connectables_id" integer,
"environment_connectables_idx" integer, econtainer_class varchar(255),
e_container varchar(255), e_container_featureid integer, primary key ("id"))
(SchemaUpdate.java:155)
10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
Constraints 'SQL070618024717651' and 'SQL070618024717650' have the same set
of columns, which is not allowed. (SchemaUpdate.java:156)
10625 [ModalContext] DEBUG org.hibernate.tool.hbm2ddl.SchemaUpdate - create
table "connection" ("id" integer not null unique, "dtype" varchar(255) not
null, "version" integer not null, "connectable_source_id" integer,
"connectable_target_id" integer, "description" varchar(255), "port" integer,
"connectable_connections_id" integer, "connectable_connections_idx" integer,
econtainer_class varchar(255), e_container varchar(255), e_container_feature
id integer, primary key ("id")) (SchemaUpdate.java:149)
10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
Unsuccessful: create table "connection" ("id" integer not null unique,
"dtype" varchar(255) not null, "version" integer not null,
"connectable_source_id" integer, "connectable_target_id" integer,
"description" varchar(255), "port" integer, "connectable_connections_id"
integer, "connectable_connections_idx" integer, econtainer_class
varchar(255), e_container varchar(255), e_container_featureid integer,
primary key ("id")) (SchemaUpdate.java:155)
10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
Constraints 'SQL070618024717671' and 'SQL070618024717670' have the same set
of columns, which is not allowed. (SchemaUpdate.java:156)
....
[end extract console log]

Needless to say, the application failed to start, so I used Integration
Build I200702130950 again, and the application started as expected.

Attached you will find both console logs. I used the same model and
generated code and tested this both with code that was generated before and
after upgrading EMF and Teneo.

It is basically no problem for me, as I can continue to use Integration
Build I200702130950, but it might indicate that something has got broken?

Kind regards
Bjoern


Re: [Teneo] Create table fails in Integration Build I200704230019 [message #86752 is a reply to message #86732] Mon, 18 June 2007 21:10 Go to previous messageGo to next message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Björn,
Some questions:
Can you see which columns are present in the constraints of which the creation fails?

Can you also post the mapping of the "connection" type?

gr. Maritn

Björn Sundin wrote:
> Hello Martin,
>
> Maybe this could be of any help to you...?
>
> I upgraded my development enviroment from Eclipse 3.3M5 to Eclipse 3.3RC3
> today. As I anyway was retrieving newer builds I thought I might as well
> update Teneo. Until now I have successfully been using Integration Build
> I200702130950. Now I downloaded and installed Integration Build
> I200704230019.
>
> As I started up a new project (where a new Derby database gets created) I
> encountered the following problem while creating the tables:
>
> [start extract console log]
> ....
> 10594 [ModalContext] DEBUG org.hibernate.tool.hbm2ddl.SchemaUpdate - create
> table "connectable" ("id" integer not null unique, "dtype" varchar(255) not
> null, "version" integer not null, "name" varchar(255),
> "environment_connectables_id" integer, "environment_connectables_idx"
> integer, econtainer_class varchar(255), e_container varchar(255),
> e_container_featureid integer, primary key ("id")) (SchemaUpdate.java:149)
> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Unsuccessful: create table "connectable" ("id" integer not null unique,
> "dtype" varchar(255) not null, "version" integer not null, "name"
> varchar(255), "environment_connectables_id" integer,
> "environment_connectables_idx" integer, econtainer_class varchar(255),
> e_container varchar(255), e_container_featureid integer, primary key ("id"))
> (SchemaUpdate.java:155)
> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Constraints 'SQL070618024717651' and 'SQL070618024717650' have the same set
> of columns, which is not allowed. (SchemaUpdate.java:156)
> 10625 [ModalContext] DEBUG org.hibernate.tool.hbm2ddl.SchemaUpdate - create
> table "connection" ("id" integer not null unique, "dtype" varchar(255) not
> null, "version" integer not null, "connectable_source_id" integer,
> "connectable_target_id" integer, "description" varchar(255), "port" integer,
> "connectable_connections_id" integer, "connectable_connections_idx" integer,
> econtainer_class varchar(255), e_container varchar(255), e_container_feature
> id integer, primary key ("id")) (SchemaUpdate.java:149)
> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Unsuccessful: create table "connection" ("id" integer not null unique,
> "dtype" varchar(255) not null, "version" integer not null,
> "connectable_source_id" integer, "connectable_target_id" integer,
> "description" varchar(255), "port" integer, "connectable_connections_id"
> integer, "connectable_connections_idx" integer, econtainer_class
> varchar(255), e_container varchar(255), e_container_featureid integer,
> primary key ("id")) (SchemaUpdate.java:155)
> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Constraints 'SQL070618024717671' and 'SQL070618024717670' have the same set
> of columns, which is not allowed. (SchemaUpdate.java:156)
> ....
> [end extract console log]
>
> Needless to say, the application failed to start, so I used Integration
> Build I200702130950 again, and the application started as expected.
>
> Attached you will find both console logs. I used the same model and
> generated code and tested this both with code that was generated before and
> after upgrading EMF and Teneo.
>
> It is basically no problem for me, as I can continue to use Integration
> Build I200702130950, but it might indicate that something has got broken?
>
> Kind regards
> Bjoern
>
>


--

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] Create table fails in Integration Build I200704230019 [message #86827 is a reply to message #86752] Wed, 20 June 2007 08:50 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: bsu.bergauer.ch

Hi Martin

As far as I can see does this error occur for those tables where I don't use
a synthetic id.

I have defined a DataType AmsetId:

<eClassifiers xsi:type="ecore:EDataType" name="AmsetId"
instanceClassName="int">
<eAnnotations source="teneo.jpa">
<details key="appinfo" value="@Id
@GeneratedValue(strategy=&quot;AUTO&quot;)"/>
</eAnnotations>
</eClassifiers>

This DataType is used in i.e. Connectable:

<eClassifiers xsi:type="ecore:EClass" name="Connectable"
abstract="true">
<eStructuralFeatures xsi:type="ecore:EAttribute" name="name"
eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString"/>
<eStructuralFeatures xsi:type="ecore:EReference" name="connections"
upperBound="-1"
eType="#//Connection" containment="true"/>
<eStructuralFeatures xsi:type="ecore:EAttribute" name="id"
unique="false" eType="ecore:EDataType
.../../ch.bergauer.rcp.amset.system.attributes/model/systemd atatypes.ecore#//
AmsetId"
iD="true"/>
<eStructuralFeatures xsi:type="ecore:EAttribute" name="version"
eType="ecore:EDataType
.../../ch.bergauer.rcp.amset.system.attributes/model/systemd atatypes.ecore#//
AmsetVersion"/>
</eClassifiers>

The exception is thrown by the
org.apache.derby.impl.sql.compile.TableElementList.validate( DDLStatementNode
ddlStmt, DataDictionary dd, TableDescriptor td) method:

      //check if there are multiple constraints with same set of columns
      if (columnsMatch(cdn.getColumnList().getColumnNames(),
destColumnNames))
          throw
StandardException.newException(SQLState.LANG_MULTIPLE_CONSTRAINTS_WITH_SAME_
COLUMNS,
                  cdn.getConstraintMoniker(), destName);


The parameters in columnsMatch have the following values:
cdn.getColumnList().getColumnNames(): (java.lang.String[]) [id]
destColumnNames: (java.lang.String[]) [id]

The DDLStatementNode parameters in TableElementList.validate looks like
this:


connectablestatementType: CREATE TABLE
tableElementList:
constraintName: null
constraintType: 3
properties: null
name: SQL070620101614670

dataTypeServices: INTEGER NOT NULL
defaultValue: null
name: id

dataTypeServices: VARCHAR(255) NOT NULL
defaultValue: null
name: dtype

dataTypeServices: INTEGER NOT NULL
defaultValue: null
name: version

dataTypeServices: VARCHAR(255)
defaultValue: null
name: name

dataTypeServices: INTEGER
defaultValue: null
name: environment_connectables_id

dataTypeServices: INTEGER
defaultValue: null
name: environment_connectables_idx

dataTypeServices: VARCHAR(255)
defaultValue: null
name: ECONTAINER_CLASS

dataTypeServices: VARCHAR(255)
defaultValue: null
name: E_CONTAINER

dataTypeServices: INTEGER
defaultValue: null
name: E_CONTAINER_FEATUREID

constraintName: null
constraintType: 2
properties: null
name: SQL070620102737810


properties:
null
lockGranularity:
R
[/ddlStmt]

Regards
Bj
Re: [Teneo] Create table fails in Integration Build I200704230019 [message #86861 is a reply to message #86827] Wed, 20 June 2007 12:53 Go to previous messageGo to next message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Bjorn,
And how does the hbm look like for the Connectable class?

gr. Martin

Björn Sundin wrote:
> Hi Martin
>
> As far as I can see does this error occur for those tables where I don't use
> a synthetic id.
>
> I have defined a DataType AmsetId:
>
> <eClassifiers xsi:type="ecore:EDataType" name="AmsetId"
> instanceClassName="int">
> <eAnnotations source="teneo.jpa">
> <details key="appinfo" value="@Id
> @GeneratedValue(strategy=&quot;AUTO&quot;)"/>
> </eAnnotations>
> </eClassifiers>
>
> This DataType is used in i.e. Connectable:
>
> <eClassifiers xsi:type="ecore:EClass" name="Connectable"
> abstract="true">
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="name"
> eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString"/>
> <eStructuralFeatures xsi:type="ecore:EReference" name="connections"
> upperBound="-1"
> eType="#//Connection" containment="true"/>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="id"
> unique="false" eType="ecore:EDataType
> .../../ch.bergauer.rcp.amset.system.attributes/model/systemd atatypes.ecore#//
> AmsetId"
> iD="true"/>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="version"
> eType="ecore:EDataType
> .../../ch.bergauer.rcp.amset.system.attributes/model/systemd atatypes.ecore#//
> AmsetVersion"/>
> </eClassifiers>
>
> The exception is thrown by the
> org.apache.derby.impl.sql.compile.TableElementList.validate( DDLStatementNode
> ddlStmt, DataDictionary dd, TableDescriptor td) method:
>
>
>       //check if there are multiple constraints with same set of columns
>       if (columnsMatch(cdn.getColumnList().getColumnNames(),
> destColumnNames))
>           throw
> StandardException.newException(SQLState.LANG_MULTIPLE_CONSTRAINTS_WITH_SAME_
> COLUMNS,
>                   cdn.getConstraintMoniker(), destName);
> 

>
> The parameters in columnsMatch have the following values:
> cdn.getColumnList().getColumnNames(): (java.lang.String[]) [id]
> destColumnNames: (java.lang.String[]) [id]
>
> The DDLStatementNode parameters in TableElementList.validate looks like
> this:
>
>
> connectablestatementType: CREATE TABLE
> tableElementList:
> constraintName: null
> constraintType: 3
> properties: null
> name: SQL070620101614670
>
> dataTypeServices: INTEGER NOT NULL
> defaultValue: null
> name: id
>
> dataTypeServices: VARCHAR(255) NOT NULL
> defaultValue: null
> name: dtype
>
> dataTypeServices: INTEGER NOT NULL
> defaultValue: null
> name: version
>
> dataTypeServices: VARCHAR(255)
> defaultValue: null
> name: name
>
> dataTypeServices: INTEGER
> defaultValue: null
> name: environment_connectables_id
>
> dataTypeServices: INTEGER
> defaultValue: null
> name: environment_connectables_idx
>
> dataTypeServices: VARCHAR(255)
> defaultValue: null
> name: ECONTAINER_CLASS
>
> dataTypeServices: VARCHAR(255)
> defaultValue: null
> name: E_CONTAINER
>
> dataTypeServices: INTEGER
> defaultValue: null
> name: E_CONTAINER_FEATUREID
>
> constraintName: null
> constraintType: 2
> properties: null
> name: SQL070620102737810
>
>
> properties:
> null
> lockGranularity:
> R
> [/ddlStmt]
>
> Regards
> Björn
>
> "Martin Taal" <mtaal@elver.org> schrieb im Newsbeitrag
> news:f56sc0$eml$1@build.eclipse.org...
>> Hi Björn,
>> Some questions:
>> Can you see which columns are present in the constraints of which the
> creation fails?
>> Can you also post the mapping of the "connection" type?
>>
>> gr. Maritn
>>
>> Björn Sundin wrote:
>>> Hello Martin,
>>>
>>> Maybe this could be of any help to you...?
>>>
>>> I upgraded my development enviroment from Eclipse 3.3M5 to Eclipse
> 3.3RC3
>>> today. As I anyway was retrieving newer builds I thought I might as
> well
>>> update Teneo. Until now I have successfully been using Integration Build
>>> I200702130950. Now I downloaded and installed Integration Build
>>> I200704230019.
>>>
>>> As I started up a new project (where a new Derby database gets created)
> I
>>> encountered the following problem while creating the tables:
>>>
>>> [start extract console log]
>>> ....
>>> 10594 [ModalContext] DEBUG org.hibernate.tool.hbm2ddl.SchemaUpdate -
> create
>>> table "connectable" ("id" integer not null unique, "dtype" varchar(255)
> not
>>> null, "version" integer not null, "name" varchar(255),
>>> "environment_connectables_id" integer, "environment_connectables_idx"
>>> integer, econtainer_class varchar(255), e_container varchar(255),
>>> e_container_featureid integer, primary key ("id"))
> (SchemaUpdate.java:149)
>>> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
>>> Unsuccessful: create table "connectable" ("id" integer not null unique,
>>> "dtype" varchar(255) not null, "version" integer not null, "name"
>>> varchar(255), "environment_connectables_id" integer,
>>> "environment_connectables_idx" integer, econtainer_class varchar(255),
>>> e_container varchar(255), e_container_featureid integer, primary key
> ("id"))
>>> (SchemaUpdate.java:155)
>>> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
>>> Constraints 'SQL070618024717651' and 'SQL070618024717650' have the same
> set
>>> of columns, which is not allowed. (SchemaUpdate.java:156)
>>> 10625 [ModalContext] DEBUG org.hibernate.tool.hbm2ddl.SchemaUpdate -
> create
>>> table "connection" ("id" integer not null unique, "dtype" varchar(255)
> not
>>> null, "version" integer not null, "connectable_source_id" integer,
>>> "connectable_target_id" integer, "description" varchar(255), "port"
> integer,
>>> "connectable_connections_id" integer, "connectable_connections_idx"
> integer,
>>> econtainer_class varchar(255), e_container varchar(255),
> e_container_feature
>>> id integer, primary key ("id")) (SchemaUpdate.java:149)
>>> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
>>> Unsuccessful: create table "connection" ("id" integer not null unique,
>>> "dtype" varchar(255) not null, "version" integer not null,
>>> "connectable_source_id" integer, "connectable_target_id" integer,
>>> "description" varchar(255), "port" integer, "connectable_connections_id"
>>> integer, "connectable_connections_idx" integer, econtainer_class
>>> varchar(255), e_container varchar(255), e_container_featureid integer,
>>> primary key ("id")) (SchemaUpdate.java:155)
>>> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
>>> Constraints 'SQL070618024717671' and 'SQL070618024717670' have the same
> set
>>> of columns, which is not allowed. (SchemaUpdate.java:156)
>>> ....
>>> [end extract console log]
>>>
>>> Needless to say, the application failed to start, so I used Integration
>>> Build I200702130950 again, and the application started as expected.
>>>
>>> Attached you will find both console logs. I used the same model and
>>> generated code and tested this both with code that was generated before
> and
>>> after upgrading EMF and Teneo.
>>>
>>> It is basically no problem for me, as I can continue to use Integration
>>> Build I200702130950, but it might indicate that something has got
> broken?
>>> Kind regards
>>> Bjoern
>>>
>>>
>>
>> --
>>
>> 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
>
>


--

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] Create table fails in Integration Build I200704230019 [message #86904 is a reply to message #86861] Wed, 20 June 2007 15:20 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: bsu.bergauer.ch

Hi Martin,

The hbm for the Connectable class looks like this:

<class
name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Connecta bleImpl "
entity-name="Connectable" abstract="true" lazy="false"
discriminator-value="Connectable" table="`connectable`">
<meta attribute="eclassName">Connectable</meta>
<meta
attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
<id name="id" type="int">
<column not-null="true" unique="true" name="`id`"/>
<generator class="native"/>
</id>
<discriminator column="`dtype`" type="string"/>
<version name="version" type="int">
<column not-null="true" unique="false" name="`version`"/>
</version>
<property name="name" lazy="false" insert="true" update="true"
not-null="false" unique="false" type="java.lang.String">
<column not-null="false" unique="false" name="`name`"/>
</property>
<list name="connections" lazy="true"
cascade="delete,merge,persist,save-update,lock,refresh">
<key update="true">
<column name="`connectable_connections_id`" not-null="false"
unique="false"/>
</key>
<list-index column="`connectable_connections_idx`"/>
<one-to-many entity-name="Connection"/>
</list>
</class>

In the two console output files I sent as attachment in the first post you
can see the complete hbm mapping (generated in memory).

Regards
Bj
Re: [Teneo] Create table fails in Integration Build I200704230019 [message #92885 is a reply to message #86904] Thu, 09 August 2007 14:19 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: bsu.bergauer.ch

Hi Martin,

I think I have pinned down the problem that I (still) have with "create
table" to the following:

In Teneo 0.8.0.v200702130950 the id tags in the hbm mapping for classes
using annotated id (@Id) looks like following:

<id name="id" type="int">
<column not-null="true" unique="false" name="`id`"/>
<generator class="native"/>
</id>

When I started to use Teneo 0.8.0.v200704230019 and later versions the id
element looks like this:

<id name="id" type="int">
<column not-null="true" unique="true" name="`id`"/>
<generator class="native"/>
</id>

The difference is that the unique attribute was earlier false and in the
latest versions it is true.

The generated DDL then looks like this and the table doesn't get created due
to that there are two constraints that have the same set of columns (the ID
column):

create table "attributevaluedefinition" (
"id" integer not null unique,
"dtype" varchar(255) not null,
"version" integer not null,
"name" varchar(255) not null,
"value" varchar(255) not null,
" datapointpredefinedattributedefinition_attributevaluedefinit ions_id "
integer,
" datapointpredefinedattributedefinition_attributevaluedefinit ions_idx "
integer,
econtainer_class varchar(255),
e_container varchar(255),
e_container_featureid integer,
primary key ("id")
)

The older version generated the following DDL:

create table "attributevaluedefinition" (
"id" integer not null,
"dtype" varchar(255) not null,
"version" integer not null,
"name" varchar(255) not null,
"value" varchar(255) not null,
econtainer_class varchar(255),
e_container varchar(255),
e_container_featureid integer,
" datapointpredefinedattributedefinition_attributevaluedefinit ions_id "
integer,
" datapointpredefinedattributedefinition_attributevaluedefinit ions_idx "
integer,
primary key ("id")
)

So the conflict seems to come from that there is an explicit "unique" for
the "id" column (unique constraint number one) and another implicit unique
constraint in 'primary key ("id")' (unique constraint number two). Thus the
same constraint twice for the id column and create table fails.

I assume that this is either a bug or that the configuration somewere has to
be changed. Could you give me an advice how I can go on to solve this
problem?

Kind regards!
Bj
Re: [Teneo] Create table fails in Integration Build I200704230019 [message #92990 is a reply to message #92885] Fri, 10 August 2007 10:59 Go to previous messageGo to next message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Björn,
Yes this extra unique="true" does not seem required. I checked and the old hbm's of the testcases
all had unique="false". I have corrected this. Can you enter a bugzilla for this (then it ends up in
the release notes)?

gr. Martin

Björn Sundin wrote:
> Hi Martin,
>
> I think I have pinned down the problem that I (still) have with "create
> table" to the following:
>
> In Teneo 0.8.0.v200702130950 the id tags in the hbm mapping for classes
> using annotated id (@Id) looks like following:
>
> <id name="id" type="int">
> <column not-null="true" unique="false" name="`id`"/>
> <generator class="native"/>
> </id>
>
> When I started to use Teneo 0.8.0.v200704230019 and later versions the id
> element looks like this:
>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
>
> The difference is that the unique attribute was earlier false and in the
> latest versions it is true.
>
> The generated DDL then looks like this and the table doesn't get created due
> to that there are two constraints that have the same set of columns (the ID
> column):
>
> create table "attributevaluedefinition" (
> "id" integer not null unique,
> "dtype" varchar(255) not null,
> "version" integer not null,
> "name" varchar(255) not null,
> "value" varchar(255) not null,
> " datapointpredefinedattributedefinition_attributevaluedefinit ions_id "
> integer,
> " datapointpredefinedattributedefinition_attributevaluedefinit ions_idx "
> integer,
> econtainer_class varchar(255),
> e_container varchar(255),
> e_container_featureid integer,
> primary key ("id")
> )
>
> The older version generated the following DDL:
>
> create table "attributevaluedefinition" (
> "id" integer not null,
> "dtype" varchar(255) not null,
> "version" integer not null,
> "name" varchar(255) not null,
> "value" varchar(255) not null,
> econtainer_class varchar(255),
> e_container varchar(255),
> e_container_featureid integer,
> " datapointpredefinedattributedefinition_attributevaluedefinit ions_id "
> integer,
> " datapointpredefinedattributedefinition_attributevaluedefinit ions_idx "
> integer,
> primary key ("id")
> )
>
> So the conflict seems to come from that there is an explicit "unique" for
> the "id" column (unique constraint number one) and another implicit unique
> constraint in 'primary key ("id")' (unique constraint number two). Thus the
> same constraint twice for the id column and create table fails.
>
> I assume that this is either a bug or that the configuration somewere has to
> be changed. Could you give me an advice how I can go on to solve this
> problem?
>
> Kind regards!
> Björn
>
> PS. I've attached the in memory hibernate.hbm.xml for the different versions
> as well as the teneo debug output
>
>
>
> "Björn Sundin" <bsu@bergauer.ch> schrieb im Newsbeitrag
> news:f5bgjb$o40$1@build.eclipse.org...
>> Hi Martin,
>>
>> The hbm for the Connectable class looks like this:
>>
>> <class
>> name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Connecta bleImpl "
>> entity-name="Connectable" abstract="true" lazy="false"
>> discriminator-value="Connectable" table="`connectable`">
>> <meta attribute="eclassName">Connectable</meta>
>> <meta
>> attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
>> <id name="id" type="int">
>> <column not-null="true" unique="true" name="`id`"/>
>> <generator class="native"/>
>> </id>
>> <discriminator column="`dtype`" type="string"/>
>> <version name="version" type="int">
>> <column not-null="true" unique="false" name="`version`"/>
>> </version>
>> <property name="name" lazy="false" insert="true" update="true"
>> not-null="false" unique="false" type="java.lang.String">
>> <column not-null="false" unique="false" name="`name`"/>
>> </property>
>> <list name="connections" lazy="true"
>> cascade="delete,merge,persist,save-update,lock,refresh">
>> <key update="true">
>> <column name="`connectable_connections_id`"
> not-null="false"
>> unique="false"/>
>> </key>
>> <list-index column="`connectable_connections_idx`"/>
>> <one-to-many entity-name="Connection"/>
>> </list>
>> </class>
>>
>> In the two console output files I sent as attachment in the first post you
>> can see the complete hbm mapping (generated in memory).
>>
>> Regards
>> Björn
>>
>> "Martin Taal" <mtaal@elver.org> schrieb im Newsbeitrag
>> news:f5b80o$h1a$1@build.eclipse.org...
>>> Hi Bjorn,
>>> And how does the hbm look like for the Connectable class?
>>>
>>> gr. Martin
>>>
>>> Björn Sundin wrote:
>>>> Hi Martin
>>>>
>>>> As far as I can see does this error occur for those tables where I
> don't
>> use
>>>> a synthetic id.
>>>>
>>>> I have defined a DataType AmsetId:
>>>>
>>>> <eClassifiers xsi:type="ecore:EDataType" name="AmsetId"
>>>> instanceClassName="int">
>>>> <eAnnotations source="teneo.jpa">
>>>> <details key="appinfo" value="@Id
>>>> @GeneratedValue(strategy=&quot;AUTO&quot;)"/>
>>>> </eAnnotations>
>>>> </eClassifiers>
>>>>
>>>> This DataType is used in i.e. Connectable:
>>>>
>>>> <eClassifiers xsi:type="ecore:EClass" name="Connectable"
>>>> abstract="true">
>>>> <eStructuralFeatures xsi:type="ecore:EAttribute" name="name"
>>>> eType="ecore:EDataType
>> http://www.eclipse.org/emf/2002/Ecore#//EString"/>
>>>> <eStructuralFeatures xsi:type="ecore:EReference"
>> name="connections"
>>>> upperBound="-1"
>>>> eType="#//Connection" containment="true"/>
>>>> <eStructuralFeatures xsi:type="ecore:EAttribute" name="id"
>>>> unique="false" eType="ecore:EDataType
>>>>
> ..../../ch.bergauer.rcp.amset.system.attributes/model/system datatypes.ecore#/
>> /
>>>> AmsetId"
>>>> iD="true"/>
>>>> <eStructuralFeatures xsi:type="ecore:EAttribute"
> name="version"
>>>> eType="ecore:EDataType
>>>>
> ..../../ch.bergauer.rcp.amset.system.attributes/model/system datatypes.ecore#/
>> /
>>>> AmsetVersion"/>
>>>> </eClassifiers>
>>>>
>>>> The exception is thrown by the
>>>>
> org.apache.derby.impl.sql.compile.TableElementList.validate( DDLStatementNode
>>>> ddlStmt, DataDictionary dd, TableDescriptor td) method:
>>>>
>>>>
>>>>       //check if there are multiple constraints with same set of
> columns
>>>>       if (columnsMatch(cdn.getColumnList().getColumnNames(),
>>>> destColumnNames))
>>>>           throw
>>>>
> StandardException.newException(SQLState.LANG_MULTIPLE_CONSTRAINTS_WITH_SAME_
>>>> COLUMNS,
>>>>                   cdn.getConstraintMoniker(), destName);
>>>> 

>>>>
>>>> The parameters in columnsMatch have the following values:
>>>> cdn.getColumnList().getColumnNames(): (java.lang.String[]) [id]
>>>> destColumnNames: (java.lang.String[]) [id]
>>>>
>>>> The DDLStatementNode parameters in TableElementList.validate looks
> like
>>>> this:
>>>>
>>>>
>>>> connectablestatementType: CREATE TABLE
>>>> tableElementList:
>>>> constraintName: null
>>>> constraintType: 3
>>>> properties: null
>>>> name: SQL070620101614670
>>>>
>>>> dataTypeServices: INTEGER NOT NULL
>>>> defaultValue: null
>>>> name: id
>>>>
>>>> dataTypeServices: VARCHAR(255) NOT NULL
>>>> defaultValue: null
>>>> name: dtype
>>>>
>>>> dataTypeServices: INTEGER NOT NULL
>>>> defaultValue: null
>>>> name: version
>>>>
>>>> dataTypeServices: VARCHAR(255)
>>>> defaultValue: null
>>>> name: name
>>>>
>>>> dataTypeServices: INTEGER
>>>> defaultValue: null
>>>> name: environment_connectables_id
>>>>
>>>> dataTypeServices: INTEGER
>>>> defaultValue: null
>>>> name: environment_connectables_idx
>>>>
>>>> dataTypeServices: VARCHAR(255)
>>>> defaultValue: null
>>>> name: ECONTAINER_CLASS
>>>>
>>>> dataTypeServices: VARCHAR(255)
>>>> defaultValue: null
>>>> name: E_CONTAINER
>>>>
>>>> dataTypeServices: INTEGER
>>>> defaultValue: null
>>>> name: E_CONTAINER_FEATUREID
>>>>
>>>> constraintName: null
>>>> constraintType: 2
>>>> properties: null
>>>> name: SQL070620102737810
>>>>
>>>>
>>>> properties:
>>>> null
>>>> lockGranularity:
>>>> R
>>>> [/ddlStmt]
>>>>
>>>> Regards
>>>> Björn
>>>>
>>>> "Martin Taal" <mtaal@elver.org> schrieb im Newsbeitrag
>>>> news:f56sc0$eml$1@build.eclipse.org...
>>>>> Hi Björn,
>>>>> Some questions:
>>>>> Can you see which columns are present in the constraints of which the
>>>> creation fails?
>>>>> Can you also post the mapping of the "connection" type?
>>>>>
>>>>> gr. Maritn
>>>>>
>>>>> Björn Sundin wrote:
>>>>>> Hello Martin,
>>>>>>
>>>>>> Maybe this could be of any help to you...?
>>>>>>
>>>>>> I upgraded my development enviroment from Eclipse 3.3M5 to Eclipse
>>>> 3.3RC3
>>>>>> today. As I anyway was retrieving newer builds I thought I might as
>>>> well
>>>>>> update Teneo. Until now I have successfully been using Integration
>> Build
>>>>>> I200702130950. Now I downloaded and installed Integration Build
>>>>>> I200704230019.
>>>>>>
>>>>>> As I started up a new project (where a new Derby database gets
>> created)
>>>> I
>>>>>> encountered the following problem while creating the tables:
>>>>>>
>>>>>> [start extract console log]
>>>>>> ....
>>>>>> 10594 [ModalContext] DEBUG
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>> create
>>>>>> table "connectable" ("id" integer not null unique, "dtype"
>> varchar(255)
>>>> not
>>>>>> null, "version" integer not null, "name" varchar(255),
>>>>>> "environment_connectables_id" integer,
> "environment_connectables_idx"
>>>>>> integer, econtainer_class varchar(255), e_container varchar(255),
>>>>>> e_container_featureid integer, primary key ("id"))
>>>> (SchemaUpdate.java:149)
>>>>>> 10625 [ModalContext] ERROR
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>>>> Unsuccessful: create table "connectable" ("id" integer not null
>> unique,
>>>>>> "dtype" varchar(255) not null, "version" integer not null, "name"
>>>>>> varchar(255), "environment_connectables_id" integer,
>>>>>> "environment_connectables_idx" integer, econtainer_class
> varchar(255),
>>>>>> e_container varchar(255), e_container_featureid integer, primary key
>>>> ("id"))
>>>>>> (SchemaUpdate.java:155)
>>>>>> 10625 [ModalContext] ERROR
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>>>> Constraints 'SQL070618024717651' and 'SQL070618024717650' have the
>> same
>>>> set
>>>>>> of columns, which is not allowed. (SchemaUpdate.java:156)
>>>>>> 10625 [ModalContext] DEBUG
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>> create
>>>>>> table "connection" ("id" integer not null unique, "dtype"
> varchar(255)
>>>> not
>>>>>> null, "version" integer not null, "connectable_source_id" integer,
>>>>>> "connectable_target_id" integer, "description" varchar(255), "port"
>>>> integer,
>>>>>> "connectable_connections_id" integer, "connectable_connections_idx"
>>>> integer,
>>>>>> econtainer_class varchar(255), e_container varchar(255),
>>>> e_container_feature
>>>>>> id integer, primary key ("id")) (SchemaUpdate.java:149)
>>>>>> 10625 [ModalContext] ERROR
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>>>> Unsuccessful: create table "connection" ("id" integer not null
> unique,
>>>>>> "dtype" varchar(255) not null, "version" integer not null,
>>>>>> "connectable_source_id" integer, "connectable_target_id" integer,
>>>>>> "description" varchar(255), "port" integer,
>> "connectable_connections_id"
>>>>>> integer, "connectable_connections_idx" integer, econtainer_class
>>>>>> varchar(255), e_container varchar(255), e_container_featureid
> integer,
>>>>>> primary key ("id")) (SchemaUpdate.java:155)
>>>>>> 10625 [ModalContext] ERROR
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>>>> Constraints 'SQL070618024717671' and 'SQL070618024717670' have the
>> same
>>>> set
>>>>>> of columns, which is not allowed. (SchemaUpdate.java:156)
>>>>>> ....
>>>>>> [end extract console log]
>>>>>>
>>>>>> Needless to say, the application failed to start, so I used
>> Integration
>>>>>> Build I200702130950 again, and the application started as expected.
>>>>>>
>>>>>> Attached you will find both console logs. I used the same model and
>>>>>> generated code and tested this both with code that was generated
>> before
>>>> and
>>>>>> after upgrading EMF and Teneo.
>>>>>>
>>>>>> It is basically no problem for me, as I can continue to use
>> Integration
>>>>>> Build I200702130950, but it might indicate that something has got
>>>> broken?
>>>>>> Kind regards
>>>>>> Bjoern
>>>>>>
>>>>>>
>>>>> --
>>>>>
>>>>> 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
>>>>
>>>
>>> --
>>>
>>> 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
>>
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
>
> <!-- Generated by Teneo on Thu Aug 09 15:22:20 CEST 2007 -->
> <hibernate-mapping auto-import="false">
> <class name=" ch.bergauer.rcp.amset.model.project.attributes.amset.impl.Pr ojectAttributesImpl " entity-name="ProjectAttributes" abstract="false" lazy="false" discriminator-value="ProjectAttributes" table="`projectattributes`">
> <meta attribute="eclassName">ProjectAttributes</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Projectattributes.xmi</meta>
> <id type="long" name="id" column="id" access=" org.eclipse.emf.teneo.hibernate.mapping.identifier.Identifie rPropertyHandler ">
> <meta attribute="syntheticId">true</meta>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <many-to-one name="UserGroups" entity-name="UserGroupCollection" cascade="delete,merge,persist,save-update,lock,refresh" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name="`usergroupcollection_usergroups_e_id`"/>
> </many-to-one>
> <many-to-one name="UserPersons" entity-name="UserPersonCollection" cascade="delete,merge,persist,save-update,lock,refresh" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name="`userpersoncollection_userpersons_e_id`"/>
> </many-to-one>
> </class>
> <class name=" ch.bergauer.rcp.amset.model.project.attributes.amset.impl.Us erGroupCollectionImpl " entity-name="UserGroupCollection" abstract="false" lazy="false" discriminator-value="UserGroupCollection" table="`usergroupcollection`">
> <meta attribute="eclassName">UserGroupCollection</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Projectattributes.xmi</meta>
> <id type="long" name="id" column="id" access=" org.eclipse.emf.teneo.hibernate.mapping.identifier.Identifie rPropertyHandler ">
> <meta attribute="syntheticId">true</meta>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <list name="UserGroupRef" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`usergroupcollection_usergroupref_e_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`usergroupcollection_usergroupref_idx`"/>
> <one-to-many entity-name="UserGroup"/>
> </list>
> </class>
> <class name=" ch.bergauer.rcp.amset.model.project.attributes.amset.impl.Us erPersonCollectionImpl " entity-name="UserPersonCollection" abstract="false" lazy="false" discriminator-value="UserPersonCollection" table="`userpersoncollection`">
> <meta attribute="eclassName">UserPersonCollection</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Projectattributes.xmi</meta>
> <id type="long" name="id" column="id" access=" org.eclipse.emf.teneo.hibernate.mapping.identifier.Identifie rPropertyHandler ">
> <meta attribute="syntheticId">true</meta>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <list name="UserPersonRef" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`userpersoncollection_userpersonref_e_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`userpersoncollection_userpersonref_idx`"/>
> <one-to-many entity-name="UserPerson"/>
> </list>
> </class>
> <class name=" ch.bergauer.rcp.amset.model.project.attributes.amset.impl.Us erGroupImpl " entity-name="UserGroup" abstract="false" lazy="false" discriminator-value="UserGroup" table="`usergroup`">
> <meta attribute="eclassName">UserGroup</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Projectattributes.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <property name="name" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
> <column not-null="true" unique="false" name="`name`"/>
> </property>
> <property name="description" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`description`"/>
> </property>
> <many-to-one name="userTypeRef" entity-name="UserType" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name="`usertype_usertyperef_id`"/>
> </many-to-one>
> </class>
> <class name=" ch.bergauer.rcp.amset.model.project.attributes.amset.impl.Us erPersonImpl " entity-name="UserPerson" abstract="false" lazy="false" discriminator-value="UserPerson" table="`userperson`">
> <meta attribute="eclassName">UserPerson</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Projectattributes.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <property name="name" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
> <column not-null="true" unique="false" name="`name`"/>
> </property>
> <property name="firstname" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`firstname`"/>
> </property>
> <property name="username" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
> <column not-null="true" unique="false" name="`username`"/>
> </property>
> <property name="password" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
> <column not-null="true" unique="false" name="`password`"/>
> </property>
> <many-to-one name="userGroupRef" entity-name="UserGroup" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name="`usergroup_usergroupref_id`"/>
> </many-to-one>
> </class>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Environm entImpl " entity-name="Environment" abstract="false" lazy="false" discriminator-value="Environment" table="`environment`">
> <meta attribute="eclassName">Environment</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <list name="connectables" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`environment_connectables_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`environment_connectables_idx`"/>
> <one-to-many entity-name="Connectable"/>
> </list>
> <property name="name" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`name`"/>
> </property>
> <property name="description" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`description`"/>
> </property>
> </class>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Connecti onImpl " entity-name="Connection" abstract="true" lazy="false" discriminator-value="Connection" table="`connection`">
> <meta attribute="eclassName">Connection</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <many-to-one name="source" entity-name="Connectable" lazy="false" insert="true" update="true" not-null="false">
> <column not-null="false" unique="false" name="`connectable_source_id`"/>
> </many-to-one>
> <many-to-one name="target" entity-name="Connectable" lazy="false" insert="true" update="true" not-null="false">
> <column not-null="false" unique="false" name="`connectable_target_id`"/>
> </many-to-one>
> <property name="description" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`description`"/>
> </property>
> <property name="port" lazy="false" insert="true" update="true" not-null="false" unique="false" type="int">
> <column not-null="false" unique="false" name="`port`"/>
> </property>
> </class>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.IdcConne ctionImpl " entity-name="IdcConnection" abstract="false" lazy="false" extends="Connection" discriminator-value="IdcConnection">
> <meta attribute="eclassName">IdcConnection</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.AmBusCon nectionImpl " entity-name="AmBusConnection" abstract="false" lazy="false" extends="Connection" discriminator-value="AmBusConnection">
> <meta attribute="eclassName">AmBusConnection</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Connecta bleImpl " entity-name="Connectable" abstract="true" lazy="false" discriminator-value="Connectable" table="`connectable`">
> <meta attribute="eclassName">Connectable</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <property name="name" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`name`"/>
> </property>
> <list name="connections" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`connectable_connections_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`connectable_connections_idx`"/>
> <one-to-many entity-name="Connection"/>
> </list>
> </class>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.AmBusImp l " entity-name="AmBus" abstract="false" lazy="false" extends="Connectable" discriminator-value="AmBus">
> <meta attribute="eclassName">AmBus</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name="ch.bergauer.rcp.amset.project.data.nodes.amset.AbstractNode " entity-name="AbstractNode" abstract="true" lazy="false" extends="Connectable" discriminator-value="AbstractNode">
> <meta attribute="eclassName">AbstractNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <list name="ownedDatapoints" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`abstractnode_owneddatapoints_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`abstractnode_owneddatapoints_idx`"/>
> <one-to-many entity-name="Datapoint"/>
> </list>
> <list name="foreignDatapoints" lazy="true" table="`abstractnode_foreigndatapoints`">
> <key update="true">
> <column name="`abstractnode_id`" not-null="true" unique="false"/>
> </key>
> <list-index column="`abstractnode_foreigndatapoints_idx`"/>
> <many-to-many entity-name="Datapoint" unique="false">
> <column name="`datapoint_id`" not-null="true" unique="false"/>
> </many-to-many>
> </list>
> </subclass>
> <subclass name="ch.bergauer.rcp.amset.project.data.nodes.amset.SimpleNode " entity-name="SimpleNode" abstract="true" lazy="false" extends="AbstractNode" discriminator-value="SimpleNode">
> <meta attribute="eclassName">SimpleNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.AmNodeIm pl " entity-name="AmNode" abstract="false" lazy="false" extends="AbstractNode" discriminator-value="AmNode">
> <meta attribute="eclassName">AmNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Illumina tionNodeImpl " entity-name="IlluminationNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="IlluminationNode">
> <meta attribute="eclassName">IlluminationNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.FireDete ctorNodeImpl " entity-name="FireDetectorNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="FireDetectorNode">
> <meta attribute="eclassName">FireDetectorNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.ElsNodeI mpl " entity-name="ElsNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="ElsNode">
> <meta attribute="eclassName">ElsNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.PowerNod eImpl " entity-name="PowerNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="PowerNode">
> <meta attribute="eclassName">PowerNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.RadioNod eImpl " entity-name="RadioNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="RadioNode">
> <meta attribute="eclassName">RadioNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.BlackIce WarningNodeImpl " entity-name="BlackIceWarningNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="BlackIceWarningNode">
> <meta attribute="eclassName">BlackIceWarningNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.GeneralC ommunicationNodeImpl " entity-name="GeneralCommunicationNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="GeneralCommunicationNode">
> <meta attribute="eclassName">GeneralCommunicationNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.RadioCom municationNodeImpl " entity-name="RadioCommunicationNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="RadioCommunicationNode">
> <meta attribute="eclassName">RadioCommunicationNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Communic ationProcessorNodeImpl " entity-name="CommunicationProcessorNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="CommunicationProcessorNode">
> <meta attribute="eclassName">CommunicationProcessorNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Ventilat ionNodeImpl " entity-name="VentilationNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="VentilationNode">
> <meta attribute="eclassName">VentilationNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Auxiliar yNodeImpl " entity-name="AuxiliaryNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="AuxiliaryNode">
> <meta attribute="eclassName">AuxiliaryNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Emergenc yTelephoneNodeImpl " entity-name="EmergencyTelephoneNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="EmergencyTelephoneNode">
> <meta attribute="eclassName">EmergencyTelephoneNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.PumpingS tationNodeImpl " entity-name="PumpingStationNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="PumpingStationNode">
> <meta attribute="eclassName">PumpingStationNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Security NodeImpl " entity-name="SecurityNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="SecurityNode">
> <meta attribute="eclassName">SecurityNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.TestNode Impl " entity-name="TestNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="TestNode">
> <meta attribute="eclassName">TestNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.TrafficN odeImpl " entity-name="TrafficNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="TrafficNode">
> <meta attribute="eclassName">TrafficNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.VideoNod eImpl " entity-name="VideoNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="VideoNode">
> <meta attribute="eclassName">VideoNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.VideoMan agementSystemNodeImpl " entity-name="VideoManagementSystemNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="VideoManagementSystemNode">
> <meta attribute="eclassName">VideoManagementSystemNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.CentralF acilityNodeImpl " entity-name="CentralFacilityNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="CentralFacilityNode">
> <meta attribute="eclassName">CentralFacilityNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Datapoin tImpl " entity-name="Datapoint" abstract="false" lazy="false" discriminator-value="Datapoint" table="`datapoint`">
> <meta attribute="eclassName">Datapoint</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <property name="name" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`name`"/>
> </property>
> <many-to-one name="owner" entity-name="AbstractNode" lazy="false" insert="true" update="true" not-null="false">
> <column not-null="false" unique="false" name="`abstractnode_owner_id`"/>
> </many-to-one>
> <list name="datapoints" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`datapoint_datapoints_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`datapoint_datapoints_idx`"/>
> <one-to-many entity-name="Datapoint"/>
> </list>
> <list name="foreignNodes" lazy="true" table="`datapoint_foreignnodes`">
> <key update="true">
> <column name="`datapoint_id`" not-null="true" unique="false"/>
> </key>
> <list-index column="`datapoint_foreignnodes_idx`"/>
> <many-to-many entity-name="AbstractNode" unique="false">
> <column name="`abstractnode_id`" not-null="true" unique="false"/>
> </many-to-many>
> </list>
> <list name="predefinedAttributeValues" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`datapoint_predefinedattributevalues_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`datapoint_predefinedattributevalues_idx`"/>
> <one-to-many entity-name="PredefinedAttributeValue"/>
> </list>
> <list name="textAttributeValues" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`datapoint_textattributevalues_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`datapoint_textattributevalues_idx`"/>
> <one-to-many entity-name="TextAttributeValue"/>
> </list>
> </class>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.TextAttr ibuteValueImpl " entity-name="TextAttributeValue" abstract="false" lazy="false" discriminator-value="TextAttributeValue" table="`textattributevalue`">
> <meta attribute="eclassName">TextAttributeValue</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <property name="name" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
> <column not-null="true" unique="false" name="`name`"/>
> </property>
> <many-to-one name="datapointAttributeDefinitionRef" entity-name="DatapointAttributeDefinition" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name=" `datapointattributedefinition_datapointattributedefinitionre f_id` "/>
> </many-to-one>
> </class>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Predefin edAttributeValueImpl " entity-name="PredefinedAttributeValue" abstract="false" lazy="false" discriminator-value="PredefinedAttributeValue" table="`predefinedattributevalue`">
> <meta attribute="eclassName">PredefinedAttributeValue</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <many-to-one name="attributeValueDefinition" entity-name="AttributeValueDefinition" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name="`attributevaluedefinition_attributevaluedefinition_id` "/>
> </many-to-one>
> </class>
> <class name=" ch.bergauer.rcp.amset.model.system.attributes.amset.impl.Sys temAttributesImpl " entity-name="SystemAttributes" abstract="false" lazy="false" discriminator-value="SystemAttributes" table="`systemattributes`">
> <meta attribute="eclassName">SystemAttributes</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Systemattributes.xmi</meta>
> <id type="long" name="id" column="id" access=" org.eclipse.emf.teneo.hibernate.mapping.identifier.Identifie rPropertyHandler ">
> <meta attribute="syntheticId">true</meta>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <many-to-one name="dataTypes" entity-name="DataTypeCollection" cascade="del
Re: [Teneo] Create table fails in Integration Build I200704230019 [message #93161 is a reply to message #92990] Fri, 10 August 2007 12:55 Go to previous message
Eclipse UserFriend
Originally posted by: bsu.bergauer.ch

Done: Bug 199555

Wenn will a corrected version be available?

Regards
Bj
Re: [Teneo] Create table fails in Integration Build I200704230019 [message #607012 is a reply to message #86732] Mon, 18 June 2007 21:10 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Björn,
Some questions:
Can you see which columns are present in the constraints of which the creation fails?

Can you also post the mapping of the "connection" type?

gr. Maritn

Björn Sundin wrote:
> Hello Martin,
>
> Maybe this could be of any help to you...?
>
> I upgraded my development enviroment from Eclipse 3.3M5 to Eclipse 3.3RC3
> today. As I anyway was retrieving newer builds I thought I might as well
> update Teneo. Until now I have successfully been using Integration Build
> I200702130950. Now I downloaded and installed Integration Build
> I200704230019.
>
> As I started up a new project (where a new Derby database gets created) I
> encountered the following problem while creating the tables:
>
> [start extract console log]
> ....
> 10594 [ModalContext] DEBUG org.hibernate.tool.hbm2ddl.SchemaUpdate - create
> table "connectable" ("id" integer not null unique, "dtype" varchar(255) not
> null, "version" integer not null, "name" varchar(255),
> "environment_connectables_id" integer, "environment_connectables_idx"
> integer, econtainer_class varchar(255), e_container varchar(255),
> e_container_featureid integer, primary key ("id")) (SchemaUpdate.java:149)
> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Unsuccessful: create table "connectable" ("id" integer not null unique,
> "dtype" varchar(255) not null, "version" integer not null, "name"
> varchar(255), "environment_connectables_id" integer,
> "environment_connectables_idx" integer, econtainer_class varchar(255),
> e_container varchar(255), e_container_featureid integer, primary key ("id"))
> (SchemaUpdate.java:155)
> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Constraints 'SQL070618024717651' and 'SQL070618024717650' have the same set
> of columns, which is not allowed. (SchemaUpdate.java:156)
> 10625 [ModalContext] DEBUG org.hibernate.tool.hbm2ddl.SchemaUpdate - create
> table "connection" ("id" integer not null unique, "dtype" varchar(255) not
> null, "version" integer not null, "connectable_source_id" integer,
> "connectable_target_id" integer, "description" varchar(255), "port" integer,
> "connectable_connections_id" integer, "connectable_connections_idx" integer,
> econtainer_class varchar(255), e_container varchar(255), e_container_feature
> id integer, primary key ("id")) (SchemaUpdate.java:149)
> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Unsuccessful: create table "connection" ("id" integer not null unique,
> "dtype" varchar(255) not null, "version" integer not null,
> "connectable_source_id" integer, "connectable_target_id" integer,
> "description" varchar(255), "port" integer, "connectable_connections_id"
> integer, "connectable_connections_idx" integer, econtainer_class
> varchar(255), e_container varchar(255), e_container_featureid integer,
> primary key ("id")) (SchemaUpdate.java:155)
> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
> Constraints 'SQL070618024717671' and 'SQL070618024717670' have the same set
> of columns, which is not allowed. (SchemaUpdate.java:156)
> ....
> [end extract console log]
>
> Needless to say, the application failed to start, so I used Integration
> Build I200702130950 again, and the application started as expected.
>
> Attached you will find both console logs. I used the same model and
> generated code and tested this both with code that was generated before and
> after upgrading EMF and Teneo.
>
> It is basically no problem for me, as I can continue to use Integration
> Build I200702130950, but it might indicate that something has got broken?
>
> Kind regards
> Bjoern
>
>


--

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] Create table fails in Integration Build I200704230019 [message #607019 is a reply to message #86752] Wed, 20 June 2007 08:50 Go to previous message
Eclipse UserFriend
Originally posted by: bsu.bergauer.ch

Hi Martin

As far as I can see does this error occur for those tables where I don't use
a synthetic id.

I have defined a DataType AmsetId:

<eClassifiers xsi:type="ecore:EDataType" name="AmsetId"
instanceClassName="int">
<eAnnotations source="teneo.jpa">
<details key="appinfo" value="@Id
@GeneratedValue(strategy=&quot;AUTO&quot;)"/>
</eAnnotations>
</eClassifiers>

This DataType is used in i.e. Connectable:

<eClassifiers xsi:type="ecore:EClass" name="Connectable"
abstract="true">
<eStructuralFeatures xsi:type="ecore:EAttribute" name="name"
eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString"/>
<eStructuralFeatures xsi:type="ecore:EReference" name="connections"
upperBound="-1"
eType="#//Connection" containment="true"/>
<eStructuralFeatures xsi:type="ecore:EAttribute" name="id"
unique="false" eType="ecore:EDataType
.../../ch.bergauer.rcp.amset.system.attributes/model/systemd atatypes.ecore#//
AmsetId"
iD="true"/>
<eStructuralFeatures xsi:type="ecore:EAttribute" name="version"
eType="ecore:EDataType
.../../ch.bergauer.rcp.amset.system.attributes/model/systemd atatypes.ecore#//
AmsetVersion"/>
</eClassifiers>

The exception is thrown by the
org.apache.derby.impl.sql.compile.TableElementList.validate( DDLStatementNode
ddlStmt, DataDictionary dd, TableDescriptor td) method:

      //check if there are multiple constraints with same set of columns
      if (columnsMatch(cdn.getColumnList().getColumnNames(),
destColumnNames))
          throw
StandardException.newException(SQLState.LANG_MULTIPLE_CONSTRAINTS_WITH_SAME_
COLUMNS,
                  cdn.getConstraintMoniker(), destName);


The parameters in columnsMatch have the following values:
cdn.getColumnList().getColumnNames(): (java.lang.String[]) [id]
destColumnNames: (java.lang.String[]) [id]

The DDLStatementNode parameters in TableElementList.validate looks like
this:


connectablestatementType: CREATE TABLE
tableElementList:
constraintName: null
constraintType: 3
properties: null
name: SQL070620101614670

dataTypeServices: INTEGER NOT NULL
defaultValue: null
name: id

dataTypeServices: VARCHAR(255) NOT NULL
defaultValue: null
name: dtype

dataTypeServices: INTEGER NOT NULL
defaultValue: null
name: version

dataTypeServices: VARCHAR(255)
defaultValue: null
name: name

dataTypeServices: INTEGER
defaultValue: null
name: environment_connectables_id

dataTypeServices: INTEGER
defaultValue: null
name: environment_connectables_idx

dataTypeServices: VARCHAR(255)
defaultValue: null
name: ECONTAINER_CLASS

dataTypeServices: VARCHAR(255)
defaultValue: null
name: E_CONTAINER

dataTypeServices: INTEGER
defaultValue: null
name: E_CONTAINER_FEATUREID

constraintName: null
constraintType: 2
properties: null
name: SQL070620102737810


properties:
null
lockGranularity:
R
[/ddlStmt]

Regards
Bj
Re: [Teneo] Create table fails in Integration Build I200704230019 [message #607022 is a reply to message #86827] Wed, 20 June 2007 12:53 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Bjorn,
And how does the hbm look like for the Connectable class?

gr. Martin

Björn Sundin wrote:
> Hi Martin
>
> As far as I can see does this error occur for those tables where I don't use
> a synthetic id.
>
> I have defined a DataType AmsetId:
>
> <eClassifiers xsi:type="ecore:EDataType" name="AmsetId"
> instanceClassName="int">
> <eAnnotations source="teneo.jpa">
> <details key="appinfo" value="@Id
> @GeneratedValue(strategy=&quot;AUTO&quot;)"/>
> </eAnnotations>
> </eClassifiers>
>
> This DataType is used in i.e. Connectable:
>
> <eClassifiers xsi:type="ecore:EClass" name="Connectable"
> abstract="true">
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="name"
> eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString"/>
> <eStructuralFeatures xsi:type="ecore:EReference" name="connections"
> upperBound="-1"
> eType="#//Connection" containment="true"/>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="id"
> unique="false" eType="ecore:EDataType
> .../../ch.bergauer.rcp.amset.system.attributes/model/systemd atatypes.ecore#//
> AmsetId"
> iD="true"/>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="version"
> eType="ecore:EDataType
> .../../ch.bergauer.rcp.amset.system.attributes/model/systemd atatypes.ecore#//
> AmsetVersion"/>
> </eClassifiers>
>
> The exception is thrown by the
> org.apache.derby.impl.sql.compile.TableElementList.validate( DDLStatementNode
> ddlStmt, DataDictionary dd, TableDescriptor td) method:
>
>
>       //check if there are multiple constraints with same set of columns
>       if (columnsMatch(cdn.getColumnList().getColumnNames(),
> destColumnNames))
>           throw
> StandardException.newException(SQLState.LANG_MULTIPLE_CONSTRAINTS_WITH_SAME_
> COLUMNS,
>                   cdn.getConstraintMoniker(), destName);
> 

>
> The parameters in columnsMatch have the following values:
> cdn.getColumnList().getColumnNames(): (java.lang.String[]) [id]
> destColumnNames: (java.lang.String[]) [id]
>
> The DDLStatementNode parameters in TableElementList.validate looks like
> this:
>
>
> connectablestatementType: CREATE TABLE
> tableElementList:
> constraintName: null
> constraintType: 3
> properties: null
> name: SQL070620101614670
>
> dataTypeServices: INTEGER NOT NULL
> defaultValue: null
> name: id
>
> dataTypeServices: VARCHAR(255) NOT NULL
> defaultValue: null
> name: dtype
>
> dataTypeServices: INTEGER NOT NULL
> defaultValue: null
> name: version
>
> dataTypeServices: VARCHAR(255)
> defaultValue: null
> name: name
>
> dataTypeServices: INTEGER
> defaultValue: null
> name: environment_connectables_id
>
> dataTypeServices: INTEGER
> defaultValue: null
> name: environment_connectables_idx
>
> dataTypeServices: VARCHAR(255)
> defaultValue: null
> name: ECONTAINER_CLASS
>
> dataTypeServices: VARCHAR(255)
> defaultValue: null
> name: E_CONTAINER
>
> dataTypeServices: INTEGER
> defaultValue: null
> name: E_CONTAINER_FEATUREID
>
> constraintName: null
> constraintType: 2
> properties: null
> name: SQL070620102737810
>
>
> properties:
> null
> lockGranularity:
> R
> [/ddlStmt]
>
> Regards
> Björn
>
> "Martin Taal" <mtaal@elver.org> schrieb im Newsbeitrag
> news:f56sc0$eml$1@build.eclipse.org...
>> Hi Björn,
>> Some questions:
>> Can you see which columns are present in the constraints of which the
> creation fails?
>> Can you also post the mapping of the "connection" type?
>>
>> gr. Maritn
>>
>> Björn Sundin wrote:
>>> Hello Martin,
>>>
>>> Maybe this could be of any help to you...?
>>>
>>> I upgraded my development enviroment from Eclipse 3.3M5 to Eclipse
> 3.3RC3
>>> today. As I anyway was retrieving newer builds I thought I might as
> well
>>> update Teneo. Until now I have successfully been using Integration Build
>>> I200702130950. Now I downloaded and installed Integration Build
>>> I200704230019.
>>>
>>> As I started up a new project (where a new Derby database gets created)
> I
>>> encountered the following problem while creating the tables:
>>>
>>> [start extract console log]
>>> ....
>>> 10594 [ModalContext] DEBUG org.hibernate.tool.hbm2ddl.SchemaUpdate -
> create
>>> table "connectable" ("id" integer not null unique, "dtype" varchar(255)
> not
>>> null, "version" integer not null, "name" varchar(255),
>>> "environment_connectables_id" integer, "environment_connectables_idx"
>>> integer, econtainer_class varchar(255), e_container varchar(255),
>>> e_container_featureid integer, primary key ("id"))
> (SchemaUpdate.java:149)
>>> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
>>> Unsuccessful: create table "connectable" ("id" integer not null unique,
>>> "dtype" varchar(255) not null, "version" integer not null, "name"
>>> varchar(255), "environment_connectables_id" integer,
>>> "environment_connectables_idx" integer, econtainer_class varchar(255),
>>> e_container varchar(255), e_container_featureid integer, primary key
> ("id"))
>>> (SchemaUpdate.java:155)
>>> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
>>> Constraints 'SQL070618024717651' and 'SQL070618024717650' have the same
> set
>>> of columns, which is not allowed. (SchemaUpdate.java:156)
>>> 10625 [ModalContext] DEBUG org.hibernate.tool.hbm2ddl.SchemaUpdate -
> create
>>> table "connection" ("id" integer not null unique, "dtype" varchar(255)
> not
>>> null, "version" integer not null, "connectable_source_id" integer,
>>> "connectable_target_id" integer, "description" varchar(255), "port"
> integer,
>>> "connectable_connections_id" integer, "connectable_connections_idx"
> integer,
>>> econtainer_class varchar(255), e_container varchar(255),
> e_container_feature
>>> id integer, primary key ("id")) (SchemaUpdate.java:149)
>>> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
>>> Unsuccessful: create table "connection" ("id" integer not null unique,
>>> "dtype" varchar(255) not null, "version" integer not null,
>>> "connectable_source_id" integer, "connectable_target_id" integer,
>>> "description" varchar(255), "port" integer, "connectable_connections_id"
>>> integer, "connectable_connections_idx" integer, econtainer_class
>>> varchar(255), e_container varchar(255), e_container_featureid integer,
>>> primary key ("id")) (SchemaUpdate.java:155)
>>> 10625 [ModalContext] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate -
>>> Constraints 'SQL070618024717671' and 'SQL070618024717670' have the same
> set
>>> of columns, which is not allowed. (SchemaUpdate.java:156)
>>> ....
>>> [end extract console log]
>>>
>>> Needless to say, the application failed to start, so I used Integration
>>> Build I200702130950 again, and the application started as expected.
>>>
>>> Attached you will find both console logs. I used the same model and
>>> generated code and tested this both with code that was generated before
> and
>>> after upgrading EMF and Teneo.
>>>
>>> It is basically no problem for me, as I can continue to use Integration
>>> Build I200702130950, but it might indicate that something has got
> broken?
>>> Kind regards
>>> Bjoern
>>>
>>>
>>
>> --
>>
>> 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
>
>


--

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] Create table fails in Integration Build I200704230019 [message #607025 is a reply to message #86861] Wed, 20 June 2007 15:20 Go to previous message
Eclipse UserFriend
Originally posted by: bsu.bergauer.ch

Hi Martin,

The hbm for the Connectable class looks like this:

<class
name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Connecta bleImpl "
entity-name="Connectable" abstract="true" lazy="false"
discriminator-value="Connectable" table="`connectable`">
<meta attribute="eclassName">Connectable</meta>
<meta
attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
<id name="id" type="int">
<column not-null="true" unique="true" name="`id`"/>
<generator class="native"/>
</id>
<discriminator column="`dtype`" type="string"/>
<version name="version" type="int">
<column not-null="true" unique="false" name="`version`"/>
</version>
<property name="name" lazy="false" insert="true" update="true"
not-null="false" unique="false" type="java.lang.String">
<column not-null="false" unique="false" name="`name`"/>
</property>
<list name="connections" lazy="true"
cascade="delete,merge,persist,save-update,lock,refresh">
<key update="true">
<column name="`connectable_connections_id`" not-null="false"
unique="false"/>
</key>
<list-index column="`connectable_connections_idx`"/>
<one-to-many entity-name="Connection"/>
</list>
</class>

In the two console output files I sent as attachment in the first post you
can see the complete hbm mapping (generated in memory).

Regards
Bj
Re: [Teneo] Create table fails in Integration Build I200704230019 [message #609442 is a reply to message #86904] Thu, 09 August 2007 14:19 Go to previous message
Eclipse UserFriend
Originally posted by: bsu.bergauer.ch

Hi Martin,

I think I have pinned down the problem that I (still) have with "create
table" to the following:

In Teneo 0.8.0.v200702130950 the id tags in the hbm mapping for classes
using annotated id (@Id) looks like following:

<id name="id" type="int">
<column not-null="true" unique="false" name="`id`"/>
<generator class="native"/>
</id>

When I started to use Teneo 0.8.0.v200704230019 and later versions the id
element looks like this:

<id name="id" type="int">
<column not-null="true" unique="true" name="`id`"/>
<generator class="native"/>
</id>

The difference is that the unique attribute was earlier false and in the
latest versions it is true.

The generated DDL then looks like this and the table doesn't get created due
to that there are two constraints that have the same set of columns (the ID
column):

create table "attributevaluedefinition" (
"id" integer not null unique,
"dtype" varchar(255) not null,
"version" integer not null,
"name" varchar(255) not null,
"value" varchar(255) not null,
" datapointpredefinedattributedefinition_attributevaluedefinit ions_id "
integer,
" datapointpredefinedattributedefinition_attributevaluedefinit ions_idx "
integer,
econtainer_class varchar(255),
e_container varchar(255),
e_container_featureid integer,
primary key ("id")
)

The older version generated the following DDL:

create table "attributevaluedefinition" (
"id" integer not null,
"dtype" varchar(255) not null,
"version" integer not null,
"name" varchar(255) not null,
"value" varchar(255) not null,
econtainer_class varchar(255),
e_container varchar(255),
e_container_featureid integer,
" datapointpredefinedattributedefinition_attributevaluedefinit ions_id "
integer,
" datapointpredefinedattributedefinition_attributevaluedefinit ions_idx "
integer,
primary key ("id")
)

So the conflict seems to come from that there is an explicit "unique" for
the "id" column (unique constraint number one) and another implicit unique
constraint in 'primary key ("id")' (unique constraint number two). Thus the
same constraint twice for the id column and create table fails.

I assume that this is either a bug or that the configuration somewere has to
be changed. Could you give me an advice how I can go on to solve this
problem?

Kind regards!
Bj
Re: [Teneo] Create table fails in Integration Build I200704230019 [message #609447 is a reply to message #92885] Fri, 10 August 2007 10:59 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Björn,
Yes this extra unique="true" does not seem required. I checked and the old hbm's of the testcases
all had unique="false". I have corrected this. Can you enter a bugzilla for this (then it ends up in
the release notes)?

gr. Martin

Björn Sundin wrote:
> Hi Martin,
>
> I think I have pinned down the problem that I (still) have with "create
> table" to the following:
>
> In Teneo 0.8.0.v200702130950 the id tags in the hbm mapping for classes
> using annotated id (@Id) looks like following:
>
> <id name="id" type="int">
> <column not-null="true" unique="false" name="`id`"/>
> <generator class="native"/>
> </id>
>
> When I started to use Teneo 0.8.0.v200704230019 and later versions the id
> element looks like this:
>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
>
> The difference is that the unique attribute was earlier false and in the
> latest versions it is true.
>
> The generated DDL then looks like this and the table doesn't get created due
> to that there are two constraints that have the same set of columns (the ID
> column):
>
> create table "attributevaluedefinition" (
> "id" integer not null unique,
> "dtype" varchar(255) not null,
> "version" integer not null,
> "name" varchar(255) not null,
> "value" varchar(255) not null,
> " datapointpredefinedattributedefinition_attributevaluedefinit ions_id "
> integer,
> " datapointpredefinedattributedefinition_attributevaluedefinit ions_idx "
> integer,
> econtainer_class varchar(255),
> e_container varchar(255),
> e_container_featureid integer,
> primary key ("id")
> )
>
> The older version generated the following DDL:
>
> create table "attributevaluedefinition" (
> "id" integer not null,
> "dtype" varchar(255) not null,
> "version" integer not null,
> "name" varchar(255) not null,
> "value" varchar(255) not null,
> econtainer_class varchar(255),
> e_container varchar(255),
> e_container_featureid integer,
> " datapointpredefinedattributedefinition_attributevaluedefinit ions_id "
> integer,
> " datapointpredefinedattributedefinition_attributevaluedefinit ions_idx "
> integer,
> primary key ("id")
> )
>
> So the conflict seems to come from that there is an explicit "unique" for
> the "id" column (unique constraint number one) and another implicit unique
> constraint in 'primary key ("id")' (unique constraint number two). Thus the
> same constraint twice for the id column and create table fails.
>
> I assume that this is either a bug or that the configuration somewere has to
> be changed. Could you give me an advice how I can go on to solve this
> problem?
>
> Kind regards!
> Björn
>
> PS. I've attached the in memory hibernate.hbm.xml for the different versions
> as well as the teneo debug output
>
>
>
> "Björn Sundin" <bsu@bergauer.ch> schrieb im Newsbeitrag
> news:f5bgjb$o40$1@build.eclipse.org...
>> Hi Martin,
>>
>> The hbm for the Connectable class looks like this:
>>
>> <class
>> name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Connecta bleImpl "
>> entity-name="Connectable" abstract="true" lazy="false"
>> discriminator-value="Connectable" table="`connectable`">
>> <meta attribute="eclassName">Connectable</meta>
>> <meta
>> attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
>> <id name="id" type="int">
>> <column not-null="true" unique="true" name="`id`"/>
>> <generator class="native"/>
>> </id>
>> <discriminator column="`dtype`" type="string"/>
>> <version name="version" type="int">
>> <column not-null="true" unique="false" name="`version`"/>
>> </version>
>> <property name="name" lazy="false" insert="true" update="true"
>> not-null="false" unique="false" type="java.lang.String">
>> <column not-null="false" unique="false" name="`name`"/>
>> </property>
>> <list name="connections" lazy="true"
>> cascade="delete,merge,persist,save-update,lock,refresh">
>> <key update="true">
>> <column name="`connectable_connections_id`"
> not-null="false"
>> unique="false"/>
>> </key>
>> <list-index column="`connectable_connections_idx`"/>
>> <one-to-many entity-name="Connection"/>
>> </list>
>> </class>
>>
>> In the two console output files I sent as attachment in the first post you
>> can see the complete hbm mapping (generated in memory).
>>
>> Regards
>> Björn
>>
>> "Martin Taal" <mtaal@elver.org> schrieb im Newsbeitrag
>> news:f5b80o$h1a$1@build.eclipse.org...
>>> Hi Bjorn,
>>> And how does the hbm look like for the Connectable class?
>>>
>>> gr. Martin
>>>
>>> Björn Sundin wrote:
>>>> Hi Martin
>>>>
>>>> As far as I can see does this error occur for those tables where I
> don't
>> use
>>>> a synthetic id.
>>>>
>>>> I have defined a DataType AmsetId:
>>>>
>>>> <eClassifiers xsi:type="ecore:EDataType" name="AmsetId"
>>>> instanceClassName="int">
>>>> <eAnnotations source="teneo.jpa">
>>>> <details key="appinfo" value="@Id
>>>> @GeneratedValue(strategy=&quot;AUTO&quot;)"/>
>>>> </eAnnotations>
>>>> </eClassifiers>
>>>>
>>>> This DataType is used in i.e. Connectable:
>>>>
>>>> <eClassifiers xsi:type="ecore:EClass" name="Connectable"
>>>> abstract="true">
>>>> <eStructuralFeatures xsi:type="ecore:EAttribute" name="name"
>>>> eType="ecore:EDataType
>> http://www.eclipse.org/emf/2002/Ecore#//EString"/>
>>>> <eStructuralFeatures xsi:type="ecore:EReference"
>> name="connections"
>>>> upperBound="-1"
>>>> eType="#//Connection" containment="true"/>
>>>> <eStructuralFeatures xsi:type="ecore:EAttribute" name="id"
>>>> unique="false" eType="ecore:EDataType
>>>>
> ..../../ch.bergauer.rcp.amset.system.attributes/model/system datatypes.ecore#/
>> /
>>>> AmsetId"
>>>> iD="true"/>
>>>> <eStructuralFeatures xsi:type="ecore:EAttribute"
> name="version"
>>>> eType="ecore:EDataType
>>>>
> ..../../ch.bergauer.rcp.amset.system.attributes/model/system datatypes.ecore#/
>> /
>>>> AmsetVersion"/>
>>>> </eClassifiers>
>>>>
>>>> The exception is thrown by the
>>>>
> org.apache.derby.impl.sql.compile.TableElementList.validate( DDLStatementNode
>>>> ddlStmt, DataDictionary dd, TableDescriptor td) method:
>>>>
>>>>
>>>>       //check if there are multiple constraints with same set of
> columns
>>>>       if (columnsMatch(cdn.getColumnList().getColumnNames(),
>>>> destColumnNames))
>>>>           throw
>>>>
> StandardException.newException(SQLState.LANG_MULTIPLE_CONSTRAINTS_WITH_SAME_
>>>> COLUMNS,
>>>>                   cdn.getConstraintMoniker(), destName);
>>>> 

>>>>
>>>> The parameters in columnsMatch have the following values:
>>>> cdn.getColumnList().getColumnNames(): (java.lang.String[]) [id]
>>>> destColumnNames: (java.lang.String[]) [id]
>>>>
>>>> The DDLStatementNode parameters in TableElementList.validate looks
> like
>>>> this:
>>>>
>>>>
>>>> connectablestatementType: CREATE TABLE
>>>> tableElementList:
>>>> constraintName: null
>>>> constraintType: 3
>>>> properties: null
>>>> name: SQL070620101614670
>>>>
>>>> dataTypeServices: INTEGER NOT NULL
>>>> defaultValue: null
>>>> name: id
>>>>
>>>> dataTypeServices: VARCHAR(255) NOT NULL
>>>> defaultValue: null
>>>> name: dtype
>>>>
>>>> dataTypeServices: INTEGER NOT NULL
>>>> defaultValue: null
>>>> name: version
>>>>
>>>> dataTypeServices: VARCHAR(255)
>>>> defaultValue: null
>>>> name: name
>>>>
>>>> dataTypeServices: INTEGER
>>>> defaultValue: null
>>>> name: environment_connectables_id
>>>>
>>>> dataTypeServices: INTEGER
>>>> defaultValue: null
>>>> name: environment_connectables_idx
>>>>
>>>> dataTypeServices: VARCHAR(255)
>>>> defaultValue: null
>>>> name: ECONTAINER_CLASS
>>>>
>>>> dataTypeServices: VARCHAR(255)
>>>> defaultValue: null
>>>> name: E_CONTAINER
>>>>
>>>> dataTypeServices: INTEGER
>>>> defaultValue: null
>>>> name: E_CONTAINER_FEATUREID
>>>>
>>>> constraintName: null
>>>> constraintType: 2
>>>> properties: null
>>>> name: SQL070620102737810
>>>>
>>>>
>>>> properties:
>>>> null
>>>> lockGranularity:
>>>> R
>>>> [/ddlStmt]
>>>>
>>>> Regards
>>>> Björn
>>>>
>>>> "Martin Taal" <mtaal@elver.org> schrieb im Newsbeitrag
>>>> news:f56sc0$eml$1@build.eclipse.org...
>>>>> Hi Björn,
>>>>> Some questions:
>>>>> Can you see which columns are present in the constraints of which the
>>>> creation fails?
>>>>> Can you also post the mapping of the "connection" type?
>>>>>
>>>>> gr. Maritn
>>>>>
>>>>> Björn Sundin wrote:
>>>>>> Hello Martin,
>>>>>>
>>>>>> Maybe this could be of any help to you...?
>>>>>>
>>>>>> I upgraded my development enviroment from Eclipse 3.3M5 to Eclipse
>>>> 3.3RC3
>>>>>> today. As I anyway was retrieving newer builds I thought I might as
>>>> well
>>>>>> update Teneo. Until now I have successfully been using Integration
>> Build
>>>>>> I200702130950. Now I downloaded and installed Integration Build
>>>>>> I200704230019.
>>>>>>
>>>>>> As I started up a new project (where a new Derby database gets
>> created)
>>>> I
>>>>>> encountered the following problem while creating the tables:
>>>>>>
>>>>>> [start extract console log]
>>>>>> ....
>>>>>> 10594 [ModalContext] DEBUG
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>> create
>>>>>> table "connectable" ("id" integer not null unique, "dtype"
>> varchar(255)
>>>> not
>>>>>> null, "version" integer not null, "name" varchar(255),
>>>>>> "environment_connectables_id" integer,
> "environment_connectables_idx"
>>>>>> integer, econtainer_class varchar(255), e_container varchar(255),
>>>>>> e_container_featureid integer, primary key ("id"))
>>>> (SchemaUpdate.java:149)
>>>>>> 10625 [ModalContext] ERROR
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>>>> Unsuccessful: create table "connectable" ("id" integer not null
>> unique,
>>>>>> "dtype" varchar(255) not null, "version" integer not null, "name"
>>>>>> varchar(255), "environment_connectables_id" integer,
>>>>>> "environment_connectables_idx" integer, econtainer_class
> varchar(255),
>>>>>> e_container varchar(255), e_container_featureid integer, primary key
>>>> ("id"))
>>>>>> (SchemaUpdate.java:155)
>>>>>> 10625 [ModalContext] ERROR
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>>>> Constraints 'SQL070618024717651' and 'SQL070618024717650' have the
>> same
>>>> set
>>>>>> of columns, which is not allowed. (SchemaUpdate.java:156)
>>>>>> 10625 [ModalContext] DEBUG
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>> create
>>>>>> table "connection" ("id" integer not null unique, "dtype"
> varchar(255)
>>>> not
>>>>>> null, "version" integer not null, "connectable_source_id" integer,
>>>>>> "connectable_target_id" integer, "description" varchar(255), "port"
>>>> integer,
>>>>>> "connectable_connections_id" integer, "connectable_connections_idx"
>>>> integer,
>>>>>> econtainer_class varchar(255), e_container varchar(255),
>>>> e_container_feature
>>>>>> id integer, primary key ("id")) (SchemaUpdate.java:149)
>>>>>> 10625 [ModalContext] ERROR
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>>>> Unsuccessful: create table "connection" ("id" integer not null
> unique,
>>>>>> "dtype" varchar(255) not null, "version" integer not null,
>>>>>> "connectable_source_id" integer, "connectable_target_id" integer,
>>>>>> "description" varchar(255), "port" integer,
>> "connectable_connections_id"
>>>>>> integer, "connectable_connections_idx" integer, econtainer_class
>>>>>> varchar(255), e_container varchar(255), e_container_featureid
> integer,
>>>>>> primary key ("id")) (SchemaUpdate.java:155)
>>>>>> 10625 [ModalContext] ERROR
> rg.hibernate.tool.hbm2ddl.SchemaUpdate -
>>>>>> Constraints 'SQL070618024717671' and 'SQL070618024717670' have the
>> same
>>>> set
>>>>>> of columns, which is not allowed. (SchemaUpdate.java:156)
>>>>>> ....
>>>>>> [end extract console log]
>>>>>>
>>>>>> Needless to say, the application failed to start, so I used
>> Integration
>>>>>> Build I200702130950 again, and the application started as expected.
>>>>>>
>>>>>> Attached you will find both console logs. I used the same model and
>>>>>> generated code and tested this both with code that was generated
>> before
>>>> and
>>>>>> after upgrading EMF and Teneo.
>>>>>>
>>>>>> It is basically no problem for me, as I can continue to use
>> Integration
>>>>>> Build I200702130950, but it might indicate that something has got
>>>> broken?
>>>>>> Kind regards
>>>>>> Bjoern
>>>>>>
>>>>>>
>>>>> --
>>>>>
>>>>> 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
>>>>
>>>
>>> --
>>>
>>> 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
>>
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
>
> <!-- Generated by Teneo on Thu Aug 09 15:22:20 CEST 2007 -->
> <hibernate-mapping auto-import="false">
> <class name=" ch.bergauer.rcp.amset.model.project.attributes.amset.impl.Pr ojectAttributesImpl " entity-name="ProjectAttributes" abstract="false" lazy="false" discriminator-value="ProjectAttributes" table="`projectattributes`">
> <meta attribute="eclassName">ProjectAttributes</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Projectattributes.xmi</meta>
> <id type="long" name="id" column="id" access=" org.eclipse.emf.teneo.hibernate.mapping.identifier.Identifie rPropertyHandler ">
> <meta attribute="syntheticId">true</meta>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <many-to-one name="UserGroups" entity-name="UserGroupCollection" cascade="delete,merge,persist,save-update,lock,refresh" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name="`usergroupcollection_usergroups_e_id`"/>
> </many-to-one>
> <many-to-one name="UserPersons" entity-name="UserPersonCollection" cascade="delete,merge,persist,save-update,lock,refresh" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name="`userpersoncollection_userpersons_e_id`"/>
> </many-to-one>
> </class>
> <class name=" ch.bergauer.rcp.amset.model.project.attributes.amset.impl.Us erGroupCollectionImpl " entity-name="UserGroupCollection" abstract="false" lazy="false" discriminator-value="UserGroupCollection" table="`usergroupcollection`">
> <meta attribute="eclassName">UserGroupCollection</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Projectattributes.xmi</meta>
> <id type="long" name="id" column="id" access=" org.eclipse.emf.teneo.hibernate.mapping.identifier.Identifie rPropertyHandler ">
> <meta attribute="syntheticId">true</meta>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <list name="UserGroupRef" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`usergroupcollection_usergroupref_e_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`usergroupcollection_usergroupref_idx`"/>
> <one-to-many entity-name="UserGroup"/>
> </list>
> </class>
> <class name=" ch.bergauer.rcp.amset.model.project.attributes.amset.impl.Us erPersonCollectionImpl " entity-name="UserPersonCollection" abstract="false" lazy="false" discriminator-value="UserPersonCollection" table="`userpersoncollection`">
> <meta attribute="eclassName">UserPersonCollection</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Projectattributes.xmi</meta>
> <id type="long" name="id" column="id" access=" org.eclipse.emf.teneo.hibernate.mapping.identifier.Identifie rPropertyHandler ">
> <meta attribute="syntheticId">true</meta>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <list name="UserPersonRef" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`userpersoncollection_userpersonref_e_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`userpersoncollection_userpersonref_idx`"/>
> <one-to-many entity-name="UserPerson"/>
> </list>
> </class>
> <class name=" ch.bergauer.rcp.amset.model.project.attributes.amset.impl.Us erGroupImpl " entity-name="UserGroup" abstract="false" lazy="false" discriminator-value="UserGroup" table="`usergroup`">
> <meta attribute="eclassName">UserGroup</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Projectattributes.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <property name="name" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
> <column not-null="true" unique="false" name="`name`"/>
> </property>
> <property name="description" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`description`"/>
> </property>
> <many-to-one name="userTypeRef" entity-name="UserType" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name="`usertype_usertyperef_id`"/>
> </many-to-one>
> </class>
> <class name=" ch.bergauer.rcp.amset.model.project.attributes.amset.impl.Us erPersonImpl " entity-name="UserPerson" abstract="false" lazy="false" discriminator-value="UserPerson" table="`userperson`">
> <meta attribute="eclassName">UserPerson</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Projectattributes.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <property name="name" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
> <column not-null="true" unique="false" name="`name`"/>
> </property>
> <property name="firstname" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`firstname`"/>
> </property>
> <property name="username" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
> <column not-null="true" unique="false" name="`username`"/>
> </property>
> <property name="password" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
> <column not-null="true" unique="false" name="`password`"/>
> </property>
> <many-to-one name="userGroupRef" entity-name="UserGroup" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name="`usergroup_usergroupref_id`"/>
> </many-to-one>
> </class>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Environm entImpl " entity-name="Environment" abstract="false" lazy="false" discriminator-value="Environment" table="`environment`">
> <meta attribute="eclassName">Environment</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <list name="connectables" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`environment_connectables_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`environment_connectables_idx`"/>
> <one-to-many entity-name="Connectable"/>
> </list>
> <property name="name" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`name`"/>
> </property>
> <property name="description" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`description`"/>
> </property>
> </class>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Connecti onImpl " entity-name="Connection" abstract="true" lazy="false" discriminator-value="Connection" table="`connection`">
> <meta attribute="eclassName">Connection</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <many-to-one name="source" entity-name="Connectable" lazy="false" insert="true" update="true" not-null="false">
> <column not-null="false" unique="false" name="`connectable_source_id`"/>
> </many-to-one>
> <many-to-one name="target" entity-name="Connectable" lazy="false" insert="true" update="true" not-null="false">
> <column not-null="false" unique="false" name="`connectable_target_id`"/>
> </many-to-one>
> <property name="description" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`description`"/>
> </property>
> <property name="port" lazy="false" insert="true" update="true" not-null="false" unique="false" type="int">
> <column not-null="false" unique="false" name="`port`"/>
> </property>
> </class>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.IdcConne ctionImpl " entity-name="IdcConnection" abstract="false" lazy="false" extends="Connection" discriminator-value="IdcConnection">
> <meta attribute="eclassName">IdcConnection</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.AmBusCon nectionImpl " entity-name="AmBusConnection" abstract="false" lazy="false" extends="Connection" discriminator-value="AmBusConnection">
> <meta attribute="eclassName">AmBusConnection</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Connecta bleImpl " entity-name="Connectable" abstract="true" lazy="false" discriminator-value="Connectable" table="`connectable`">
> <meta attribute="eclassName">Connectable</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <property name="name" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`name`"/>
> </property>
> <list name="connections" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`connectable_connections_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`connectable_connections_idx`"/>
> <one-to-many entity-name="Connection"/>
> </list>
> </class>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.AmBusImp l " entity-name="AmBus" abstract="false" lazy="false" extends="Connectable" discriminator-value="AmBus">
> <meta attribute="eclassName">AmBus</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name="ch.bergauer.rcp.amset.project.data.nodes.amset.AbstractNode " entity-name="AbstractNode" abstract="true" lazy="false" extends="Connectable" discriminator-value="AbstractNode">
> <meta attribute="eclassName">AbstractNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <list name="ownedDatapoints" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`abstractnode_owneddatapoints_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`abstractnode_owneddatapoints_idx`"/>
> <one-to-many entity-name="Datapoint"/>
> </list>
> <list name="foreignDatapoints" lazy="true" table="`abstractnode_foreigndatapoints`">
> <key update="true">
> <column name="`abstractnode_id`" not-null="true" unique="false"/>
> </key>
> <list-index column="`abstractnode_foreigndatapoints_idx`"/>
> <many-to-many entity-name="Datapoint" unique="false">
> <column name="`datapoint_id`" not-null="true" unique="false"/>
> </many-to-many>
> </list>
> </subclass>
> <subclass name="ch.bergauer.rcp.amset.project.data.nodes.amset.SimpleNode " entity-name="SimpleNode" abstract="true" lazy="false" extends="AbstractNode" discriminator-value="SimpleNode">
> <meta attribute="eclassName">SimpleNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.AmNodeIm pl " entity-name="AmNode" abstract="false" lazy="false" extends="AbstractNode" discriminator-value="AmNode">
> <meta attribute="eclassName">AmNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Illumina tionNodeImpl " entity-name="IlluminationNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="IlluminationNode">
> <meta attribute="eclassName">IlluminationNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.FireDete ctorNodeImpl " entity-name="FireDetectorNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="FireDetectorNode">
> <meta attribute="eclassName">FireDetectorNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.ElsNodeI mpl " entity-name="ElsNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="ElsNode">
> <meta attribute="eclassName">ElsNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.PowerNod eImpl " entity-name="PowerNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="PowerNode">
> <meta attribute="eclassName">PowerNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.RadioNod eImpl " entity-name="RadioNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="RadioNode">
> <meta attribute="eclassName">RadioNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.BlackIce WarningNodeImpl " entity-name="BlackIceWarningNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="BlackIceWarningNode">
> <meta attribute="eclassName">BlackIceWarningNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.GeneralC ommunicationNodeImpl " entity-name="GeneralCommunicationNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="GeneralCommunicationNode">
> <meta attribute="eclassName">GeneralCommunicationNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.RadioCom municationNodeImpl " entity-name="RadioCommunicationNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="RadioCommunicationNode">
> <meta attribute="eclassName">RadioCommunicationNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Communic ationProcessorNodeImpl " entity-name="CommunicationProcessorNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="CommunicationProcessorNode">
> <meta attribute="eclassName">CommunicationProcessorNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Ventilat ionNodeImpl " entity-name="VentilationNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="VentilationNode">
> <meta attribute="eclassName">VentilationNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Auxiliar yNodeImpl " entity-name="AuxiliaryNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="AuxiliaryNode">
> <meta attribute="eclassName">AuxiliaryNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Emergenc yTelephoneNodeImpl " entity-name="EmergencyTelephoneNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="EmergencyTelephoneNode">
> <meta attribute="eclassName">EmergencyTelephoneNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.PumpingS tationNodeImpl " entity-name="PumpingStationNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="PumpingStationNode">
> <meta attribute="eclassName">PumpingStationNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Security NodeImpl " entity-name="SecurityNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="SecurityNode">
> <meta attribute="eclassName">SecurityNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.TestNode Impl " entity-name="TestNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="TestNode">
> <meta attribute="eclassName">TestNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.TrafficN odeImpl " entity-name="TrafficNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="TrafficNode">
> <meta attribute="eclassName">TrafficNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.VideoNod eImpl " entity-name="VideoNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="VideoNode">
> <meta attribute="eclassName">VideoNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.VideoMan agementSystemNodeImpl " entity-name="VideoManagementSystemNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="VideoManagementSystemNode">
> <meta attribute="eclassName">VideoManagementSystemNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <subclass name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.CentralF acilityNodeImpl " entity-name="CentralFacilityNode" abstract="false" lazy="false" extends="SimpleNode" discriminator-value="CentralFacilityNode">
> <meta attribute="eclassName">CentralFacilityNode</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> </subclass>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Datapoin tImpl " entity-name="Datapoint" abstract="false" lazy="false" discriminator-value="Datapoint" table="`datapoint`">
> <meta attribute="eclassName">Datapoint</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <property name="name" lazy="false" insert="true" update="true" not-null="false" unique="false" type="java.lang.String">
> <column not-null="false" unique="false" name="`name`"/>
> </property>
> <many-to-one name="owner" entity-name="AbstractNode" lazy="false" insert="true" update="true" not-null="false">
> <column not-null="false" unique="false" name="`abstractnode_owner_id`"/>
> </many-to-one>
> <list name="datapoints" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`datapoint_datapoints_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`datapoint_datapoints_idx`"/>
> <one-to-many entity-name="Datapoint"/>
> </list>
> <list name="foreignNodes" lazy="true" table="`datapoint_foreignnodes`">
> <key update="true">
> <column name="`datapoint_id`" not-null="true" unique="false"/>
> </key>
> <list-index column="`datapoint_foreignnodes_idx`"/>
> <many-to-many entity-name="AbstractNode" unique="false">
> <column name="`abstractnode_id`" not-null="true" unique="false"/>
> </many-to-many>
> </list>
> <list name="predefinedAttributeValues" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`datapoint_predefinedattributevalues_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`datapoint_predefinedattributevalues_idx`"/>
> <one-to-many entity-name="PredefinedAttributeValue"/>
> </list>
> <list name="textAttributeValues" lazy="true" cascade="delete,merge,persist,save-update,lock,refresh">
> <key update="true">
> <column name="`datapoint_textattributevalues_id`" not-null="false" unique="false"/>
> </key>
> <list-index column="`datapoint_textattributevalues_idx`"/>
> <one-to-many entity-name="TextAttributeValue"/>
> </list>
> </class>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.TextAttr ibuteValueImpl " entity-name="TextAttributeValue" abstract="false" lazy="false" discriminator-value="TextAttributeValue" table="`textattributevalue`">
> <meta attribute="eclassName">TextAttributeValue</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <property name="name" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
> <column not-null="true" unique="false" name="`name`"/>
> </property>
> <many-to-one name="datapointAttributeDefinitionRef" entity-name="DatapointAttributeDefinition" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name=" `datapointattributedefinition_datapointattributedefinitionre f_id` "/>
> </many-to-one>
> </class>
> <class name=" ch.bergauer.rcp.amset.project.data.nodes.amset.impl.Predefin edAttributeValueImpl " entity-name="PredefinedAttributeValue" abstract="false" lazy="false" discriminator-value="PredefinedAttributeValue" table="`predefinedattributevalue`">
> <meta attribute="eclassName">PredefinedAttributeValue</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Nodeprojectdata.xmi</meta>
> <id name="id" type="int">
> <column not-null="true" unique="true" name="`id`"/>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <version name="version" type="int">
> <column not-null="true" unique="false" name="`version`"/>
> </version>
> <many-to-one name="attributeValueDefinition" entity-name="AttributeValueDefinition" lazy="false" insert="true" update="true" not-null="true">
> <column not-null="true" unique="false" name="`attributevaluedefinition_attributevaluedefinition_id` "/>
> </many-to-one>
> </class>
> <class name=" ch.bergauer.rcp.amset.model.system.attributes.amset.impl.Sys temAttributesImpl " entity-name="SystemAttributes" abstract="false" lazy="false" discriminator-value="SystemAttributes" table="`systemattributes`">
> <meta attribute="eclassName">SystemAttributes</meta>
> <meta attribute="epackage">http://www.bergauer.ch/Systemattributes.xmi</meta>
> <id type="long" name="id" column="id" access=" org.eclipse.emf.teneo.hibernate.mapping.identifier.Identifie rPropertyHandler ">
> <meta attribute="syntheticId">true</meta>
> <generator class="native"/>
> </id>
> <discriminator column="`dtype`" type="string"/>
> <many-to-one name="dataTypes" entity-name="DataTypeCollection" cascade="del
Re: [Teneo] Create table fails in Integration Build I200704230019 [message #609456 is a reply to message #92990] Fri, 10 August 2007 12:55 Go to previous message
Eclipse UserFriend
Originally posted by: bsu.bergauer.ch

Done: Bug 199555

Wenn will a corrected version be available?

Regards
Bj
Previous Topic:Re: How can I use EMF Compare programatically
Next Topic:Re: How can I use EMF Compare programatically
Goto Forum:
  


Current Time: Sat Aug 20 06:07:42 GMT 2022

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

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

Back to the top