topic Error hibernate after creating 2 new tables in Alfresco Archive

Error hibernate after creating 2 new tables

mrey — Fri, 02 Oct 2009 09:24:45 GMT

Hi thereI have a problem after creating 2 new tables within alfresco database. I have configured alfresco to get access to the data stored in those tables, but after the confituration alfresco doesn´t startup. Somebody could help me? I followed the next steps.Create the databases in mysql:table name

Re: Error hibernate after creating 2 new tables

mrey — Mon, 05 Oct 2009 09:58:41 GMT

Nobody can help? I´m very newbie and I need help

Thank you so much

Re: Error hibernate after creating 2 new tables

janv — Mon, 05 Oct 2009 10:32:02 GMT

Caused by: java.lang.NoSuchMethodError: org.apache.commons.collections.SetUtils.orderedSet(Ljava/util/Set;)Ljava/util/Set;‍

A simple google search may help you … it looks as if you have an incompatible version of commons-collection.jar on your classpath ?

Regards,
Jan

Re: Error hibernate after creating 2 new tables

mrogers — Mon, 05 Oct 2009 17:10:01 GMT

And what you are trying to do (create your own tables in the alfresco schema) is almost certainly the wrong approach and should be avoided. If you are a newbie, you should start by learning about alfresco content modeling first.

There should be no need to touch the alfresco database, the only exception for this is reading the audit tables.

Re: Error hibernate after creating 2 new tables

mrey — Tue, 06 Oct 2009 08:46:04 GMT

Hi MRogers

Thanks a lot for the advice, I appreciate it and know what you mean :wink: . Let me explain you, we are trying to create a extension for Alfresco to configure an automatic process to manage paper invoices and integrate it with OpenBravo another OpenSource ERP system.
There is a time in our "system model" that we need to store the relationships between company VAT id's-company names- and Invoice number pattern, and this must be stored in two tables in a 1:n relationship as far as we see it. (Please if you know another way we will appreciate if you can share it with us).

Maybe the place where we created the two tables is the wrong one as you mention, after your post seems that the best thing to do would be creating a new external DB model and use our tables in there.

However related to the problem with the Commons-collections, we found that Alfresco 3.0 had the common-collections-3.1.jar included and this is causing us errors.
We have searched in google about this issue, and we found that people quickly fixed this issue by using the latest version "common-collections-3.2.1.jar".
We have tried to add this library to our extension in Eclipse, and then build the new alfresco.war, however when we lauch tomcat we still can see the old
common-collections-3.1.jar under "webapps/alfresco/WEB_INF/lib", and of course we still get the same error.

We have also tried to manually change the "common-collections-3.1.jar" by the "common-collections-3.2.1.jar" in "webapps/alfresco/WEB_INF/lib"…however that would not work either…. we still get the same error.

Any ideas that we can follow to solve this situation?

Thanks a lot

Re: Error hibernate after creating 2 new tables

mrey — Thu, 08 Oct 2009 08:21:49 GMT

Hi Jan, Rogers

Sorry to disturb you, could you please let me know how I can do to update the Common Collection jar file to version 3.2? I have readed in google that my problem should be gone with this update (please let me know if I am wrong). I have added this new jar version to my project in Eclipse and recompile the alfresco war but still it does not appear in the tomcat/webapps/alfresco directory and I still get the same error.

thanks a lot in advance