Hai David, Thanks alot for the prompt reply, I resolve the problem.
Cheers, Nishar. -----Original Message----- From: David Sean Taylor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:43 PM To: Jetspeed Users List Subject: RE: Exception when new user creation ......Urgent There seems to be a problem when you create the PSML, which then throws an exception, the transaction tries to rollback by deleting the user from the db, and then you finally get the exception below. The root of the problem is that the PSML fails to create, yet its unfortunate that we don't have the original stack trace which was actually printed out to the console. See the method addDefaultPSML where it prints the stack trace. Modify this and change the stack trace to go to the log file, or just send us the stacktrace from the console. catch (Exception e) { e.printStackTrace(); removeUser(new UserNamePrincipal(user.getUserName())); throw new UserException("Failed to create profile for new user ", e); } Also, are you using DB PSML? The secondary problem seems to be that the cascading delete option wasn't properly generated. Make sure that the torque generated sql file has the cascade delete option: ALTER TABLE TURBINE_USER_GROUP_ROLE ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_1 FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID) ON DELETE CASCADE; (I also use Oracle, and it generated correctly for me) And, when using Oracle, make sure that you set this to false: services.JetspeedSecurity.programmatic.cascade.delete=false -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
