portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Randy Watler <rwat...@finali.com>
Subject Re: M1 Security Schema MSSQL Constraints
Date Tue, 21 Dec 2004 17:35:19 GMT
Gang,

Ok, I will look into extending the Torque macros to add support at the 
DB level via triggers. I am not sure it is possible, (it will depend on 
what cross table access to the schema definition is available from the 
velocity templates). BTW, it does not appear that commons-sql supports 
MS SQL Server triggers either.

Randy

David Sean Taylor wrote:

>
> On Dec 20, 2004, at 7:35 AM, Scott T. Weaver wrote:
>
>> I am getting the same thing now.  We need to role back the SQL logic  
>> to the point before the M1 release when this was not an issue.
>>
>
> If we role back the logic, then the cascading deletes will no longer  
> work leaving orphaned records requiring us to programmatically  
> implement cascading deletes
> Im -1 on that and much prefer the backend database to manage data   
> integrity
>
> But i don't care about MSSQL. If you all need to remove the FK for  
> MSSQL then thats fine by me.
> We could make it configurable in the build
>
>> Randy Watler wrote:
>>
>>> David/Ate/Scott,
>>>
>>> While executing the M1 scripts for DB configuration of MS SQL 
>>> Server  2K, I ended up with these errors:
>>>
>>> db.execute:
>>>     [echo] Executing scripts for ./sql/DDL/mssql/security-schema.sql
>>>      [sql] Executing file:  
>>> /usr/share/tomcat5/jetspeed-database/scripts/sql/DDL/mssql/security- 
>>> schema.sql
>>>      [sql] Failed to execute:   BEGIN ALTER TABLE  
>>> SSO_PRINCIPAL_TO_REMOTE ADD CONSTRAINT SSO_PRINCIPAL_TO_REMOTE_FK_2  
>>> FOREIGN KEY (REMOTE_PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL  
>>> (PRINCIPAL_ID) ON DELETE CASCADE END
>>>
>>> BUILD FAILED
>>> /usr/share/tomcat5/jetspeed-database/scripts/build.xml:64: The  
>>> following error occurred while executing this line:
>>> /usr/share/tomcat5/jetspeed-database/scripts/build.xml:38:  
>>> java.sql.SQLException: Introducing FOREIGN KEY constraint  
>>> 'SSO_PRINCIPAL_TO_REMOTE_FK_2' on table 'SSO_PRINCIPAL_TO_REMOTE' 
>>> may  cause cycles or multiple cascade paths. Specify ON DELETE NO 
>>> ACTION  or ON UPDATE NO ACTION, or modify other FOREIGN KEY 
>>> constraints.
>>>
>>> ---------------------------------------------------------------------- 
>>> ------------------------------------
>>>
>>> db.execute:
>>>     [echo] Executing scripts for ./sql/DDL/mssql/security-schema.sql
>>>      [sql] Executing file:  
>>> /usr/share/tomcat5/jetspeed-database/scripts/sql/DDL/mssql/security- 
>>> schema.sql
>>>      [sql] Failed to execute:   BEGIN ALTER TABLE 
>>> SECURITY_USER_ROLE  ADD CONSTRAINT SECURITY_USER_ROLE_FK_2 FOREIGN 
>>> KEY (USER_ID)  REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID) ON 
>>> DELETE CASCADE END
>>>
>>> BUILD FAILED
>>> /usr/share/tomcat5/jetspeed-database/scripts/build.xml:64: The  
>>> following error occurred while executing this line:
>>> /usr/share/tomcat5/jetspeed-database/scripts/build.xml:38:  
>>> java.sql.SQLException: Introducing FOREIGN KEY constraint  
>>> 'SECURITY_USER_ROLE_FK_2' on table 'SECURITY_USER_ROLE' may cause  
>>> cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON  
>>> UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
>>>
>>> ---------------------------------------------------------------------- 
>>> ------------------------------------
>>>
>>> db.execute:
>>>     [echo] Executing scripts for ./sql/DDL/mssql/security-schema.sql
>>>      [sql] Executing file:  
>>> /usr/share/tomcat5/jetspeed-database/scripts/sql/DDL/mssql/security- 
>>> schema.sql
>>>      [sql] Failed to execute:   BEGIN ALTER TABLE 
>>> SECURITY_USER_GROUP  ADD CONSTRAINT SECURITY_USER_GROUP_FK_2 FOREIGN 
>>> KEY (USER_ID)  REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID) ON 
>>> DELETE CASCADE END
>>>
>>> BUILD FAILED
>>> /usr/share/tomcat5/jetspeed-database/scripts/build.xml:64: The  
>>> following error occurred while executing this line:
>>> /usr/share/tomcat5/jetspeed-database/scripts/build.xml:38:  
>>> java.sql.SQLException: Introducing FOREIGN KEY constraint  
>>> 'SECURITY_USER_GROUP_FK_2' on table 'SECURITY_USER_GROUP' may cause  
>>> cycles or multiple cascade paths. Specify ON DELETE NO ACTION or
>>> ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
>>>
>>> ---------------------------------------------------------------------- 
>>> ------------------------------------
>>>
>>> db.execute:
>>>     [echo] Executing scripts for ./sql/DDL/mssql/security-schema.sql
>>>      [sql] Executing file:  
>>> /usr/share/tomcat5/jetspeed-database/scripts/sql/DDL/mssql/security- 
>>> schema.sql
>>>      [sql] Failed to execute:   BEGIN ALTER TABLE 
>>> SECURITY_GROUP_ROLE  ADD CONSTRAINT SECURITY_GROUP_ROLE_FK_2 FOREIGN 
>>> KEY (ROLE_ID)  REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID) ON 
>>> DELETE CASCADE END
>>>
>>> BUILD FAILED
>>> /usr/share/tomcat5/jetspeed-database/scripts/build.xml:64: The  
>>> following error occurred while executing this line:
>>> /usr/share/tomcat5/jetspeed-database/scripts/build.xml:38:  
>>> java.sql.SQLException: Introducing FOREIGN KEY constraint  
>>> 'SECURITY_GROUP_ROLE_FK_2' on table 'SECURITY_GROUP_ROLE' may cause  
>>> cycles or multiple cascade paths. Specify ON DELETE NO ACTION or
>>> ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
>>>
>>>
>>> I worked around this by patching the constraints setting them to  
>>> "DELETE NO ACTION", but I have not attempted to diagnose or fix 
>>> this  issue for real. Anyone else seen these errors?
>>>
>>> Randy
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>>>
>>>
>>>
>>
>>
>> -- 
>> "Great minds discuss ideas. Average minds discuss events. Small 
>> minds  discuss people."  - Admiral Hyman Rickover
>>
>> *******************************************
>> *           Scott T. Weaver               *
>> *         <weaver@apache.org>             *
>> *     <http://www.einnovation.com>        *
>> * --------------------------------------  *
>> *   Apache Jetspeed Enterprise Portal     *
>> *     Apache Pluto Portlet Container      *
>> *                                         *
>> * OpenEdit, Website Content Management    *
>> *     <http://www.openedit.org>           *
>> *******************************************
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>>
>>
>>
>
> -- 
> David Sean Taylor
> Bluesunrise Software
> david@bluesunrise.com
> [office]   +01 707 773-4646
> [mobile] +01 707 529 9194
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>

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