Re: jetspeed2-M1 with mssql

[Randy Watler]

Carlos,
I too use MSSQL in production and have ported J2 M1 successfully. 
However, there are some issues with the security-schema.sql script for 
MSSQL involving multiple cascading delete paths on foreign keys. I am 
still working on a solution for M2. I have not used the M1 installer 
yet, so I am not sure when/where to apply the attached patch, (I use the 
M1 release tarball on Linux). With the M1 release, one needs to run this 
patch before running ant to setup the database. Good luck!

Randy
[EMAIL PROTECTED] wrote:
Mr. Scott,
  excellent, yeah any help would be appreciated.  I trying to get it all 
ready for a production install myself.  That mean that the jetspeed2 login 
portlet work for you with ms-sql,tomcat 5.0.28?  It worked with hsql, but 
not mssql.

anyway, you could be my hero. Again, it is a sweet install.  I can't wait to 
hear back.

Thanks,
Carlos.

I use Jetspeed 2 with MSSQL in production, however I always install 
manually and not with the installer.  I wrote the installer so I will 
run some tests on our MSSQL instance here and see if I can get it to work.

E-mail Protected wrote:
 

Anyone try to build JetSpeed2-M1 with Mssql using the installer or the CVS 
download?

I used the installer and CVS.  everything worked expect when creating the 
entire database.  i had to run the sql scripts by hand and then the 
   

populate 
 

script by hand.  Also, the loginPortlet doesn't work, i keep getting 
LoginModule not found.  

I re-installed with hsql.  and everything worked like a charm!! A real 
   

sweet 
 

install. My complements to the chefs.  So now i just got to get the same 
result on mssql.

and tips out there for me? (that is besides don't use msssql :-))
Thanks,
Carlos.
   


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 


--- security-schema.sql.orig    2004-12-16 17:44:26.000000000 -0700
+++ security-schema.sql 2004-12-16 17:43:45.000000000 -0700
@@ -603,7 +603,7 @@
 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 
+    ON DELETE NO ACTION 
 END    
 ;
 
@@ -649,7 +649,7 @@
 ALTER TABLE SECURITY_USER_ROLE
     ADD CONSTRAINT SECURITY_USER_ROLE_FK_2 FOREIGN KEY (USER_ID)
     REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
-    ON DELETE CASCADE 
+    ON DELETE NO ACTION 
 END    
 ;
 
@@ -672,7 +672,7 @@
 ALTER TABLE SECURITY_USER_GROUP
     ADD CONSTRAINT SECURITY_USER_GROUP_FK_2 FOREIGN KEY (USER_ID)
     REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
-    ON DELETE CASCADE 
+    ON DELETE NO ACTION 
 END    
 ;
 
@@ -695,7 +695,7 @@
 ALTER TABLE SECURITY_GROUP_ROLE
     ADD CONSTRAINT SECURITY_GROUP_ROLE_FK_2 FOREIGN KEY (ROLE_ID)
     REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
-    ON DELETE CASCADE 
+    ON DELETE NO ACTION 
 END    
 ;
 
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]