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.
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?
|
|
|
Goto Forum:
Current Time: Thu Apr 25 22:49:03 GMT 2024
Powered by FUDForum. Page generated in 0.03041 seconds |
] 
Search
Help
Register
Login
Home
