topic Replacing ACT_ID_USER table in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/replacing-act-id-user-table/m-p/43399#M23649 <HTML><HEAD></HEAD><BODY><SPAN>I'd like to get a push to the right direction. What i'm trying to achieve is to customize activiti to use my own users table instead of the default ACT_ID_USER table. My question is around how far in customizing everything should I go?</SPAN><BR /><BR /><SPAN>I've been thinking to</SPAN><BR /><BR /><SPAN>1. replace mappings.xml (and initializing this from custom configuration class extending StandaloneProcessEngineConfiguration) to include my own SQL for User.xml entity, and pretty much keeping everything else as they are</SPAN><BR /><BR /><SPAN>2. replace mappings.xml to include my own entity called the Identity.xml for a new IdentityEntity class (implementing User and PersistentObject) and then extend UserManager with my own code that works with the IdentityEntity instances</SPAN><BR /><BR /><SPAN>3. replace mappings.xml to include my own entity together with my own IdentityEntity class but instead of extending UserManager I would create a new IdentityManager that extends AbstractManager (to get my own api more aligned with my DB table). This option means that I also need to extend IdentityServiceImpl and many of the commands to reflect the new IdentityManager class.</SPAN><BR /><BR /><SPAN>4. do one of the above, but not mess with mappings.xml and custom configuration class that initializes the sqlSessionFactory – dunno what would be a good alternative though</SPAN><BR /><BR /><SPAN>So which way should I go? Would option #3 even work? Any other suggestions?</SPAN><BR /><BR /><SPAN>I have searched the forums and modifying mappings.xml is not mentioned, only changing the UserManager. However, I see this as the only way to go if I want to reuse the DB session and use my own tables to do the queries.</SPAN></BODY></HTML> Tue, 09 Aug 2011 11:37:14 GMT wesley 2011-08-09T11:37:14Z Replacing ACT_ID_USER table https://connect.hyland.com/t5/alfresco-archive/replacing-act-id-user-table/m-p/43399#M23649 I'd like to get a push to the right direction. What i'm trying to achieve is to customize activiti to use my own users table instead of the default ACT_ID_USER table. My question is around how far in customizing everything should I go?I've been thinking to1. replace mappings.xml (and initializing th Tue, 09 Aug 2011 11:37:14 GMT https://connect.hyland.com/t5/alfresco-archive/replacing-act-id-user-table/m-p/43399#M23649 wesley 2011-08-09T11:37:14Z Re: Replacing ACT_ID_USER table https://connect.hyland.com/t5/alfresco-archive/replacing-act-id-user-table/m-p/43400#M23650 <HTML><HEAD></HEAD><BODY><SPAN>The best way to do it, is to write your own implementation of User/GroupManager, and inject them into the Activiti engine.</SPAN><BR /><SPAN>This way, you can simply delete the ACT_ID tables.</SPAN></BODY></HTML> Wed, 10 Aug 2011 12:53:26 GMT https://connect.hyland.com/t5/alfresco-archive/replacing-act-id-user-table/m-p/43400#M23650 jbarrez 2011-08-10T12:53:26Z Re: Replacing ACT_ID_USER table https://connect.hyland.com/t5/alfresco-archive/replacing-act-id-user-table/m-p/43401#M23651 <HTML><HEAD></HEAD><BODY><SPAN>So what you are suggesting is the #2 without modifications to mappings.xml. How can I then create the DB queries by reusing the ibatis sql session that Activiti uses to the same database in order to query my own tables? Or do I need to create another sql session for my own queries and use my own mappings.xml for my own entities? Or another solution altogether?</SPAN></BODY></HTML> Thu, 11 Aug 2011 07:10:30 GMT https://connect.hyland.com/t5/alfresco-archive/replacing-act-id-user-table/m-p/43401#M23651 wesley 2011-08-11T07:10:30Z Re: Replacing ACT_ID_USER table https://connect.hyland.com/t5/alfresco-archive/replacing-act-id-user-table/m-p/43402#M23652 <HTML><HEAD></HEAD><BODY><SPAN>If you plug in your own impl of the managers, you can do whatever you want: ibatis, jpa, plain jdbc. </SPAN><BR /><SPAN>Take what is the easiest for you <span class="lia-unicode-emoji" title=":winking_face:">😉</span></SPAN></BODY></HTML> Thu, 11 Aug 2011 09:50:02 GMT https://connect.hyland.com/t5/alfresco-archive/replacing-act-id-user-table/m-p/43402#M23652 jbarrez 2011-08-11T09:50:02Z