Re: M1 Security Schema MSSQL Constraints
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?
[jira] Created: (JS2-175) Easier user interface for creating new users
Easier user interface for creating new users Key: JS2-175 URL: http://nagoya.apache.org/jira/browse/JS2-175 Project: Jetspeed 2 Type: Improvement Components: Admin Portlets Versions: 2.0-M2 Reporter: David Sean Taylor Fix For: 2.0-M2 Make the user interface for creating a new user easier. From the Add User form, the user will be able to: 1. select the default role for user 2. select the profiler rule for finding a page From the details view of the User: 1. list box to select 1..n roles per user -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://nagoya.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[jira] Assigned: (JS2-175) Easier user interface for creating new users
[ http://nagoya.apache.org/jira/browse/JS2-175?page=history ] David Sean Taylor reassigned JS2-175: - Assign To: David Sean Taylor Easier user interface for creating new users Key: JS2-175 URL: http://nagoya.apache.org/jira/browse/JS2-175 Project: Jetspeed 2 Type: Improvement Components: Admin Portlets Versions: 2.0-M2 Reporter: David Sean Taylor Assignee: David Sean Taylor Fix For: 2.0-M2 Make the user interface for creating a new user easier. From the Add User form, the user will be able to: 1. select the default role for user 2. select the profiler rule for finding a page From the details view of the User: 1. list box to select 1..n roles per user -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://nagoya.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[jira] Updated: (JS2-175) Easier user interface for creating new users
[ http://nagoya.apache.org/jira/browse/JS2-175?page=history ] David Sean Taylor updated JS2-175: -- Description: Make the user interface for creating a new user easier. From the Add User form, the user will be able to: 1. select the default role for user 2. select the profiler rule for finding a page From the details view of the User: 1. list box to select 1..n roles per user was: Make the user interface for creating a new user easier. From the Add User form, the user will be able to: 1. select the default role for user 2. select the profiler rule for finding a page From the details view of the User: 1. list box to select 1..n roles per user Version: 2.0-M2 Component: Admin Portlets Fix Version: 2.0-M2 Easier user interface for creating new users Key: JS2-175 URL: http://nagoya.apache.org/jira/browse/JS2-175 Project: Jetspeed 2 Type: Improvement Components: Admin Portlets Versions: 2.0-M2 Reporter: David Sean Taylor Assignee: David Sean Taylor Fix For: 2.0-M2 Make the user interface for creating a new user easier. From the Add User form, the user will be able to: 1. select the default role for user 2. select the profiler rule for finding a page From the details view of the User: 1. list box to select 1..n roles per user -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://nagoya.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
cvs commit: jakarta-jetspeed-2/src/database/hsql manageTest.sh manageTest.bat manageProd.bat manageProd.sh
taylor 2004/12/21 16:14:54 Added: src/database/hsql manageTest.sh manageTest.bat manageProd.bat manageProd.sh Log: single user mode scripts for editing the HSQL database CVS: -- CVS: PR: CVS: If this change addresses a PR in the problem report tracking CVS: database, then enter the PR number(s) here. CVS: Obtained from: CVS: If this change has been taken from another system, such as NCSA, CVS: then name the system in this line, otherwise delete it. CVS: Submitted by: CVS: If this code has been contributed to Apache by someone else; i.e., CVS: they sent us a patch or a new module, then include their name/email CVS: address here. If this is your work then delete this line. CVS: Reviewed by: CVS: If we are doing pre-commit code reviews and someone else has CVS: reviewed your changes, include their name(s) here. CVS: If you have not had it reviewed then delete this line. Revision ChangesPath 1.1 jakarta-jetspeed-2/src/database/hsql/manageTest.sh Index: manageTest.sh === #!/bin/sh # Copyright 2004 The Apache Software Foundation # # Licensed under the Apache License, Version 2.0 (the License); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an AS IS BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. java -classpath %CLASSPATH%:hsqldb.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Test 1.1 jakarta-jetspeed-2/src/database/hsql/manageTest.bat Index: manageTest.bat === @ECHO OFF REM Copyright 2004 The Apache Software Foundation REM REM Licensed under the Apache License, Version 2.0 (the License); REM you may not use this file except in compliance with the License. REM You may obtain a copy of the License at REM REM http://www.apache.org/licenses/LICENSE-2.0 REM REM Unless required by applicable law or agreed to in writing, software REM distributed under the License is distributed on an AS IS BASIS, REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. REM See the License for the specific language governing permissions and REM limitations under the License. REM *** @java -classpath %CLASSPATH%;hsqldb.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Test 1.1 jakarta-jetspeed-2/src/database/hsql/manageProd.bat Index: manageProd.bat === @ECHO OFF REM Copyright 2004 The Apache Software Foundation REM REM Licensed under the Apache License, Version 2.0 (the License); REM you may not use this file except in compliance with the License. REM You may obtain a copy of the License at REM REM http://www.apache.org/licenses/LICENSE-2.0 REM REM Unless required by applicable law or agreed to in writing, software REM distributed under the License is distributed on an AS IS BASIS, REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. REM See the License for the specific language governing permissions and REM limitations under the License. REM *** @java -classpath %CLASSPATH%;hsqldb.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Production 1.1 jakarta-jetspeed-2/src/database/hsql/manageProd.sh Index: manageProd.sh === #!/bin/sh # Copyright 2004 The Apache Software Foundation # # Licensed under the Apache License, Version 2.0 (the License); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an AS IS BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. java -classpath %CLASSPATH%:hsqldb.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Production - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
cvs commit: jakarta-jetspeed-2/src/database/hsql manageTest.sh manageTest.bat manageProd.bat manageProd.sh
taylor 2004/12/21 17:25:17 Modified:src/database/hsql manageTest.sh manageTest.bat manageProd.bat manageProd.sh Log: point at maven home to get driver CVS: -- CVS: PR: CVS: If this change addresses a PR in the problem report tracking CVS: database, then enter the PR number(s) here. CVS: Obtained from: CVS: If this change has been taken from another system, such as NCSA, CVS: then name the system in this line, otherwise delete it. CVS: Submitted by: CVS: If this code has been contributed to Apache by someone else; i.e., CVS: they sent us a patch or a new module, then include their name/email CVS: address here. If this is your work then delete this line. CVS: Reviewed by: CVS: If we are doing pre-commit code reviews and someone else has CVS: reviewed your changes, include their name(s) here. CVS: If you have not had it reviewed then delete this line. Revision ChangesPath 1.2 +1 -1 jakarta-jetspeed-2/src/database/hsql/manageTest.sh Index: manageTest.sh === RCS file: /home/cvs/jakarta-jetspeed-2/src/database/hsql/manageTest.sh,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- manageTest.sh 22 Dec 2004 00:14:54 - 1.1 +++ manageTest.sh 22 Dec 2004 01:25:16 - 1.2 @@ -12,4 +12,4 @@ # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. -java -classpath %CLASSPATH%:hsqldb.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Test +java -classpath $HOME/.maven/repository/hsqldb/jars/hsqldb-1.7.1.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Test 1.2 +1 -1 jakarta-jetspeed-2/src/database/hsql/manageTest.bat Index: manageTest.bat === RCS file: /home/cvs/jakarta-jetspeed-2/src/database/hsql/manageTest.bat,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- manageTest.bat22 Dec 2004 00:14:54 - 1.1 +++ manageTest.bat22 Dec 2004 01:25:16 - 1.2 @@ -15,4 +15,4 @@ REM limitations under the License. REM *** [EMAIL PROTECTED] -classpath %CLASSPATH%;hsqldb.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Test [EMAIL PROTECTED] -classpath %HOME%/.maven/repository/hsqldb/jars/hsqldb-1.7.1.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Test 1.2 +1 -1 jakarta-jetspeed-2/src/database/hsql/manageProd.bat Index: manageProd.bat === RCS file: /home/cvs/jakarta-jetspeed-2/src/database/hsql/manageProd.bat,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- manageProd.bat22 Dec 2004 00:14:54 - 1.1 +++ manageProd.bat22 Dec 2004 01:25:16 - 1.2 @@ -15,4 +15,4 @@ REM limitations under the License. REM *** [EMAIL PROTECTED] -classpath %CLASSPATH%;hsqldb.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Production [EMAIL PROTECTED] -classpath %HOME%/.maven/repository/hsqldb/jars/hsqldb-1.7.1.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Production 1.2 +1 -1 jakarta-jetspeed-2/src/database/hsql/manageProd.sh Index: manageProd.sh === RCS file: /home/cvs/jakarta-jetspeed-2/src/database/hsql/manageProd.sh,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- manageProd.sh 22 Dec 2004 00:14:54 - 1.1 +++ manageProd.sh 22 Dec 2004 01:25:16 - 1.2 @@ -12,4 +12,4 @@ # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. -java -classpath %CLASSPATH%:hsqldb.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Production +java -classpath $HOME/.maven/repository/hsqldb/jars/hsqldb-1.7.1.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:Production - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]