Bug#471979: Generates empty tables when exports to SQL (PostgreSQL and MySQL)
Package: umbrello
Version: 4:4.0.2-1
Severity: serious
--- Please enter the report below this line. ---
Export to SQL (MySQL and PostgreSQL) generates empty tables (with no
attributes/columns).
Example:
CREATE TABLE foo (
);
Attached .xmi, .java and .sql
--- System information. ---
Architecture: i386
Kernel: Linux 2.6.24-1-686
Debian Release: lenny/sid
500 unstable www.debian-multimedia.org
500 unstable http.us.debian.org
500 unstable ftp.pl.debian.org
500 unstable deb.opera.com
500 experimental www.debian-multimedia.org
1 experimental http.us.debian.org
--- Package information. ---
Depends (Version) | Installed
====================================-+-===============
kdebase-runtime | 4:4.0.2-1
kdelibs5 (>= 4:4.0.2-1) | 4:4.0.2-1
libc6 (>= 2.7-1) | 2.7-9
libqt4-core (>= 4.3.4) | 4.3.4-2
libqt4-gui (>= 4.3.4) | 4.3.4-2
libqt4-qt3support (>= 4.3.4) | 4.3.4-2
libstdc++6 (>= 4.1.1-21) | 4.3.0-1
libxml2 (>= 2.6.27) | 2.6.31.dfsg-2
libxslt1.1 (>= 1.1.18) | 1.1.22-1
<?xml version="1.0" encoding="UTF-8"?>
<XMI verified="false" xmi.version="1.2" timestamp="2008-03-21T15:58:57" xmlns:UML="http://schema.omg.org/spec/UML/1.3"; >
<XMI.header>
<XMI.documentation>
<XMI.exporter>umbrello uml modeller http://uml.sf.net</XMI.exporter>
<XMI.exporterVersion>1.5.8</XMI.exporterVersion>
<XMI.exporterEncoding>UnicodeUTF8</XMI.exporterEncoding>
</XMI.documentation>
<XMI.metamodel xmi.version="1.3" href="UML.xml" xmi.name="UML" />
</XMI.header>
<XMI.content>
<UML:Model isSpecification="false" isAbstract="false" isLeaf="false" xmi.id="m1" isRoot="false" name="Model UML" >
<UML:Namespace.ownedElement>
<UML:Stereotype visibility="public" isSpecification="false" namespace="m1" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="folder" name="folder" />
<UML:Stereotype visibility="public" isSpecification="false" namespace="m1" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="datatype" name="datatype" />
<UML:Model stereotype="folder" visibility="public" isSpecification="false" namespace="m1" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Logical View" name="Logical View" >
<UML:Namespace.ownedElement>
<UML:Package stereotype="folder" visibility="public" isSpecification="false" namespace="Logical View" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Datatypes" name="Datatypes" >
<UML:Namespace.ownedElement>
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="NdB7wFJtV3OT" name="int" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="kG92AxWI3fCT" name="char" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="5if08GpUtzZo" name="bool" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Esfht38dJHeR" name="float" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="FAjGovjtcPsi" name="double" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="ffAXekLqcyYW" name="short" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="zg7Hwli9uSPg" name="long" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="L8XvXNeB3oif" name="unsigned int" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="W1W9z4dyikDe" name="unsigned short" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="UwlOMA4hJbbo" name="unsigned long" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="xFx01ffYe9fb" name="string" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="UKWPXTPW724l" name="bigint" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="NzvF0gmSM2JN" name="bigserial" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="SB6AfOe4t5RQ" name="bit" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="CSSweCHz9AF9" name="bit varying" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="qzaAztYP4cXi" name="boolean" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="zBkqFCGPejLG" name="box" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="taD0kS8ZPijO" name="bytea" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="bFmfsJNpT6fi" name="character varying" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Gw5sdP8UzLUk" name="character" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="mcJ9K0WtGIZ6" name="cidr" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Zuv20aiGUo85" name="circle" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="DEXAY0uKcBTv" name="date" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="CzoSFLWpGRpE" name="decimal" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="zYVUKbXVq5fO" name="double precision" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="5Ygfj7Yt5NJK" name="inet" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="gp7uGx9GTcin" name="integer" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="DFG1IvNLR119" name="interval" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="7Z2CuMUb9aVQ" name="line" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Xce0EKlQX1Pq" name="lseg" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="ulBMmATriV3c" name="macaddr" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Bz6fNbH1ZULK" name="money" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="sJHgD0qXl00c" name="numeric" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="iUeJJAUIE7dp" name="path" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="NeOrxgjozySA" name="point" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="zIgiHeKx8yGQ" name="polygon" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="6jgIoK5BwR2u" name="real" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="7jg4g8DfPtLg" name="serial" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Vfdccs2gZgzN" name="smallint" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="y4ZvWZnbJTgz" name="time without timezone" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="ZtcykxcFaErC" name="time with timezone" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="6rtdWq0UuXPO" name="timestamp without timezone" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="n7hQfG3Mc9ur" name="byte" />
<UML:DataType stereotype="datatype" visibility="public" isSpecification="false" namespace="Datatypes" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="RNcQ57V9ubXg" name="String" />
</UML:Namespace.ownedElement>
</UML:Package>
<UML:Class visibility="public" isSpecification="false" namespace="Logical View" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="umSUyIf49Wfd" name="foo" >
<UML:Classifier.feature>
<UML:Attribute visibility="public" isSpecification="false" xmi.id="ZgJD3Wi0evsO" type="7jg4g8DfPtLg" name="bar" />
</UML:Classifier.feature>
</UML:Class>
</UML:Namespace.ownedElement>
<XMI.extension xmi.extender="umbrello" >
<diagrams>
<diagram showopsig="1" linecolor="#ff0000" snapx="10" showattribassocs="1" snapy="10" linewidth="0" showattsig="1" showpackage="1" showstereotype="1" name="diagram klasy" font="Sans Serif,10,-1,0,50,0,0,0,0,0" canvasheight="697" canvaswidth="1165" localid="" snapcsgrid="0" showgrid="0" showops="1" usefillcolor="1" fillcolor="#ffff00" zoom="100" xmi.id="5DwGkXxjtiIu" documentation="" showscope="1" snapgrid="0" showatts="1" type="1" >
<widgets>
<classwidget linecolor="#ff0000" usesdiagramfillcolor="0" linewidth="none" showoperations="1" usesdiagramusefillcolor="0" showpubliconly="0" showpackage="1" x="507" showattsigs="601" showstereotype="1" y="89" showattributes="1" font="Sans Serif,10,-1,5,75,0,0,0,0,0" width="88" isinstance="0" usefillcolor="1" fillcolor="#ffff00" xmi.id="umSUyIf49Wfd" showscope="1" height="45" showopsigs="601" />
</widgets>
<messages/>
<associations/>
</diagram>
</diagrams>
</XMI.extension>
</UML:Model>
<UML:Model stereotype="folder" visibility="public" isSpecification="false" namespace="m1" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Use Case View" name="Use Case View" >
<UML:Namespace.ownedElement/>
</UML:Model>
<UML:Model stereotype="folder" visibility="public" isSpecification="false" namespace="m1" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Component View" name="Component View" >
<UML:Namespace.ownedElement/>
</UML:Model>
<UML:Model stereotype="folder" visibility="public" isSpecification="false" namespace="m1" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Deployment View" name="Deployment View" >
<UML:Namespace.ownedElement/>
</UML:Model>
<UML:Model stereotype="folder" visibility="public" isSpecification="false" namespace="m1" isAbstract="false" isLeaf="false" isRoot="false" xmi.id="Entity Relationship Model" name="Entity Relationship Model" >
<UML:Namespace.ownedElement/>
</UML:Model>
</UML:Namespace.ownedElement>
</UML:Model>
</XMI.content>
<XMI.extensions xmi.extender="umbrello" >
<docsettings viewid="5DwGkXxjtiIu" uniqueid="RNcQ57V9ubXg" documentation="" />
<listview>
<listitem open="1" type="800" label="Perspektywy" >
<listitem open="1" type="801" id="Logical View" >
<listitem open="0" type="807" id="5DwGkXxjtiIu" label="diagram klasy" />
<listitem open="1" type="813" id="umSUyIf49Wfd" >
<listitem open="0" type="814" id="ZgJD3Wi0evsO" />
</listitem>
<listitem open="0" type="830" id="Datatypes" >
<listitem open="1" type="829" id="RNcQ57V9ubXg" />
<listitem open="1" type="829" id="UKWPXTPW724l" />
<listitem open="1" type="829" id="NzvF0gmSM2JN" />
<listitem open="1" type="829" id="SB6AfOe4t5RQ" />
<listitem open="1" type="829" id="CSSweCHz9AF9" />
<listitem open="1" type="829" id="5if08GpUtzZo" />
<listitem open="1" type="829" id="qzaAztYP4cXi" />
<listitem open="1" type="829" id="zBkqFCGPejLG" />
<listitem open="1" type="829" id="n7hQfG3Mc9ur" />
<listitem open="1" type="829" id="taD0kS8ZPijO" />
<listitem open="1" type="829" id="kG92AxWI3fCT" />
<listitem open="1" type="829" id="Gw5sdP8UzLUk" />
<listitem open="1" type="829" id="bFmfsJNpT6fi" />
<listitem open="1" type="829" id="mcJ9K0WtGIZ6" />
<listitem open="1" type="829" id="Zuv20aiGUo85" />
<listitem open="1" type="829" id="DEXAY0uKcBTv" />
<listitem open="1" type="829" id="CzoSFLWpGRpE" />
<listitem open="1" type="829" id="FAjGovjtcPsi" />
<listitem open="1" type="829" id="zYVUKbXVq5fO" />
<listitem open="1" type="829" id="Esfht38dJHeR" />
<listitem open="1" type="829" id="5Ygfj7Yt5NJK" />
<listitem open="1" type="829" id="NdB7wFJtV3OT" />
<listitem open="1" type="829" id="gp7uGx9GTcin" />
<listitem open="1" type="829" id="DFG1IvNLR119" />
<listitem open="1" type="829" id="7Z2CuMUb9aVQ" />
<listitem open="1" type="829" id="zg7Hwli9uSPg" />
<listitem open="1" type="829" id="Xce0EKlQX1Pq" />
<listitem open="1" type="829" id="ulBMmATriV3c" />
<listitem open="1" type="829" id="Bz6fNbH1ZULK" />
<listitem open="1" type="829" id="sJHgD0qXl00c" />
<listitem open="1" type="829" id="iUeJJAUIE7dp" />
<listitem open="1" type="829" id="NeOrxgjozySA" />
<listitem open="1" type="829" id="zIgiHeKx8yGQ" />
<listitem open="1" type="829" id="6jgIoK5BwR2u" />
<listitem open="1" type="829" id="7jg4g8DfPtLg" />
<listitem open="1" type="829" id="ffAXekLqcyYW" />
<listitem open="1" type="829" id="Vfdccs2gZgzN" />
<listitem open="1" type="829" id="xFx01ffYe9fb" />
<listitem open="1" type="829" id="ZtcykxcFaErC" />
<listitem open="1" type="829" id="y4ZvWZnbJTgz" />
<listitem open="1" type="829" id="6rtdWq0UuXPO" />
<listitem open="1" type="829" id="L8XvXNeB3oif" />
<listitem open="1" type="829" id="UwlOMA4hJbbo" />
<listitem open="1" type="829" id="W1W9z4dyikDe" />
</listitem>
</listitem>
<listitem open="1" type="802" id="Use Case View" />
<listitem open="1" type="821" id="Component View" />
<listitem open="1" type="827" id="Deployment View" />
<listitem open="1" type="836" id="Entity Relationship Model" />
</listitem>
</listview>
<codegeneration>
<codegenerator language="Java" />
</codegeneration>
</XMI.extensions>
</XMI>
--
-- TABLE: foo
--
--
CREATE TABLE foo (
);
/**
* Class foo
*/
public class foo {
//
// Fields
//
public serial bar;
//
// Constructors
//
public foo () { };
//
// Methods
//
//
// Accessor methods
//
/**
* Set the value of bar
* @param newVar the new value of bar
*/
public void setBar ( serial newVar ) {
bar = newVar;
}
/**
* Get the value of bar
* @return the value of bar
*/
public serial getBar ( ) {
return bar;
}
//
// Other methods
//
}
Reply to: