Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » [Teneo] Hibernate 4.1 has Trouble with Booleans
[Teneo] Hibernate 4.1 has Trouble with Booleans [message #881299] Mon, 04 June 2012 05:57 Go to next message
Flavio Donze is currently offline Flavio Donze
Messages: 157
Registered: July 2009
Location: Switzerland
Senior Member
Hi Martin

I trying to update to Teneo 2.0.0 and Hibernate 4.1. Using Eclipse 3.7.2, EMF 2.7.2.

I came acrosse a few problems and with this one I'm stuck. Getting a lot of errors durring startup:

ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [accesscontrolentry] ([id] nvarchar(255) not null, [domain] int, [context] nvarchar(255), [objectid] nvarchar(255), [objecttype] nvarchar(255), [granted] boolean, [permission] nvarchar(255), [user] nvarchar(255), [group] nvarchar(255), [origin] nvarchar(255), primary key ([id]))
ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable Nr. '6' wurde nicht gefunden.
ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [attribute] ([id] nvarchar(255) not null, [objectid] nvarchar(255), [namespace] nvarchar(255), [name] nvarchar(255), [binarydata] boolean, [value] nvarchar(1000), primary key ([id]))
ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable Nr. '5' wurde nicht gefunden.
ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [code] ([id] nvarchar(255) not null, [basiccode_parent_id] nvarchar(255), [names] nvarchar(2000), [descriptions] nvarchar(2000), [sorthint] int, [active] boolean, primary key ([id]))
ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable Nr. '6' wurde nicht gefunden.
ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [embeddedpart] ([id] nvarchar(255) not null, [domain] int, [locale] nvarchar(255), [documentid] nvarchar(255), [code_printformat_id] nvarchar(255), [resource] nvarchar(255), [targetblank] boolean, primary key ([id]))
ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable Nr. '7' wurde nicht gefunden.
ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [information] ([id] nvarchar(255) not null, [domain] int, [locale] nvarchar(255), [name] nvarchar(500), [description] nvarchar(1000), [richdescription] nvarchar(max), [objectref_owner_id] nvarchar(255), [objectref_responsible_id] nvarchar(255), [symbol] nvarchar(255), [code_phase_id] nvarchar(255), [validbegin] datetime, [validend] datetime, [createdate] datetime, [objectref_creator_id] nvarchar(255), [url] nvarchar(2048), [glossary] boolean, primary key ([id]))
ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable Nr. '16' wurde nicht gefunden.
...........

Seems like Hibernate has trouble with booleans.
German: Der boolean-Datentyp für die Spalte, den Parameter oder die Variable Nr. '6' wurde nicht gefunden.
English: The boolean Datatype for the column, the Parameter or the Variable Nr. '6' was not found.

Here is one of the problem classifier.
  <eClassifiers xsi:type="ecore:EClass" name="Attribute">
    <eAnnotations source="http:///www.softmodeler.com/model/annotation/REF">
      <details key="enabled" value="false"/>
    </eAnnotations>
    <eStructuralFeatures xsi:type="ecore:EAttribute" name="id" eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString"
        defaultValueLiteral="" iD="true"/>
    <eStructuralFeatures xsi:type="ecore:EAttribute" name="objectId" unique="false"
        eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString" defaultValueLiteral="">
      <eAnnotations source="http:///www.softmodeler.com/model/annotation/Validate">
        <details key="validator" value="required"/>
      </eAnnotations>
    </eStructuralFeatures>
    <eStructuralFeatures xsi:type="ecore:EAttribute" name="namespace" unique="false"
        eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString" defaultValueLiteral="">
      <eAnnotations source="http:///www.softmodeler.com/model/annotation/Validate">
        <details key="validator" value="required"/>
      </eAnnotations>
    </eStructuralFeatures>
    <eStructuralFeatures xsi:type="ecore:EAttribute" name="name" unique="false" eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString"
        defaultValueLiteral="">
      <eAnnotations source="http:///www.softmodeler.com/model/annotation/Validate">
        <details key="validator" value="required"/>
      </eAnnotations>
    </eStructuralFeatures>
    <eStructuralFeatures xsi:type="ecore:EAttribute" name="binaryData" eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EBoolean"
        defaultValueLiteral="false"/>
    <eStructuralFeatures xsi:type="ecore:EAttribute" name="value" eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString">
      <eAnnotations source="teneo.jpa">
        <details key="value" value="@Column(length=1000)&#xD;&#xA;"/>
      </eAnnotations>
    </eStructuralFeatures>
  </eClassifiers>


Any Clue how to solve this?

Greets
Flavio


Organisations- und Prozessdokumentation Software
Qualität Management QMS :: Information Management IMS
http://www.scodi.ch
Re: [Teneo] Hibernate 4.1 has Trouble with Booleans [message #881318 is a reply to message #881299] Mon, 04 June 2012 06:32 Go to previous messageGo to next message
Erdal Karaca is currently offline Erdal Karaca
Messages: 740
Registered: July 2009
Senior Member
Having same problems...

See here for cross posting:

http://www.eclipse.org/forums/index.php/m/881316/#msg_881316
Re: [Teneo] Hibernate 4.1 has Trouble with Booleans [message #881323 is a reply to message #881299] Mon, 04 June 2012 06:35 Go to previous messageGo to next message
Martin Taal is currently offline Martin Taal
Messages: 5329
Registered: July 2009
Senior Member
Hi Flavio,
Which database, jdbc driver and which hibernate dialect are you using?

gr. Martin

On 06/04/2012 11:57 AM, Flavio Donze wrote:
> Hi Martin
>
> I trying to update to Teneo 2.0.0 and Hibernate 4.1. Using Eclipse 3.7.2, EMF 2.7.2.
>
> I came acrosse a few problems and with this one I'm stuck. Getting a lot of errors durring startup:
>
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [accesscontrolentry] ([id]
> nvarchar(255) not null, [domain] int, [context] nvarchar(255), [objectid] nvarchar(255), [objecttype] nvarchar(255),
> [granted] boolean, [permission] nvarchar(255), [user] nvarchar(255), [group] nvarchar(255), [origin] nvarchar(255),
> primary key ([id]))
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable
> Nr. '6' wurde nicht gefunden.
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [attribute] ([id] nvarchar(255)
> not null, [objectid] nvarchar(255), [namespace] nvarchar(255), [name] nvarchar(255), [binarydata] boolean, [value]
> nvarchar(1000), primary key ([id]))
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable
> Nr. '5' wurde nicht gefunden.
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [code] ([id] nvarchar(255) not
> null, [basiccode_parent_id] nvarchar(255), [names] nvarchar(2000), [descriptions] nvarchar(2000), [sorthint] int,
> [active] boolean, primary key ([id]))
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable
> Nr. '6' wurde nicht gefunden.
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [embeddedpart] ([id]
> nvarchar(255) not null, [domain] int, [locale] nvarchar(255), [documentid] nvarchar(255), [code_printformat_id]
> nvarchar(255), [resource] nvarchar(255), [targetblank] boolean, primary key ([id]))
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable
> Nr. '7' wurde nicht gefunden.
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [information] ([id] nvarchar(255)
> not null, [domain] int, [locale] nvarchar(255), [name] nvarchar(500), [description] nvarchar(1000), [richdescription]
> nvarchar(max), [objectref_owner_id] nvarchar(255), [objectref_responsible_id] nvarchar(255), [symbol] nvarchar(255),
> [code_phase_id] nvarchar(255), [validbegin] datetime, [validend] datetime, [createdate] datetime, [objectref_creator_id]
> nvarchar(255), [url] nvarchar(2048), [glossary] boolean, primary key ([id]))
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable
> Nr. '16' wurde nicht gefunden.
> ...........
>
> Seems like Hibernate has trouble with booleans. German: Der boolean-Datentyp für die Spalte, den Parameter oder die
> Variable Nr. '6' wurde nicht gefunden.
> English: The boolean Datatype for the column, the Parameter or the Variable Nr. '6' was not found.
>
> Here is one of the problem classifier.
>
> <eClassifiers xsi:type="ecore:EClass" name="Attribute">
> <eAnnotations source="http:///www.softmodeler.com/model/annotation/REF">
> <details key="enabled" value="false"/>
> </eAnnotations>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="id" eType="ecore:EDataType
> http://www.eclipse.org/emf/2002/Ecore#//EString"
> defaultValueLiteral="" iD="true"/>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="objectId" unique="false"
> eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString" defaultValueLiteral="">
> <eAnnotations source="http:///www.softmodeler.com/model/annotation/Validate">
> <details key="validator" value="required"/>
> </eAnnotations>
> </eStructuralFeatures>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="namespace" unique="false"
> eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString" defaultValueLiteral="">
> <eAnnotations source="http:///www.softmodeler.com/model/annotation/Validate">
> <details key="validator" value="required"/>
> </eAnnotations>
> </eStructuralFeatures>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="name" unique="false" eType="ecore:EDataType
> http://www.eclipse.org/emf/2002/Ecore#//EString"
> defaultValueLiteral="">
> <eAnnotations source="http:///www.softmodeler.com/model/annotation/Validate">
> <details key="validator" value="required"/>
> </eAnnotations>
> </eStructuralFeatures>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="binaryData" eType="ecore:EDataType
> http://www.eclipse.org/emf/2002/Ecore#//EBoolean"
> defaultValueLiteral="false"/>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="value" eType="ecore:EDataType
> http://www.eclipse.org/emf/2002/Ecore#//EString">
> <eAnnotations source="teneo.jpa">
> <details key="value" value="@Column(length=1000)
> "/>
> </eAnnotations>
> </eStructuralFeatures>
> </eClassifiers>
>
>
> Any Clue how to solve this?
>
> Greets
> Flavio


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@xxxxxxxx - mtaal@xxxxxxxx
Web: www.springsite.com - www.elver.org
Re: [Teneo] Hibernate 4.1 has Trouble with Booleans [message #881330 is a reply to message #881299] Mon, 04 June 2012 06:54 Go to previous messageGo to next message
Martin Taal is currently offline Martin Taal
Messages: 5329
Registered: July 2009
Senior Member
Hi Flavio,
It seems to be this issue:
https://hibernate.onjira.com/browse/HHH-6420

Can you switch to this dialect:
org.hibernate.dialect.SQLServer2008Dialect

gr. Martin

On 06/04/2012 11:57 AM, Flavio Donze wrote:
> Hi Martin
>
> I trying to update to Teneo 2.0.0 and Hibernate 4.1. Using Eclipse 3.7.2, EMF 2.7.2.
>
> I came acrosse a few problems and with this one I'm stuck. Getting a lot of errors durring startup:
>
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [accesscontrolentry] ([id]
> nvarchar(255) not null, [domain] int, [context] nvarchar(255), [objectid] nvarchar(255), [objecttype] nvarchar(255),
> [granted] boolean, [permission] nvarchar(255), [user] nvarchar(255), [group] nvarchar(255), [origin] nvarchar(255),
> primary key ([id]))
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable
> Nr. '6' wurde nicht gefunden.
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [attribute] ([id] nvarchar(255)
> not null, [objectid] nvarchar(255), [namespace] nvarchar(255), [name] nvarchar(255), [binarydata] boolean, [value]
> nvarchar(1000), primary key ([id]))
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable
> Nr. '5' wurde nicht gefunden.
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [code] ([id] nvarchar(255) not
> null, [basiccode_parent_id] nvarchar(255), [names] nvarchar(2000), [descriptions] nvarchar(2000), [sorthint] int,
> [active] boolean, primary key ([id]))
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable
> Nr. '6' wurde nicht gefunden.
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [embeddedpart] ([id]
> nvarchar(255) not null, [domain] int, [locale] nvarchar(255), [documentid] nvarchar(255), [code_printformat_id]
> nvarchar(255), [resource] nvarchar(255), [targetblank] boolean, primary key ([id]))
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable
> Nr. '7' wurde nicht gefunden.
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: create table [information] ([id] nvarchar(255)
> not null, [domain] int, [locale] nvarchar(255), [name] nvarchar(500), [description] nvarchar(1000), [richdescription]
> nvarchar(max), [objectref_owner_id] nvarchar(255), [objectref_responsible_id] nvarchar(255), [symbol] nvarchar(255),
> [code_phase_id] nvarchar(255), [validbegin] datetime, [validend] datetime, [createdate] datetime, [objectref_creator_id]
> nvarchar(255), [url] nvarchar(2048), [glossary] boolean, primary key ([id]))
> ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Der boolean-Datentyp für die Spalte, den Parameter oder die Variable
> Nr. '16' wurde nicht gefunden.
> ...........
>
> Seems like Hibernate has trouble with booleans. German: Der boolean-Datentyp für die Spalte, den Parameter oder die
> Variable Nr. '6' wurde nicht gefunden.
> English: The boolean Datatype for the column, the Parameter or the Variable Nr. '6' was not found.
>
> Here is one of the problem classifier.
>
> <eClassifiers xsi:type="ecore:EClass" name="Attribute">
> <eAnnotations source="http:///www.softmodeler.com/model/annotation/REF">
> <details key="enabled" value="false"/>
> </eAnnotations>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="id" eType="ecore:EDataType
> http://www.eclipse.org/emf/2002/Ecore#//EString"
> defaultValueLiteral="" iD="true"/>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="objectId" unique="false"
> eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString" defaultValueLiteral="">
> <eAnnotations source="http:///www.softmodeler.com/model/annotation/Validate">
> <details key="validator" value="required"/>
> </eAnnotations>
> </eStructuralFeatures>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="namespace" unique="false"
> eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString" defaultValueLiteral="">
> <eAnnotations source="http:///www.softmodeler.com/model/annotation/Validate">
> <details key="validator" value="required"/>
> </eAnnotations>
> </eStructuralFeatures>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="name" unique="false" eType="ecore:EDataType
> http://www.eclipse.org/emf/2002/Ecore#//EString"
> defaultValueLiteral="">
> <eAnnotations source="http:///www.softmodeler.com/model/annotation/Validate">
> <details key="validator" value="required"/>
> </eAnnotations>
> </eStructuralFeatures>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="binaryData" eType="ecore:EDataType
> http://www.eclipse.org/emf/2002/Ecore#//EBoolean"
> defaultValueLiteral="false"/>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="value" eType="ecore:EDataType
> http://www.eclipse.org/emf/2002/Ecore#//EString">
> <eAnnotations source="teneo.jpa">
> <details key="value" value="@Column(length=1000)
> "/>
> </eAnnotations>
> </eStructuralFeatures>
> </eClassifiers>
>
>
> Any Clue how to solve this?
>
> Greets
> Flavio


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@xxxxxxxx - mtaal@xxxxxxxx
Web: www.springsite.com - www.elver.org
Re: [Teneo] Hibernate 4.1 has Trouble with Booleans [message #881357 is a reply to message #881323] Mon, 04 June 2012 07:55 Go to previous messageGo to next message
Flavio Donze is currently offline Flavio Donze
Messages: 157
Registered: July 2009
Location: Switzerland
Senior Member
Hi Martin,

Yes that fixed it! I was using SQLServerDialect.
Thank you!

Now that the tables are created, I'm at a problem I already stated in the Hibernate Forum: https://forum.hibernate.org/viewtopic.php?f=1&t=1015706

Getting a lot of these messages:
WARN: org.hibernate.ejb.AbstractEntityManagerImpl - HHH000326: Cannot join transaction: do not override hibernate.transaction.factory_class

Any idea how I could solve this one?
I'm not even setting the "hibernate.transaction.factory_class" property.

greets
Flavio


Organisations- und Prozessdokumentation Software
Qualität Management QMS :: Information Management IMS
http://www.scodi.ch
Re: [Teneo] Hibernate 4.1 has Trouble with Booleans [message #881377 is a reply to message #881357] Mon, 04 June 2012 08:39 Go to previous messageGo to next message
Martin Taal is currently offline Martin Taal
Messages: 5329
Registered: July 2009
Senior Member
Hi Flavio,
Sorry no idea... but if you find a solution/workaround it would be great if you can publish it here (maybe setting the
mentioned option helps?).

gr. Martin

On 06/04/2012 01:55 PM, Flavio Donze wrote:
> Hi Martin,
> Yes that fixed it! I was using SQLServerDialect.
> Thank you!
>
> Now that the tables are created, I'm at a problem I already stated in the Hibernate Forum:
> https://forum.hibernate.org/viewtopic.php?f=1&t=1015706
>
> Getting a lot of these messages:
> WARN: org.hibernate.ejb.AbstractEntityManagerImpl - HHH000326: Cannot join transaction: do not override
> hibernate.transaction.factory_class
>
> Any idea how I could solve this one?
> I'm not even setting the "hibernate.transaction.factory_class" property.
>
> greets
> Flavio


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@xxxxxxxx - mtaal@xxxxxxxx
Web: www.springsite.com - www.elver.org
Re: [Teneo] Hibernate 4.1 has Trouble with Booleans [message #881833 is a reply to message #881377] Tue, 05 June 2012 06:38 Go to previous message
Flavio Donze is currently offline Flavio Donze
Messages: 157
Registered: July 2009
Location: Switzerland
Senior Member
Hi Martin

It was actually a problem of our Software at some place we called EntityManager.joinTransaction(), which is not required anymore in Hibernate 4.1.

I did have to set the following property to get CMT to work.
<prop key="hibernate.transaction.factory_class">org.hibernate.engine.transaction.internal.jta.CMTTransactionFactory</prop>

greets
Flavio


Organisations- und Prozessdokumentation Software
Qualität Management QMS :: Information Management IMS
http://www.scodi.ch
Previous Topic:Texo ModelPackage already registered
Next Topic:[TEXO] Enum values
Goto Forum:
  


Current Time: Sun Aug 31 04:27:15 EDT 2014

Powered by FUDForum. Page generated in 0.10712 seconds