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 #621379] Wed, 16 September 2009 12:26
Thomas M. is currently offline Thomas M.Friend
Messages: 7
Registered: November 2009
Junior Member
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?
Previous Topic:[EMF Compare] Change of the Metamodel
Next Topic:Teneo with IBM DB2
Goto Forum:
  


Current Time: Mon Feb 26 02:00:48 GMT 2024

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

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

Back to the top