Hi Michael, The only way I could figure out how to do this is move all the TURBINE_* tables from turbine-security-schema.xml to [project]-schema.xml. Then you can create the foreign keys in that file. All the other ways I tried resulted in Torque or Turbine complaining about something or other.
Good luck, David -----Original Message----- From: Michael Kunze [mailto:[EMAIL PROTECTED] Sent: Wednesday February 9, 2005 1:11 AM To: [email protected] Subject: Problems using the turbine user table Hello, i want to connect my tables to the turbine user table, eg. using the user_id as a foreign key in my own tables. As i understand it i have to follow the howto on the website about extending the user. but i do not really put extra columns in there so i did the following: (my app is called dbkg therefore my package is called com.adcosys.dbkg. i put this into my dbkg-schema.xml: <table name="EXTENDED_USER" alias="TurbineUser"> <column name="user_id" required="true" primaryKey="true" type="INTEGER"/> </table> so that works now: <table ...> <foreign-key foreignTable="EXTENDED_USER"> <reference local="user_id" foreign="user_id"/> </foreign-key> </table> so far everything is good. next step was to edit the turbine-om.properties: services.SecurityService.classname=org.apache.turbine.services.security.torq ue.TorqueSecurityService services.SecurityService.user.manager = org.apache.turbine.services.security.db.DBUserManager services.SecurityService.user.class = com.adcosys.dbkg.om.ExtendedUser services.SecurityService.group.class = com.adcosys.dbkg.om.TorqueGroup services.SecurityService.permission.class = com.adcosys.dbkg.om.TorquePermission services.SecurityService.role.class = com.adcosys.dbkg.om.TorqueRole services.SecurityService.userPeer.class = com.adcosys.dbkg.om.ExtendedUserPeer services.SecurityService.groupPeer.class = com.adcosys.dbkg.om.TurbineGroupPeer services.SecurityService.permissionPeer.class = com.adcosys.dbkg.om.TurbinePermissionPeer services.SecurityService.rolePeer.class = com.adcosys.dbkg.om.TurbineRolePeer services.AvalonComponentService.lookup = org.apache.torque.avalon.Torque If i do that and restart tomcat i immediatly get a stacktrace (which i can't provide right now because i'm at work. can do tonight) after i visit my webapp in browser. It's complaining that it cannot intantiate the user class (for the anon user). Remember: All i want to archieve is to link my table to the turbine tables. i'm somehow lost. Already tried everything i can imagine (which is not much at the moment) if someone can point me into the correct direction i can provide more info. at the moment i do not even know where to start looking. thank you for your time! michael -- Michael Kunze http://www.smrealms.de ---------------------------------------------------------------- This message was sent using https://www.datenschleuder.org's IMP --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
