ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Debmalya Jash" <debma...@techmahindra.com>
Subject How to define "NOT NULL" constraint for the non-primary keys?
Date Mon, 03 Jul 2006 05:50:47 GMT

Hello All,

 

I have to define a field with NOT NULL constraint. This field is not a part
of primary key.

 

I thought following field type will create "NOT NULL" constraint.

 

<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>

 

"NOT NULL" constraint added to only the primary keys.

 

How to define "NOT NULL" constraint for the non-primary keys?

 

-thanks & best regards,

Debmalya 



============================================================================================================================

Tech Mahindra, formerly Mahindra-British Telecom.
 

Disclaimer:


The contents of this E-mail (including the contents of the enclosure(s) or attachment(s) if
any) are privileged and confidential material of Tech Mahindra and should not be disclosed
to, used by or copied in any manner by anyone other than the intended addressee(s). In case
you are not the desired addressee, you should delete this message and/or re-direct it to the
sender. The views expressed in this E-mail message (including the enclosure(s) or attachment(s)
if any) are those of the individual sender, except where the sender expressly, and with authority,
states them to be the views of Tech Mahindra.


This e-mail message including attachment/(s), if any, is believed to be free of any virus.
However, it is the responsibility of the recipient to ensure that it is virus free and Tech
Mahindra is not responsible for any loss or damage arising in any way from its use.

============================================================================================================================
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message