I have defined a column in Oracle as EFFECTIVE_DATE NUMBER(8) NOT NUL

I have defined a column in Oracle as
EFFECTIVE_DATE NUMBER(8) NOT NULL,

in the XSD
<xsd:element name="EFFECTIVE_DATE" type="xsd:long" nillable="true" >
                    <xsd:annotation>
                              <xsd:appinfo source="appian.jpa">                                                  
@Column(name="EFFECTIVE_DATE")
</xsd:appinfo>
</xsd:annotation>
           </xsd:element>

But it wont map using the query database node. Please do guide me on what I am doing wrong....

OriginalPostID-117372

OriginalPostID-117372