Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » Teneo with IBM DB2
| Teneo with IBM DB2 [message #621379] |
Wed, 16 September 2009 08:26 |
Eclipse User |
|
|
|
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?
|
|
|
Goto Forum:
Current Time: Sun Jul 13 21:39:04 EDT 2025
Powered by FUDForum. Page generated in 0.03480 seconds |
Home