Hi Thomas, have you read
http://jakarta.apache.org/turbine/turbine/turbine-2.3.2/howto/extend-user-howto.html also? Kind regards Juergen Hoffmann Am Montag, 15. Mai 2006 01:59 schrieb [EMAIL PROTECTED]: > Thanks a lot Helge for your answer! I am not sure but I think that I am not > going to extend TURBINE_USER. but create a new table instead like in scarab > USER_PREFERENCE > > But for the 'fun', I ve tried both methods ;-) > > >>>>>>> 1st - I ve extended the TUBINE_USER in my-project-schema.xml. > >>>>>>> <<<<<<<< > > * I've added a new column called 'LOCALEID' > > <table name="USER" idMethod="native" > > baseClass="org.apache.turbine.services.security.torque.om.BaseTurbineUser" > basePeer="org.apache.turbine.services.security.torque.om.BaseTurbineUserPee >r"> ... > <column name="LOCALEID" type="INTEGER" > javaName="LocaleId"/> ... > > * I've ran maven torque:create-db, torque:sql then torque:insert-sql > * maven turbine:deploy > > but I got 'incompatible return type' errors from generated BaseUser.java > and BaseUserPeer.java: found : com.bobo.om.User - required: > org.apache.turbine.services.security.torque.om.TurbineUser or found : > com.bobo.om.UserPeer - required: > org.apache.turbine.services.security.torque.om.TurbineUserPeer > > So I've try to change my new generated User.java and UserPeer to extend > them to TurbineUser/TorqueUser and TurbineUserPeer [as specified from > documentation 'torque-security-service.html'(?)] > > I did not change TR.properties yet because I got lots of incompatible type > errors ... very very tricky.... > > > you can specify the base class for Torque to use for any table in your > > schema. Same for peer base classes. Have a look at > > http://db.apache.org/torque/releases/torque-3.2/generator/schema-referenc > >e.html for details. > > Helge, it seems that even by setting > > baseClass="org.apache.turbine.services.security.torque.om.BaseTurbineUser" > basePeer="org.apache.turbine.services.security.torque.om.BaseTurbineUserPee >r"> Torque generator still generate the same classe that extends > 'BaseExtendedUser'.... > > > According to the portion of code provided, how the system knows > > that we should use the EXTENDED_USER table in the db instead of > > TURBINE_USER table? the extended table is not TURBINE_USER but > > EXTENDED_USER table! > > so I choose not to extend turbine_user but create a table 'user_preference' > like in turbine > > >>>>>>> 2nd - I ve created a new table 'USER_PREFERENCE' like in scarab db. > >>>>>>> <<<<<<<< > > * I've added a new table > > <table name="USER_PREFERENCE" idMethod="none" ...> > <column name="USER_ID" .../> ... > <foreign-key foreignTable="TURBINE_USER"><reference local="USER_ID" > foreign="USER_ID"/></foreign-key> ... > > by running $maven torque:create-db , I got an error: > org.apache.torque.engine.EngineException: Attempt to set foreign key to > nonexistent table, TURBINE_USER > > * so like in project scarab, i've add the following in my > project-schema.xml > > <table name="TURBINE_USER" > baseClass="org.apache.turbine.services.security.torque.om.TurbineUser" > > basePeer="org.apache.turbine.services.security.torque.om.TurbineUserPeer> > <column name="USER_ID" primaryKey="true" required="true" type="INTEGER"/> > </table> > > * torque:create-db and torque:sql run well > > * but I got some errors by inserting sql (torque:insert-sql) > > [torque-sql-exec] [ERROR] Failed to execute:drop table if exists > TURBINE_USER [torque-sql-exec] [ERROR] java.sql.SQLException: null, > message from server: "Cannot delete or update a parent row: a foreign key > constraint fails" > > [torque-sql-exec] [ERROR] Failed to execute: CREATE TABLE TURBINE_USER ... > [torque-sql-exec] [ERROR] java.sql.SQLException: null, message from > server: "Table 'turbine_user' already exists" > > looks normal (???) because TURBINE_USER exists in turbine-schema.xml > > Here, I was supprise because I got the same errors that in the 1st method > > attempting to use incompatible return type > found : com.bobo.om.TurbineUser > required: org.apache.turbine.services.security.torque.om.TurbineUser > > > I understand that this is pretty hard to read, because it requires some > time to understand what I am trying to explain, but I will really > appraciate for any help! > > Regards, > Thomas > > > > -------------- ALICE HAUT DEBIT : TRIPLE PLAY A 29,95 EUR/MOIS > -------------- Découvrez vite ALICEBOX : avec le modem WIFI, profitez de > l'ADSL, de la TELEPHONIE et en exclusivité de la TELEVISION ! Bénéficiez > aussi de la hotline gratuite 24h/24 ! Soumis à conditions. Pour en profiter > cliquez ici http://abonnement.aliceadsl.fr > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > !EXCUBATOR:1,4467c5ad37021041338929! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
