Home » Modeling » EMF » Re: Teneo with IBM DB2
Re: Teneo with IBM DB2 [message #486143] |
Wed, 16 September 2009 13:48 |
Martin Taal 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
|
|
|
Goto Forum:
Current Time: Fri Apr 19 20:05:26 GMT 2024
Powered by FUDForum. Page generated in 0.03286 seconds
|