Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » Teneo with IBM DB2
Teneo with IBM DB2 [message #486126] Wed, 16 September 2009 12:26 Go to next message
Eclipse UserFriend
Originally posted by: tmetzmac.gmail.com

Hello,
I would like to talk about teneo my data on a db2 database to save. First I tried this with H2DB un MySQL, which worked well.
In the experiment using DB2, I always get this error:

ERROR Unsuccessful: create table APP."ecore_eobject" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "visible" smallint, "type" varchar(255), "element_type" varchar(255), "element_id" bigint, "edge_source_e_id" bigint, "edge_target_e_id" bigint, "bendpoints_bendpoints_e_id" bigint, "anchor_sourceanchor_e_id" bigint, "anchor_targetanchor_e_id" bigint, "layoutconstraint_layoutconstraint_e_id" bigint, "name" varchar(255), "measurementunit" varchar(255), "fontcolor" integer, "fontname" varchar(255), "fontheight" integer, "bold" smallint, "italic" smallint, "underline" smallint, "strikethrough" smallint, "description" varchar(255), "fillcolor" integer, "transparency" integer, "gradient" varchar(255), "linecolor" integer, "linewidth" integer, "collapsed" smallint, "canonical" smallint, "showtitle" smallint, "sorting" varchar(255), "sortingkeys" varchar(255), "filtering" varchar(255), "filteringkeys" varchar(255), "routing" varchar(255), "smoothness" varchar(255), "avoidobstructions" smallint, "closestdistance" smallint, "jumplinkstatus" varchar(255), "jumplinktype" varchar(255), "jumplinksreverse" smallint, "roundedbendpointsradius" integer, "pagex" integer, "pagey" integer, "pagewidth" integer, "pageheight" integer, "ordered" smallint, "unique" smallint, "lowerbound" integer, "upperbound" integer, "eclassifier_etype_e_id" bigint, "egenerictype_egenerictype_e_id" bigint, "changeable" smallint, "volatile" smallint, "transient" smallint, "defaultvalueliteral" varchar(255), "unsettable" smallint, "derived" smallint, "estructuralfeature_econtainingclass_e_id" bigint, "id" smallint, "source" varchar(255), "eannotation_emodelelement_e_id" bigint, "instanceclassname" varchar(255), "instancetypename" varchar(255), "eclassifier_epackage_e_id" bigint, "abstract" smallint, "interface" smallint, "serializable" smallint, "value" integer, "literal" varchar(255), "eenumliteral_eenum_e_id" bigint, "eoperation_econtainingclass_e_id" bigint, "nsuri" varchar(255), "nsprefix" varchar(255), "epackage_esuperpackage_e_id" bigint, "eparameter_eoperation_e_id" bigint, "containment" smallint, "resolveproxies" smallint, "ereference_eopposite_e_id" bigint, "egenerictype_eupperbound_e_id" bigint, "egenerictype_elowerbound_e_id" bigint, "etypeparameter_etypeparameter_e_id" bigint, "eclassifier_eclassifier_e_id" bigint, "emodelelement_eannotations_idx" integer, "view_children_e_id" bigint, "view_children_idx" integer, "diagram_edges_e_id" bigint, "diagram_edges_idx" integer, "eclassifier_etypeparameters_e_id" bigint, "eclassifier_etypeparameters_idx" integer, "eclass_eoperations_idx" integer, "eclass_estructuralfeatures_idx" integer, "eclass_egenericsupertypes_e_id" bigint, "eclass_egenericsupertypes_idx" integer, "eenum_eliterals_idx" integer, "eoperation_etypeparameters_e_id" bigint, "eoperation_etypeparameters_idx" integer, "eoperation_eparameters_idx" integer, "eoperation_egenericexceptions_e_id" bigint, "eoperation_egenericexceptions_idx" integer, "epackage_eclassifiers_idx" integer, "epackage_esubpackages_idx" integer, "egenerictype_etypearguments_e_id" bigint, "egenerictype_etypearguments_idx" integer, "etypeparameter_ebounds_e_id" bigint, "etypeparameter_ebounds_idx" integer, econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
ERROR DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;USER, DRIVER=3.57.86
ERROR Unsuccessful: create table APP."featurechange" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "featurename" varchar(255), "datavalue" varchar(2147483647), "set" smallint, feature varchar(255) not null, "referencevalue_type" varchar(255), "referencevalue_id" bigint, "changedescription_objectchanges_e_id" bigint, idx bigint, primary key (e_id))
ERROR DB2 SQL Error: SQLCODE=-604, SQLSTATE=42611, SQLERRMC=varchar(2147483647), DRIVER=3.57.86
ERROR Unsuccessful: create table APP."imageproxy" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "image" blob(2147483647), econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
ERROR DB2 SQL Error: SQLCODE=-355, SQLSTATE=42993, SQLERRMC=image, DRIVER=3.57.86
ERROR Unsuccessful: create table APP."standard" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "name" varchar(255) not null, "datum" timestamp, "bearbeiter" varchar(255), "anbieter" varchar(255), "nummer" integer, "beschreibung" varchar(255), "typ_standardtyp_e_id" bigint, "freigabe_standardfreigabe_e_id" bigint, "einheit_standardeinheitspalte1_e_id" bigint, "einheit_standardeinheitspalte2_e_id" bigint, "image" blob(2147483647), "roi1darea_standard_e_id" bigint, "roi1darea_standard_idx" integer, "standardcontainer_standards_e_id" bigint, "standardcontainer_standards_idx" integer, econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
ERROR DB2 SQL Error: SQLCODE=-355, SQLSTATE=42993, SQLERRMC=image, DRIVER=3.57.86
ERROR Unsuccessful: create table APP."style" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "fillcolor" integer, "transparency" integer, "gradient" varchar(255), "linecolor" integer, "linewidth" integer, "fontcolor" integer, "fontname" varchar(255), "fontheight" integer, "bold" smallint, "italic" smallint, "underline" smallint, "strikethrough" smallint, "showtitle" smallint, "sorting" varchar(255), "sortingkeys" varchar(255), "description" varchar(255), "routing" varchar(255), "smoothness" varchar(255), "avoidobstructions" smallint, "closestdistance" smallint, "jumplinkstatus" varchar(255), "jumplinktype" varchar(255), "jumplinksreverse" smallint, "roundedbendpointsradius" integer, "canonical" smallint, "pagex" integer, "pagey" integer, "pagewidth" integer, "pageheight" integer, "collapsed" smallint, "filtering" varchar(255), "filteringkeys" varchar(255), "antialias" smallint, "maintainaspectratio" smallint, "bounds_cropbound_e_id" bigint, "image_imagebuffer_e_id" bigint, "name" varchar(255), "edatatype_instancetype_e_id" bigint, "rawvalue" varchar(255), "intvalue" integer, "booleanvalue" smallint, "doublevalue" double, "stringvalue" varchar(255), "eobjectvalue_type" varchar(255), "eobjectvalue_id" bigint, "diagram_diagramlink_e_id" bigint, "hint" varchar(255), "textalignment" varchar(255), "linetype" varchar(255), "arrowsource" varchar(255), "arrowtarget" varchar(255), "view_styles_e_id" bigint, "view_styles_idx" integer, econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
ERROR DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;USER, DRIVER=3.57.86
ERROR Unsuccessful: create table APP.details ("eannotation_details_e_id" bigint, elt varchar(255), idx varchar(255) not null, primary key ("eannotation_details_e_id", idx))
ERROR DB2 SQL Error: SQLCODE=-542, SQLSTATE=42831, SQLERRMC=eannotation_details_e_id, DRIVER=3.57.86
ERROR Unsuccessful: create table APP.nodeMap ("guide_nodemap_e_id" bigint, elt varchar(255), idx bigint not null, primary key ("guide_nodemap_e_id", idx))
ERROR DB2 SQL Error: SQLCODE=-542, SQLSTATE=42831, SQLERRMC=guide_nodemap_e_id, DRIVER=3.57.86
ERROR Unsuccessful: alter table APP."anytype" add constraint simpleanytype_instancetype foreign key ("edatatype_instancetype_e_id") references APP."ecore_eobject"
ERROR DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=APP.ecore_eobject, DRIVER=3.57.86
ERROR Unsuccessful: alter table APP."area" add constraint mwlinearea_standard foreign key ("standard_standard_e_id") references APP."standard"
ERROR DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=APP.standard, DRIVER=3.57.86
....

and so on ...

My preferences:

props.setProperty(Environment.DIALECT, "org.hibernate.dialect.DB2Dialect");
props.setProperty(Environment.DRIVER, "com.ibm.db2.jcc.DB2Driver");
props.setProperty(Environment.AUTOCOMMIT, "false");
props.setProperty(Environment.HBM2DDL_AUTO, "update");

What is the problem?
Re: Teneo with IBM DB2 [message #486139 is a reply to message #486126] Wed, 16 September 2009 13:48 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Thomet,
I am sorry but I have no idea what all these db2 error codes mean...

btw, support for teneo is now given on the main EMF newsgroup which I added to the cc.

gr. Martin

Thomet wrote:
> Hello,
> I would like to talk about teneo my data on a db2 database to save. First I tried this with H2DB un MySQL, which worked well.
> In the experiment using DB2, I always get this error:
>
> ERROR Unsuccessful: create table APP."ecore_eobject" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "visible" smallint, "type" varchar(255), "element_type" varchar(255), "element_id" bigint, "edge_source_e_id" bigint, "edge_target_e_id" bigint, "bendpoints_bendpoints_e_id" bigint, "anchor_sourceanchor_e_id" bigint, "anchor_targetanchor_e_id" bigint, "layoutconstraint_layoutconstraint_e_id" bigint, "name" varchar(255), "measurementunit" varchar(255), "fontcolor" integer, "fontname" varchar(255), "fontheight" integer, "bold" smallint, "italic" smallint, "underline" smallint, "strikethrough" smallint, "description" varchar(255), "fillcolor" integer, "transparency" integer, "gradient" varchar(255), "linecolor" integer, "linewidth" integer, "collapsed" smallint, "canonical" smallint, "showtitle" smallint, "sorting" varchar(255), "sortingkeys" varchar(255), "filtering" varchar(255), "filteringkeys" varchar(255), "routing"
varchar(255), "smoothness" varchar(255), "avoidobstructions" smallint, "closestdistance" smallint, "jumplinkstatus" varchar(255), "jumplinktype" varchar(255), "jumplinksreverse" smallint, "roundedbendpointsradius" integer, "pagex" integer, "pagey" integer, "pagewidth" integer, "pageheight" integer, "ordered" smallint, "unique" smallint, "lowerbound" integer, "upperbound" integer, "eclassifier_etype_e_id" bigint, "egenerictype_egenerictype_e_id" bigint, "changeable" smallint, "volatile" smallint, "transient" smallint, "defaultvalueliteral" varchar(255), "unsettable" smallint, "derived" smallint, "estructuralfeature_econtainingclass_e_id" bigint, "id" smallint, "source" varchar(255), "eannotation_emodelelement_e_id" bigint, "instanceclassname" varchar(255), "instancetypename" varchar(255), "eclassifier_epackage_e_id" bigint, "abstract" smallint, "interface" smallint, "serializable" smallint, "value" integer, "literal" varchar(255), "eenumliteral_eenum_e_id" bigint, "eoperation
_econtainingclass_e_id" bigint, "nsuri" varchar(255), "nsprefix" varchar(255), "epackage_esuperpackage_e_id" bigint, "eparameter_eoperation_e_id" bigint, "containment" smallint, "resolveproxies" smallint, "ereference_eopposite_e_id" bigint, "egenerictype_eupperbound_e_id" bigint, "egenerictype_elowerbound_e_id" bigint, "etypeparameter_etypeparameter_e_id" bigint, "eclassifier_eclassifier_e_id" bigint, "emodelelement_eannotations_idx" integer, "view_children_e_id" bigint, "view_children_idx" integer, "diagram_edges_e_id" bigint, "diagram_edges_idx" integer, "eclassifier_etypeparameters_e_id" bigint, "eclassifier_etypeparameters_idx" integer, "eclass_eoperations_idx" integer, "eclass_estructuralfeatures_idx" integer, "eclass_egenericsupertypes_e_id" bigint, "eclass_egenericsupertypes_idx" integer, "eenum_eliterals_idx" integer, "eoperation_etypeparameters_e_id" bigint, "eoperation_etypeparameters_idx" integer, "eoperation_eparameters_idx" integer, "eoperation_egenericexceptions
_e_id" bigint, "eoperation_egenericexceptions_idx" integer, "epackage_eclassifiers_idx" integer, "epackage_esubpackages_idx" integer, "egenerictype_etypearguments_e_id" bigint, "egenerictype_etypearguments_idx" integer, "etypeparameter_ebounds_e_id" bigint, "etypeparameter_ebounds_idx" integer, econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
> ERROR DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;USER, DRIVER=3.57.86
> ERROR Unsuccessful: create table APP."featurechange" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "featurename" varchar(255), "datavalue" varchar(2147483647), "set" smallint, feature varchar(255) not null, "referencevalue_type" varchar(255), "referencevalue_id" bigint, "changedescription_objectchanges_e_id" bigint, idx bigint, primary key (e_id))
> ERROR DB2 SQL Error: SQLCODE=-604, SQLSTATE=42611, SQLERRMC=varchar(2147483647), DRIVER=3.57.86
> ERROR Unsuccessful: create table APP."imageproxy" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "image" blob(2147483647), econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
> ERROR DB2 SQL Error: SQLCODE=-355, SQLSTATE=42993, SQLERRMC=image, DRIVER=3.57.86
> ERROR Unsuccessful: create table APP."standard" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "name" varchar(255) not null, "datum" timestamp, "bearbeiter" varchar(255), "anbieter" varchar(255), "nummer" integer, "beschreibung" varchar(255), "typ_standardtyp_e_id" bigint, "freigabe_standardfreigabe_e_id" bigint, "einheit_standardeinheitspalte1_e_id" bigint, "einheit_standardeinheitspalte2_e_id" bigint, "image" blob(2147483647), "roi1darea_standard_e_id" bigint, "roi1darea_standard_idx" integer, "standardcontainer_standards_e_id" bigint, "standardcontainer_standards_idx" integer, econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
> ERROR DB2 SQL Error: SQLCODE=-355, SQLSTATE=42993, SQLERRMC=image, DRIVER=3.57.86
> ERROR Unsuccessful: create table APP."style" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "fillcolor" integer, "transparency" integer, "gradient" varchar(255), "linecolor" integer, "linewidth" integer, "fontcolor" integer, "fontname" varchar(255), "fontheight" integer, "bold" smallint, "italic" smallint, "underline" smallint, "strikethrough" smallint, "showtitle" smallint, "sorting" varchar(255), "sortingkeys" varchar(255), "description" varchar(255), "routing" varchar(255), "smoothness" varchar(255), "avoidobstructions" smallint, "closestdistance" smallint, "jumplinkstatus" varchar(255), "jumplinktype" varchar(255), "jumplinksreverse" smallint, "roundedbendpointsradius" integer, "canonical" smallint, "pagex" integer, "pagey" integer, "pagewidth" integer, "pageheight" integer, "collapsed" smallint, "filtering" varchar(255), "filteringkeys" varchar(255), "antialias" smallint, "maintainaspectratio" smallint, "bounds
_cropbound_e_id" bigint, "image_imagebuffer_e_id" bigint, "name" varchar(255), "edatatype_instancetype_e_id" bigint, "rawvalue" varchar(255), "intvalue" integer, "booleanvalue" smallint, "doublevalue" double, "stringvalue" varchar(255), "eobjectvalue_type" varchar(255), "eobjectvalue_id" bigint, "diagram_diagramlink_e_id" bigint, "hint" varchar(255), "textalignment" varchar(255), "linetype" varchar(255), "arrowsource" varchar(255), "arrowtarget" varchar(255), "view_styles_e_id" bigint, "view_styles_idx" integer, econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
> ERROR DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;USER, DRIVER=3.57.86
> ERROR Unsuccessful: create table APP.details ("eannotation_details_e_id" bigint, elt varchar(255), idx varchar(255) not null, primary key ("eannotation_details_e_id", idx))
> ERROR DB2 SQL Error: SQLCODE=-542, SQLSTATE=42831, SQLERRMC=eannotation_details_e_id, DRIVER=3.57.86
> ERROR Unsuccessful: create table APP.nodeMap ("guide_nodemap_e_id" bigint, elt varchar(255), idx bigint not null, primary key ("guide_nodemap_e_id", idx))
> ERROR DB2 SQL Error: SQLCODE=-542, SQLSTATE=42831, SQLERRMC=guide_nodemap_e_id, DRIVER=3.57.86
> ERROR Unsuccessful: alter table APP."anytype" add constraint simpleanytype_instancetype foreign key ("edatatype_instancetype_e_id") references APP."ecore_eobject"
> ERROR DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=APP.ecore_eobject, DRIVER=3.57.86
> ERROR Unsuccessful: alter table APP."area" add constraint mwlinearea_standard foreign key ("standard_standard_e_id") references APP."standard"
> ERROR DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=APP.standard, DRIVER=3.57.86
> ....
>
> and so on ...
>
> My preferences:
>
> props.setProperty(Environment.DIALECT, "org.hibernate.dialect.DB2Dialect");
> props.setProperty(Environment.DRIVER, "com.ibm.db2.jcc.DB2Driver");
> props.setProperty(Environment.AUTOCOMMIT, "false");
> props.setProperty(Environment.HBM2DDL_AUTO, "update");
>
> What is the problem?
>


--

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@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
Re: Teneo with IBM DB2 [message #621380 is a reply to message #486126] Wed, 16 September 2009 13:48 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Thomet,
I am sorry but I have no idea what all these db2 error codes mean...

btw, support for teneo is now given on the main EMF newsgroup which I added to the cc.

gr. Martin

Thomet wrote:
> Hello,
> I would like to talk about teneo my data on a db2 database to save. First I tried this with H2DB un MySQL, which worked well.
> In the experiment using DB2, I always get this error:
>
> ERROR Unsuccessful: create table APP."ecore_eobject" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "visible" smallint, "type" varchar(255), "element_type" varchar(255), "element_id" bigint, "edge_source_e_id" bigint, "edge_target_e_id" bigint, "bendpoints_bendpoints_e_id" bigint, "anchor_sourceanchor_e_id" bigint, "anchor_targetanchor_e_id" bigint, "layoutconstraint_layoutconstraint_e_id" bigint, "name" varchar(255), "measurementunit" varchar(255), "fontcolor" integer, "fontname" varchar(255), "fontheight" integer, "bold" smallint, "italic" smallint, "underline" smallint, "strikethrough" smallint, "description" varchar(255), "fillcolor" integer, "transparency" integer, "gradient" varchar(255), "linecolor" integer, "linewidth" integer, "collapsed" smallint, "canonical" smallint, "showtitle" smallint, "sorting" varchar(255), "sortingkeys" varchar(255), "filtering" varchar(255), "filteringkeys" varchar(255), "routing"
varchar(255), "smoothness" varchar(255), "avoidobstructions" smallint, "closestdistance" smallint, "jumplinkstatus" varchar(255), "jumplinktype" varchar(255), "jumplinksreverse" smallint, "roundedbendpointsradius" integer, "pagex" integer, "pagey" integer, "pagewidth" integer, "pageheight" integer, "ordered" smallint, "unique" smallint, "lowerbound" integer, "upperbound" integer, "eclassifier_etype_e_id" bigint, "egenerictype_egenerictype_e_id" bigint, "changeable" smallint, "volatile" smallint, "transient" smallint, "defaultvalueliteral" varchar(255), "unsettable" smallint, "derived" smallint, "estructuralfeature_econtainingclass_e_id" bigint, "id" smallint, "source" varchar(255), "eannotation_emodelelement_e_id" bigint, "instanceclassname" varchar(255), "instancetypename" varchar(255), "eclassifier_epackage_e_id" bigint, "abstract" smallint, "interface" smallint, "serializable" smallint, "value" integer, "literal" varchar(255), "eenumliteral_eenum_e_id" bigint, "eoperation
_econtainingclass_e_id" bigint, "nsuri" varchar(255), "nsprefix" varchar(255), "epackage_esuperpackage_e_id" bigint, "eparameter_eoperation_e_id" bigint, "containment" smallint, "resolveproxies" smallint, "ereference_eopposite_e_id" bigint, "egenerictype_eupperbound_e_id" bigint, "egenerictype_elowerbound_e_id" bigint, "etypeparameter_etypeparameter_e_id" bigint, "eclassifier_eclassifier_e_id" bigint, "emodelelement_eannotations_idx" integer, "view_children_e_id" bigint, "view_children_idx" integer, "diagram_edges_e_id" bigint, "diagram_edges_idx" integer, "eclassifier_etypeparameters_e_id" bigint, "eclassifier_etypeparameters_idx" integer, "eclass_eoperations_idx" integer, "eclass_estructuralfeatures_idx" integer, "eclass_egenericsupertypes_e_id" bigint, "eclass_egenericsupertypes_idx" integer, "eenum_eliterals_idx" integer, "eoperation_etypeparameters_e_id" bigint, "eoperation_etypeparameters_idx" integer, "eoperation_eparameters_idx" integer, "eoperation_egenericexceptions
_e_id" bigint, "eoperation_egenericexceptions_idx" integer, "epackage_eclassifiers_idx" integer, "epackage_esubpackages_idx" integer, "egenerictype_etypearguments_e_id" bigint, "egenerictype_etypearguments_idx" integer, "etypeparameter_ebounds_e_id" bigint, "etypeparameter_ebounds_idx" integer, econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
> ERROR DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;USER, DRIVER=3.57.86
> ERROR Unsuccessful: create table APP."featurechange" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "featurename" varchar(255), "datavalue" varchar(2147483647), "set" smallint, feature varchar(255) not null, "referencevalue_type" varchar(255), "referencevalue_id" bigint, "changedescription_objectchanges_e_id" bigint, idx bigint, primary key (e_id))
> ERROR DB2 SQL Error: SQLCODE=-604, SQLSTATE=42611, SQLERRMC=varchar(2147483647), DRIVER=3.57.86
> ERROR Unsuccessful: create table APP."imageproxy" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "image" blob(2147483647), econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
> ERROR DB2 SQL Error: SQLCODE=-355, SQLSTATE=42993, SQLERRMC=image, DRIVER=3.57.86
> ERROR Unsuccessful: create table APP."standard" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "name" varchar(255) not null, "datum" timestamp, "bearbeiter" varchar(255), "anbieter" varchar(255), "nummer" integer, "beschreibung" varchar(255), "typ_standardtyp_e_id" bigint, "freigabe_standardfreigabe_e_id" bigint, "einheit_standardeinheitspalte1_e_id" bigint, "einheit_standardeinheitspalte2_e_id" bigint, "image" blob(2147483647), "roi1darea_standard_e_id" bigint, "roi1darea_standard_idx" integer, "standardcontainer_standards_e_id" bigint, "standardcontainer_standards_idx" integer, econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
> ERROR DB2 SQL Error: SQLCODE=-355, SQLSTATE=42993, SQLERRMC=image, DRIVER=3.57.86
> ERROR Unsuccessful: create table APP."style" (e_id bigint generated by default as identity, "dtype" varchar(255) not null, e_version integer not null, "fillcolor" integer, "transparency" integer, "gradient" varchar(255), "linecolor" integer, "linewidth" integer, "fontcolor" integer, "fontname" varchar(255), "fontheight" integer, "bold" smallint, "italic" smallint, "underline" smallint, "strikethrough" smallint, "showtitle" smallint, "sorting" varchar(255), "sortingkeys" varchar(255), "description" varchar(255), "routing" varchar(255), "smoothness" varchar(255), "avoidobstructions" smallint, "closestdistance" smallint, "jumplinkstatus" varchar(255), "jumplinktype" varchar(255), "jumplinksreverse" smallint, "roundedbendpointsradius" integer, "canonical" smallint, "pagex" integer, "pagey" integer, "pagewidth" integer, "pageheight" integer, "collapsed" smallint, "filtering" varchar(255), "filteringkeys" varchar(255), "antialias" smallint, "maintainaspectratio" smallint, "bounds
_cropbound_e_id" bigint, "image_imagebuffer_e_id" bigint, "name" varchar(255), "edatatype_instancetype_e_id" bigint, "rawvalue" varchar(255), "intvalue" integer, "booleanvalue" smallint, "doublevalue" double, "stringvalue" varchar(255), "eobjectvalue_type" varchar(255), "eobjectvalue_id" bigint, "diagram_diagramlink_e_id" bigint, "hint" varchar(255), "textalignment" varchar(255), "linetype" varchar(255), "arrowsource" varchar(255), "arrowtarget" varchar(255), "view_styles_e_id" bigint, "view_styles_idx" integer, econtainer_class varchar(255), e_container varchar(255), e_container_feature_name varchar(255), primary key (e_id))
> ERROR DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;USER, DRIVER=3.57.86
> ERROR Unsuccessful: create table APP.details ("eannotation_details_e_id" bigint, elt varchar(255), idx varchar(255) not null, primary key ("eannotation_details_e_id", idx))
> ERROR DB2 SQL Error: SQLCODE=-542, SQLSTATE=42831, SQLERRMC=eannotation_details_e_id, DRIVER=3.57.86
> ERROR Unsuccessful: create table APP.nodeMap ("guide_nodemap_e_id" bigint, elt varchar(255), idx bigint not null, primary key ("guide_nodemap_e_id", idx))
> ERROR DB2 SQL Error: SQLCODE=-542, SQLSTATE=42831, SQLERRMC=guide_nodemap_e_id, DRIVER=3.57.86
> ERROR Unsuccessful: alter table APP."anytype" add constraint simpleanytype_instancetype foreign key ("edatatype_instancetype_e_id") references APP."ecore_eobject"
> ERROR DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=APP.ecore_eobject, DRIVER=3.57.86
> ERROR Unsuccessful: alter table APP."area" add constraint mwlinearea_standard foreign key ("standard_standard_e_id") references APP."standard"
> ERROR DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=APP.standard, DRIVER=3.57.86
> ....
>
> and so on ...
>
> My preferences:
>
> props.setProperty(Environment.DIALECT, "org.hibernate.dialect.DB2Dialect");
> props.setProperty(Environment.DRIVER, "com.ibm.db2.jcc.DB2Driver");
> props.setProperty(Environment.AUTOCOMMIT, "false");
> props.setProperty(Environment.HBM2DDL_AUTO, "update");
>
> What is the problem?
>


--

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@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
Previous Topic:Teneo with IBM DB2
Next Topic:getting started with compare
Goto Forum:
  


Current Time: Mon Feb 26 12:30:48 GMT 2024

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

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

Back to the top