portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 20104] - [FIX] db2 ddl - unique constraints with nullable columns
Date Tue, 08 Jul 2003 14:18:08 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20104>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20104

[FIX] db2 ddl  - unique constraints with nullable columns





------- Additional Comments From sbelden@bjc.org  2003-07-08 14:18 -------
What worked for me was to remove the language and country unique constraints and
define media_type and page as NOT NULL.  For my situation this was an acceptable
level of db-guaranteed uniqueness.  (USER_NAME->MEDIA_TYPE->PAGE) will always be
unique as USER_NAME (as well as ROLE_NAME and GROUP_NAME) are all forced to be
unique by application logic.  

see http://stumod.com/jetspeed/ for a walkthrough on getting db2 and Jetspeed
working together (as of 1.4b5-dev).

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


Mime
View raw message