topic Re: Add additional table in database? in Alfresco Archive

Add additional table in database?

nenad982 — Tue, 30 Sep 2014 13:40:20 GMT

Hi all,I am currently using Alfresco Enterprise 4.2.2 and I would like to create an extension for Admin Console page. For that I need few additional tables in database and I would like to add these tables (if these do not already exist) to database on application start-up (after my custom repository

Re: Add additional table in database?

mrogers — Tue, 30 Sep 2014 13:54:31 GMT

Yes its possible. However discouraged since it shouldn't be needed.

The patch should be O.K. So I'd presume you have a problem with your schema numbers. You may like to put your "fixesToSchema" to a high number such as 100000.

Re: Add additional table in database?

nenad982 — Tue, 30 Sep 2014 15:07:16 GMT

Hi mrogers,

I would try this change.

Why you won't suggest including this sql script in the amp?

I can run it manually before starup but I would like to avoid that additional step. Please let me know if I missed something with this idea.

Thanks,
Nenad

Re: Add additional table in database?

mrogers — Tue, 30 Sep 2014 16:04:27 GMT

Yes you can put it into an amp.

Re: Add additional table in database?

nenad982 — Wed, 01 Oct 2014 08:23:10 GMT

Hi mrogers,

But is it possible to create this customization more general so it not to be dependent of schema build number?

Also when I increase the number it complains like this:


17:37:23,022 ERROR [org.springframework.web.context.ContextLoader] [localhost-startStop-1] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'patch.db-V4.2-add-new-table' defined in class path resource [alfresco/module/repoAmp/context/service-context.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'targetSchema' threw exception; nested exception is java.lang.IllegalArgumentException: 'targetSchema' must be greater than 'fixesToSchema'
‍‍‍‍‍

And when I increase targetSchema also I don't see anything in the logs and table is not created.

Do you see maybe where I made mistake?

Thanks

Re: Add additional table in database?

mrogers — Wed, 01 Oct 2014 11:23:00 GMT

This patch is an example that fires regardless of version.

   <bean id="patch.wcmFolders" class="org.alfresco.repo.admin.patch.impl.WCMFoldersPatch" parent="basePatch" >
        <property name="id"><value>patch.wcmFolders</value></property>
        <property name="description"><value>patch.wcmFolders.description</value></property>
        <property name="fixesFromSchema"><value>0</value></property>
        <property name="fixesToSchema"><value>${version.schema}</value></property>
        <property name="targetSchema"><value>10000</value></property>
        <!– helper beans for execution –>
        <property name="messageSource">
            <ref bean="bootstrapSpacesMessageSource" />
        </property>
        <property name="importerBootstrap">
            <ref bean="spacesBootstrap" />
        </property>
    </bean>