Re: [wtp-dev] Help needed with XMI DB definition files interpretation

[Sheila Sholars <sholars@xxxxxxxxxx>]

Dimiter, Here's a response from Hemant who's in the process of subscribing to wtp-dev:

----------------
Hi Dimiter,

some clarifications about attributes of org.eclipse.wst.rdb.internal.models.dbdefinition.PredefinedDataTypeDefinition.

xmi:id="DECIMAL_1" - this is an identifier to uniquely identify a predefinedDataTypeDefinition within the XMI DB definition file.

scaleSupported="true" - if the predefined datatype supports scale, then this has to be true. e.g. DECIMAL(5,2)

precisionSupported="true" - if the predefined datatype supports precision, then this has to be true. e.g. DECIMAL(5,2)

defaultPrecision="5" - the default precision is the value assigned by the system if no precision is specified by the user while defining the datatype instance.

defaultScale="0" - the default precision is the value assigned by the system if no scale is specified by the user while defining the datatype instance.

keyConstraintSupported="true" - if the a column of this predefined datatype can be a primary/unique key column of the table.

primitiveType="DECIMAL" - the underlying SQL 99 primitive type the predefined datatype maps to. please refer the WTP/DTP SQLModel for available

SQL 99 primitive types.

<defaultValueTypes>NULL</defaultValueTypes> - the default values applicable to the predefined datatype, as defined by the database vendor.

<name>DECIMAL</name> - the first value in this list is the name of the predefined datatype. the rest of the values in the list are synonyms for the datatype.
<name>DEC</name>

hope that helps,

- Hemant

Regards,
Sheila
"Dimitrov, Dimiter" <d.dimitrov@xxxxxxx>

"Dimitrov, Dimiter" <d.dimitrov@xxxxxxx>
Sent by: wtp-dev-bounces@xxxxxxxxxxx

11/15/2006 08:34 AM

Please respond to
"General discussion of project-wide or architectural issues." <wtp-dev@xxxxxxxxxxx>

To	<wtp-dev@xxxxxxxxxxx>
cc
Subject	[wtp-dev] Help needed with XMI DB definition files interpretation

Hello,

I want to introduce data base definition for MAXDB. Because I haven’t found description about the semantic of <predefinedDataTypeDefinitions > I asked respectively in the mail groups of DALI and DTP, but the information I received is not enough. I got hold of the following model representation:

http://www.eclipse.org/datatools/project_modelbase/modelbase_doc/DatabaseDefinitionModelWebPub/root.html

as well as a more detailed explanation about the process of generation of exemplary XMI:

http://www.eclipse.org/datatools/project_modelbase/modelbase_doc/DTP%20Modelbase%20White%20paper.htm

Unfortunately in the both cases I couldn’t find description about the attributes of the mentioned <predefinedDataTypeDefinitions >. I searched in the JavaDoc of

org.eclipse.wst.rdb.internal.models.dbdefinition.PredefinedDataTypeDefinition ,
but it is not filled in L
So my question is whether anybody could explain me what is the meaning of the underlined attributes, or to redirect me to the some information source about their interpretation (I suppose about the meaning of some of them, but this approach is not serious).

The example is following:

<predefinedDataTypeDefinitions xmi:id="DECIMAL_1" scaleSupported="true" precisionSupported="true" defaultPrecision="5" defaultScale="0" maximumPrecision="31" keyConstraintSupported="true" primitiveType="DECIMAL" jdbcEnumType="3" javaClassName="java.math.BigDecimal">>

<defaultValueTypes>NULL</defaultValueTypes>
<name>DECIMAL</name>
<name>DEC</name>
</predefinedDataTypeDefinitions>

Any help will be appreciated highly.

Greeting,
Dimiter _______________________________________________
wtp-dev mailing list
wtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/wtp-dev