commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Philip DONAGHY <Philip.DONA...@thales-is.com>
Subject [sql]Applying xml schema constraints on the database model
Date Thu, 02 Dec 2004 13:25:17 GMT
We are making a datamodel from xml schema and would like to suggest
support for constraints in a similar way xml schema does it. For example
if an element of an xml instance can contain a maximum of 3 child
elements (maxOccurs="3"), can the commons sql datamodel add a "trigger
before insert" which verifies that there are not more than 3 children
inserted in the child table. The same could be done for "trigger before
delete" for minOccurs constraints.

What does the Apache community of Java Thinkers make of this nasty idea
:p

Any other ideas for xml schema-like support in the relational database
model.

If this is not a good idea what would be the alternatives?

Philip Donaghy and Olivier Croisier

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message