svn commit: r959708 [1/2] - in /ofbiz/trunk/framework/entity: dtd/ fieldtype/
Locked
 
|
Author: adrianc
Date: Thu Jul 1 16:11:10 2010 New Revision: 959708 URL: http://svn.apache.org/viewvc?rev=959708&view=rev Log: Removed validate element from fieldtype*.xml files. Modified: ofbiz/trunk/framework/entity/dtd/fieldtypemodel.xsd ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypepostnew.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml Modified: ofbiz/trunk/framework/entity/dtd/fieldtypemodel.xsd URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/dtd/fieldtypemodel.xsd?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/dtd/fieldtypemodel.xsd (original) +++ ofbiz/trunk/framework/entity/dtd/fieldtypemodel.xsd Thu Jul 1 16:11:10 2010 @@ -30,13 +30,9 @@ under the License. <!-- ================= Children of fieldtypemodel =================== --> <xs:element name="field-type-def"> <xs:complexType> - <xs:sequence> - <xs:element minOccurs="0" maxOccurs="unbounded" ref="validate"/> - </xs:sequence> <xs:attributeGroup ref="attlist.field-type-def"/> </xs:complexType> </xs:element> - <!-- ================= Children of field-type-def =================== --> <xs:attributeGroup name="attlist.field-type-def"> <xs:attribute type="xs:string" name="type" use="required"/> <xs:attribute type="xs:string" name="sql-type" use="required"/> @@ -131,13 +127,4 @@ under the License. </xs:simpleType> </xs:attribute> </xs:attributeGroup> - <xs:element name="validate"> - <xs:complexType> - <xs:attributeGroup ref="attlist.validate"/> - </xs:complexType> - </xs:element> - <xs:attributeGroup name="attlist.validate"> - <xs:attribute type="xs:string" name="method" use="required"/> - <xs:attribute type="xs:string" name="class" default="org.ofbiz.base.util.UtilValidate"/> - </xs:attributeGroup> </xs:schema> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml Thu Jul 1 16:11:10 2010 @@ -25,43 +25,43 @@ under the License. <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="Blob" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="Blob" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="Blob" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="TimeStamp" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="Date" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="Time" java-type="java.sql.Time"></field-type-def> - - <!-- Advantage numeric fields are 2 bytes longer than the value to be stored - to hold the sign and decimal point. --> - <field-type-def type="currency-amount" sql-type="Numeric(20,2)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="Numeric(20,3)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="Numeric(20,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="Double" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="Numeric(20,0)" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="Char(20)" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="Char(60)" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="Char(255)" java-type="String"></field-type-def> - - <field-type-def type="indicator" sql-type="Char(1)" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="Char(10)" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="Char(60)" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="Char(255)" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="Memo" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="Char(255)" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="Char(255)" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="Char(100)" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="Char(255)" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="Blob" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="Blob" java-type="byte[]"/> + <field-type-def type="object" sql-type="Blob" java-type="Object"/> + + <field-type-def type="date-time" sql-type="TimeStamp" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="Date" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="Time" java-type="java.sql.Time"/> + + <!-- Advantage numeric fields are 2 bytes longer than the intended precision - to hold the sign and decimal point. --> + <field-type-def type="currency-amount" sql-type="Numeric(20,2)" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="Numeric(20,3)" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="Numeric(20,6)" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="Double" java-type="Double"/> + <field-type-def type="numeric" sql-type="Numeric(20,0)" java-type="Long"/> + + <field-type-def type="id" sql-type="Char(20)" java-type="String"/> + <field-type-def type="id-long" sql-type="Char(60)" java-type="String"/> + <field-type-def type="id-vlong" sql-type="Char(255)" java-type="String"/> + + <field-type-def type="indicator" sql-type="Char(1)" java-type="String"/> + <field-type-def type="very-short" sql-type="Char(10)" java-type="String"/> + <field-type-def type="short-varchar" sql-type="Char(60)" java-type="String"/> + <field-type-def type="long-varchar" sql-type="Char(255)" java-type="String"/> + <field-type-def type="very-long" sql-type="Memo" java-type="String"/> + + <field-type-def type="comment" sql-type="Char(255)" java-type="String"/> + <field-type-def type="description" sql-type="Char(255)" java-type="String"/> + <field-type-def type="name" sql-type="Char(100)" java-type="String"/> + <field-type-def type="value" sql-type="Char(255)" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="Char(255)" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="Char(20)" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="Char(255)" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="Char(255)" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="Char(20)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="Char(60)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="Char(255)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="Char(60)" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="Char(255)" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="Char(20)" java-type="String"/> + <field-type-def type="email" sql-type="Char(255)" java-type="String"/> + <field-type-def type="url" sql-type="Char(255)" java-type="String"/> + <field-type-def type="id-ne" sql-type="Char(20)" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="Char(60)" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="Char(255)" java-type="String"/> + <field-type-def type="tel-number" sql-type="Char(60)" java-type="String"/> </fieldtypemodel> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml Thu Jul 1 16:11:10 2010 @@ -22,44 +22,44 @@ under the License. xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd"> <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="BLOB" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="BLOB" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="BLOB" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def> - - <field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="NUMBER(18,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="FLOAT" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - - <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="CLOB" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="BLOB" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="BLOB" java-type="byte[]"/> + <field-type-def type="object" sql-type="BLOB" java-type="Object"/> + + <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"/> + + <field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="NUMBER(18,6)" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="FLOAT" java-type="Double"/> + <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"/> + + <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong" sql-type="VARCHAR(255)" java-type="String"/> + + <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"/> + <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"/> + <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="very-long" sql-type="CLOB" java-type="String"/> + + <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"/> + <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"/> </fieldtypemodel> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml Thu Jul 1 16:11:10 2010 @@ -22,42 +22,42 @@ under the License. xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd"> <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="BLOB" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="BLOB" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="BLOB" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def> - - <field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="NUMBER(18,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="NUMBER(18,6)" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="VARCHAR2(20)" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="VARCHAR2(60)" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> - - <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="VARCHAR2(10)" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="VARCHAR2(60)" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="CLOB" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="VARCHAR2(100)" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="BLOB" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="BLOB" java-type="byte[]"/> + <field-type-def type="object" sql-type="BLOB" java-type="Object"/> + + <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"/> + + <field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="NUMBER(18,6)" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="NUMBER(18,6)" java-type="Double"/> + <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"/> + + <field-type-def type="id" sql-type="VARCHAR2(20)" java-type="String"/> + <field-type-def type="id-long" sql-type="VARCHAR2(60)" java-type="String"/> + <field-type-def type="id-vlong" sql-type="VARCHAR2(255)" java-type="String"/> + + <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"/> + <field-type-def type="very-short" sql-type="VARCHAR2(10)" java-type="String"/> + <field-type-def type="short-varchar" sql-type="VARCHAR2(60)" java-type="String"/> + <field-type-def type="long-varchar" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="very-long" sql-type="CLOB" java-type="String"/> + + <field-type-def type="comment" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="description" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="name" sql-type="VARCHAR2(100)" java-type="String"/> + <field-type-def type="value" sql-type="VARCHAR2(255)" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="VARCHAR2(255)" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="VARCHAR2(20)" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="VARCHAR2(255)" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="VARCHAR2(20)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="VARCHAR2(60)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="VARCHAR2(255)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="VARCHAR2(60)" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="VARCHAR2(20)" java-type="String"/> + <field-type-def type="email" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="url" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="id-ne" sql-type="VARCHAR2(20)" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="VARCHAR2(60)" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="tel-number" sql-type="VARCHAR2(60)" java-type="String"/> </fieldtypemodel> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml Thu Jul 1 16:11:10 2010 @@ -22,42 +22,42 @@ under the License. xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd"> <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="BLOB" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="BLOB" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="BLOB" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def> - - <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="NUMERIC(18,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="DOUBLE" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - - <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="CLOB" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="BLOB" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="BLOB" java-type="byte[]"/> + <field-type-def type="object" sql-type="BLOB" java-type="Object"/> + + <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"/> + + <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="NUMERIC(18,6)" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="DOUBLE" java-type="Double"/> + <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"/> + + <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong" sql-type="VARCHAR(255)" java-type="String"/> + + <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"/> + <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"/> + <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="very-long" sql-type="CLOB" java-type="String"/> + + <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"/> + <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"/> </fieldtypemodel> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml Thu Jul 1 16:11:10 2010 @@ -22,44 +22,44 @@ under the License. xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd"> <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="BLOB" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="BLOB" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="BLOB SUB_TYPE 2" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def> - - <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="NUMERIC(18,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="FLOAT" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - - <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="BLOB SUB_TYPE 1" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="BLOB" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="BLOB" java-type="byte[]"/> + <field-type-def type="object" sql-type="BLOB SUB_TYPE 2" java-type="Object"/> + + <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"/> + + <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="NUMERIC(18,6)" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="FLOAT" java-type="Double"/> + <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"/> + + <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong" sql-type="VARCHAR(255)" java-type="String"/> + + <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"/> + <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"/> + <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="very-long" sql-type="BLOB SUB_TYPE 1" java-type="String"/> + + <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"/> + <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"/> </fieldtypemodel> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml Thu Jul 1 16:11:10 2010 @@ -22,42 +22,42 @@ under the License. xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd"> <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="OBJECT" sql-type-alias="OTHER" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="OBJECT" sql-type-alias="OTHER" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="OBJECT" sql-type-alias="OTHER" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def> - - <field-type-def type="currency-amount" sql-type="DOUBLE" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="DOUBLE" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="DOUBLE" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="DOUBLE" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="BIGINT" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="VARCHAR" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="VARCHAR" java-type="String"></field-type-def> - - <field-type-def type="indicator" sql-type="CHAR" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="VARCHAR" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="VARCHAR" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="VARCHAR" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="VARCHAR" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="VARCHAR" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="VARCHAR" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="VARCHAR" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="VARCHAR" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="OBJECT" sql-type-alias="OTHER" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="OBJECT" sql-type-alias="OTHER" java-type="byte[]"/> + <field-type-def type="object" sql-type="OBJECT" sql-type-alias="OTHER" java-type="Object"/> + + <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"/> + + <field-type-def type="currency-amount" sql-type="DOUBLE" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="DOUBLE" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="DOUBLE" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="DOUBLE" java-type="Double"/> + <field-type-def type="numeric" sql-type="BIGINT" java-type="Long"/> + + <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="id-vlong" sql-type="VARCHAR" java-type="String"/> + + <field-type-def type="indicator" sql-type="CHAR" java-type="String"/> + <field-type-def type="very-short" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="short-varchar" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="long-varchar" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="very-long" sql-type="VARCHAR" java-type="String"/> + + <field-type-def type="comment" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="description" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="name" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="value" sql-type="VARCHAR" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="VARCHAR" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="VARCHAR" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="VARCHAR" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="VARCHAR" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="VARCHAR" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="VARCHAR" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="VARCHAR" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="VARCHAR" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="email" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="url" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="id-ne" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="VARCHAR" java-type="String"/> + <field-type-def type="tel-number" sql-type="VARCHAR" java-type="String"/> </fieldtypemodel> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml Thu Jul 1 16:11:10 2010 @@ -22,42 +22,42 @@ under the License. xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd"> <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="IMAGE" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="IMAGE" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="IMAGE" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="DATETIME" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="DATETIME" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="DATETIME" java-type="java.sql.Time"></field-type-def> - - <field-type-def type="currency-amount" sql-type="DECIMAL(18,2)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="DECIMAL(18,3)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="DECIMAL(18,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="FLOAT" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="INT" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="VARCHAR(250)" java-type="String"></field-type-def> - - <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="TEXT" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="IMAGE" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="IMAGE" java-type="byte[]"/> + <field-type-def type="object" sql-type="IMAGE" java-type="Object"/> + + <field-type-def type="date-time" sql-type="DATETIME" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="DATETIME" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="DATETIME" java-type="java.sql.Time"/> + + <field-type-def type="currency-amount" sql-type="DECIMAL(18,2)" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="DECIMAL(18,3)" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="DECIMAL(18,6)" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="FLOAT" java-type="Double"/> + <field-type-def type="numeric" sql-type="INT" java-type="Long"/> + + <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong" sql-type="VARCHAR(250)" java-type="String"/> + + <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"/> + <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"/> + <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="very-long" sql-type="TEXT" java-type="String"/> + + <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"/> + <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="VARCHAR(250)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="VARCHAR(250)" java-type="String"/> + <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"/> </fieldtypemodel> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml Thu Jul 1 16:11:10 2010 @@ -22,42 +22,42 @@ under the License. xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd"> <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="LONGBLOB" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="LONGBLOB" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="LONGBLOB" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="DATETIME" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def> - - <field-type-def type="currency-amount" sql-type="DECIMAL(18,2)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="DECIMAL(18,3)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="DECIMAL(18,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="DOUBLE" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="DECIMAL(20,0)" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="VARCHAR(250)" java-type="String"></field-type-def> - - <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="LONGTEXT" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="LONGBLOB" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="LONGBLOB" java-type="byte[]"/> + <field-type-def type="object" sql-type="LONGBLOB" java-type="Object"/> + + <field-type-def type="date-time" sql-type="DATETIME" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"/> + + <field-type-def type="currency-amount" sql-type="DECIMAL(18,2)" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="DECIMAL(18,3)" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="DECIMAL(18,6)" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="DOUBLE" java-type="Double"/> + <field-type-def type="numeric" sql-type="DECIMAL(20,0)" java-type="Long"/> + + <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong" sql-type="VARCHAR(250)" java-type="String"/> + + <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"/> + <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"/> + <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="very-long" sql-type="LONGTEXT" java-type="String"/> + + <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"/> + <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="VARCHAR(250)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="VARCHAR(250)" java-type="String"/> + <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"/> </fieldtypemodel> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml Thu Jul 1 16:11:10 2010 @@ -22,23 +22,23 @@ under the License. xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd"> <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="BLOB" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="BLOB" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="BLOB" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="TIMESTAMP" sql-type-alias="TIMESTAMP(6)" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="DATE" java-type="java.sql.Time"></field-type-def> - - <field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="NUMBER(18,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="NUMBER(18,6)" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="VARCHAR2(20)" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="VARCHAR2(60)" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="BLOB" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="BLOB" java-type="byte[]"/> + <field-type-def type="object" sql-type="BLOB" java-type="Object"/> + + <field-type-def type="date-time" sql-type="TIMESTAMP" sql-type-alias="TIMESTAMP(6)" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="DATE" java-type="java.sql.Time"/> + + <field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="NUMBER(18,6)" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="NUMBER(18,6)" java-type="Double"/> + <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"/> + + <field-type-def type="id" sql-type="VARCHAR2(20)" java-type="String"/> + <field-type-def type="id-long" sql-type="VARCHAR2(60)" java-type="String"/> + <field-type-def type="id-vlong" sql-type="VARCHAR2(255)" java-type="String"/> <!-- we had a customer using Oracle 11g with the following error after running any service in webtools. Service dispatcher threw an exceptionResult set was empty for entity: @@ -48,30 +48,30 @@ under the License. [GenericEntity:RuntimeData][runtimeDataId,10205(java.lang.String)])) adding the fieldtype - <field-type-def type="long" sql-type="LONG" java-type="String"><validate method="isNotEmpty"/></field-type-def> + <field-type-def type="long" sql-type="LONG" java-type="String"><validate method="isNotEmpty"//> and changing the fieldtype in RunTimeData: <field name="runtimeInfo" type="long"></field> cured the problem. (HB) --> - <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="VARCHAR2(10)" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="VARCHAR2(60)" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="CLOB" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="VARCHAR2(100)" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> + <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"/> + <field-type-def type="very-short" sql-type="VARCHAR2(10)" java-type="String"/> + <field-type-def type="short-varchar" sql-type="VARCHAR2(60)" java-type="String"/> + <field-type-def type="long-varchar" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="very-long" sql-type="CLOB" java-type="String"/> + + <field-type-def type="comment" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="description" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="name" sql-type="VARCHAR2(100)" java-type="String"/> + <field-type-def type="value" sql-type="VARCHAR2(255)" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="VARCHAR2(255)" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="VARCHAR2(20)" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="VARCHAR2(255)" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="VARCHAR2(255)" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="VARCHAR2(20)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="VARCHAR2(60)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="VARCHAR2(255)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="VARCHAR2(60)" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="VARCHAR2(20)" java-type="String"/> + <field-type-def type="email" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="url" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="id-ne" sql-type="VARCHAR2(20)" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="VARCHAR2(60)" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="VARCHAR2(255)" java-type="String"/> + <field-type-def type="tel-number" sql-type="VARCHAR2(60)" java-type="String"/> </fieldtypemodel> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml Thu Jul 1 16:11:10 2010 @@ -22,42 +22,42 @@ under the License. xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd"> <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="BYTEA" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="BYTEA" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="BYTEA" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="TIMESTAMPTZ" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def> - - <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="NUMERIC(18,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="FLOAT8" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - - <field-type-def type="indicator" sql-type="CHAR(1)" sql-type-alias="BPCHAR" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="TEXT" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="BYTEA" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="BYTEA" java-type="byte[]"/> + <field-type-def type="object" sql-type="BYTEA" java-type="Object"/> + + <field-type-def type="date-time" sql-type="TIMESTAMPTZ" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"/> + + <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="NUMERIC(18,6)" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="FLOAT8" java-type="Double"/> + <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"/> + + <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong" sql-type="VARCHAR(255)" java-type="String"/> + + <field-type-def type="indicator" sql-type="CHAR(1)" sql-type-alias="BPCHAR" java-type="String"/> + <field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"/> + <field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="very-long" sql-type="TEXT" java-type="String"/> + + <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"/> + <field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" java-type="String"/> + <field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"/> </fieldtypemodel> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypepostnew.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypepostnew.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypepostnew.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypepostnew.xml Thu Jul 1 16:11:10 2010 @@ -53,42 +53,42 @@ under the License. xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd"> <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="BYTEA" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="BYTEA" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="BYTEA" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="TIMESTAMPTZ" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def> - - <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="NUMERIC(18,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="FLOAT8" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="TEXT" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="TEXT" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="TEXT" java-type="String"></field-type-def> - - <field-type-def type="indicator" sql-type="CHAR(1)" sql-type-alias="BPCHAR" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="TEXT" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="TEXT" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="TEXT" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="TEXT" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="TEXT" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="TEXT" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="TEXT" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="TEXT" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="BYTEA" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="BYTEA" java-type="byte[]"/> + <field-type-def type="object" sql-type="BYTEA" java-type="Object"/> + + <field-type-def type="date-time" sql-type="TIMESTAMPTZ" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"/> + + <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="NUMERIC(18,6)" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="FLOAT8" java-type="Double"/> + <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"/> + + <field-type-def type="id" sql-type="TEXT" java-type="String"/> + <field-type-def type="id-long" sql-type="TEXT" java-type="String"/> + <field-type-def type="id-vlong" sql-type="TEXT" java-type="String"/> + + <field-type-def type="indicator" sql-type="CHAR(1)" sql-type-alias="BPCHAR" java-type="String"/> + <field-type-def type="very-short" sql-type="TEXT" java-type="String"/> + <field-type-def type="short-varchar" sql-type="TEXT" java-type="String"/> + <field-type-def type="long-varchar" sql-type="TEXT" java-type="String"/> + <field-type-def type="very-long" sql-type="TEXT" java-type="String"/> + + <field-type-def type="comment" sql-type="TEXT" java-type="String"/> + <field-type-def type="description" sql-type="TEXT" java-type="String"/> + <field-type-def type="name" sql-type="TEXT" java-type="String"/> + <field-type-def type="value" sql-type="TEXT" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="TEXT" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="TEXT" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="TEXT" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="TEXT" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="TEXT" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="TEXT" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="TEXT" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="TEXT" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="TEXT" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="TEXT" java-type="String"/> + <field-type-def type="email" sql-type="TEXT" java-type="String"/> + <field-type-def type="url" sql-type="TEXT" java-type="String"/> + <field-type-def type="id-ne" sql-type="TEXT" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="TEXT" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="TEXT" java-type="String"/> + <field-type-def type="tel-number" sql-type="TEXT" java-type="String"/> </fieldtypemodel> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml?rev=959708&r1=959707&r2=959708&view=diff ============================================================================== --- ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml (original) +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml Thu Jul 1 16:11:10 2010 @@ -22,43 +22,43 @@ under the License. xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd"> <!-- ===================== field-type-def ==================== --> <!-- General Types --> - <field-type-def type="blob" sql-type="LONG BYTE" sql-type-alias="LONG BYTE" java-type="java.sql.Blob"></field-type-def> - <field-type-def type="byte-array" sql-type="LONG BYTE" sql-type-alias="LONG BYTE" java-type="byte[]"></field-type-def> - <field-type-def type="object" sql-type="LONG BYTE" sql-type-alias="LONG BYTE" java-type="Object"></field-type-def> - - <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def> - <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def> - <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def> - - <field-type-def type="currency-amount" sql-type="FIXED(18,2)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="currency-precise" sql-type="FIXED(18,3)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="fixed-point" sql-type="FIXED(18,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="floating-point" sql-type="FIXED(18,6)" java-type="Double"><validate method="isSignedDouble"/></field-type-def> - <field-type-def type="numeric" sql-type="FIXED(20,0)" java-type="Long"><validate method="isSignedLong"/></field-type-def> - - <field-type-def type="id" sql-type="VARCHAR(20) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def> - <field-type-def type="id-long" sql-type="VARCHAR(60) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def> - <field-type-def type="id-vlong" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def> - - <field-type-def type="indicator" sql-type="CHAR(1) UNICODE" sql-type-alias="CHAR() UNICODE" java-type="String"></field-type-def> - <field-type-def type="very-short" sql-type="VARCHAR(10) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def> - <field-type-def type="short-varchar" sql-type="VARCHAR(60) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def> - <field-type-def type="long-varchar" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def> - <field-type-def type="very-long" sql-type="LONG UNICODE" sql-type-alias="LONG UNICODE" java-type="String"></field-type-def> - - <field-type-def type="comment" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def> - <field-type-def type="description" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def> - <field-type-def type="name" sql-type="VARCHAR(100) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def> - <field-type-def type="value" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def> + <field-type-def type="blob" sql-type="LONG BYTE" sql-type-alias="LONG BYTE" java-type="java.sql.Blob"/> + <field-type-def type="byte-array" sql-type="LONG BYTE" sql-type-alias="LONG BYTE" java-type="byte[]"/> + <field-type-def type="object" sql-type="LONG BYTE" sql-type-alias="LONG BYTE" java-type="Object"/> + + <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"/> + <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"/> + <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"/> + + <field-type-def type="currency-amount" sql-type="FIXED(18,2)" java-type="java.math.BigDecimal"/> + <field-type-def type="currency-precise" sql-type="FIXED(18,3)" java-type="java.math.BigDecimal"/> + <field-type-def type="fixed-point" sql-type="FIXED(18,6)" java-type="java.math.BigDecimal"/> + <field-type-def type="floating-point" sql-type="FIXED(18,6)" java-type="Double"/> + <field-type-def type="numeric" sql-type="FIXED(20,0)" java-type="Long"/> + + <field-type-def type="id" sql-type="VARCHAR(20) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="id-long" sql-type="VARCHAR(60) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="id-vlong" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + + <field-type-def type="indicator" sql-type="CHAR(1) UNICODE" sql-type-alias="CHAR() UNICODE" java-type="String"/> + <field-type-def type="very-short" sql-type="VARCHAR(10) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="short-varchar" sql-type="VARCHAR(60) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="long-varchar" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="very-long" sql-type="LONG UNICODE" sql-type-alias="LONG UNICODE" java-type="String"/> + + <field-type-def type="comment" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="description" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="name" sql-type="VARCHAR(100) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="value" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> <!-- Specialized Types --> - <field-type-def type="credit-card-number" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"><validate method="isAnyCard"/></field-type-def> - <field-type-def type="credit-card-date" sql-type="VARCHAR(20) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"><validate method="isDateAfterToday"/></field-type-def> - <field-type-def type="email" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"><validate method="isEmail"/></field-type-def> - <field-type-def type="url" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def> - <field-type-def type="id-ne" sql-type="VARCHAR(20) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-long-ne" sql-type="VARCHAR(60) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"><validate method="isNotEmpty"/></field-type-def> - <field-type-def type="tel-number" sql-type="VARCHAR(60) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"><validate method="isInternationalPhoneNumber"/></field-type-def> + <field-type-def type="credit-card-number" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="credit-card-date" sql-type="VARCHAR(20) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="email" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="url" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="id-ne" sql-type="VARCHAR(20) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="id-long-ne" sql-type="VARCHAR(60) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> + <field-type-def type="tel-number" sql-type="VARCHAR(60) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"/> </fieldtypemodel> |
«
Return to OFBiz - Commits
|
1 view|%1 views
| Free forum by Nabble | Edit this page |