topic Re: Alfresco CMS with myBatis in Alfresco Forum

Alfresco CMS with myBatis

aakanksha_tejwa — Wed, 18 Apr 2018 05:29:22 GMT

Hi,I have a simple question regarding the ORM used by Alfresco CMS. As I understand in the previous versions, Hibernate was used as the ORM layer which was later updated to iBatis. In our current project, we are using myBatis for the different database connections, hence we would like to maintain th

Re: Alfresco CMS with myBatis

afaust — Wed, 18 Apr 2018 08:06:30 GMT

Hibernate hasn't been used (as primary ORM) in a long time (since 4.0 only for jBPM, which was removed in 5.1/5.2). The Hibernate library continues to be used as a technical dependency, primarily to determine the database dialect to be used and for some transaction handling support. Alfresco is using myBatis (successor of ibatis) and of course you can use myBatis for custom database connections. You just have to use the version shipped with Alfresco and not include your own to avoid any conflicts.

Re: Alfresco CMS with myBatis

aakanksha_tejwa — Wed, 18 Apr 2018 08:40:07 GMT

Hi,

Thank you for your instant reply.

Actually I came across a document stating that Alfresco CMS uses iBatis - Alfresco drops LGPL'd Hibernate for iBatis - The H Open: News and Features , hence the confusion.

Could you please point me to the correct documentation to understand how can I use myBatis for my custom database connections while using Alfresco CMS?

Re: Alfresco CMS with myBatis

afaust — Wed, 18 Apr 2018 11:58:41 GMT

There is no such documentation because that is not considered a standard / supported use case by Alfresco. It simply is technically possible (and I have been doing that in various customer projects).

Re: Alfresco CMS with myBatis

aakanksha_tejwa — Thu, 19 Apr 2018 19:21:59 GMT

Would it be possible for you to may be share a sample code or direct me to a sample project for reference wherein I could use myBatis for my custom database connections while using Alfresco CMS?

Re: Alfresco CMS with myBatis

afaust — Thu, 19 Apr 2018 21:31:20 GMT

You'll find an example of custom ibatis handling in one of my addons - the Acosix alfresco-audit. In this addon, I am using ibatis for custom queries against the Alfresco database (modifying this example to use a different database is a trivial example). Among the various config files, take a look at the dao-context.xml and the ibatis mapping for different dialects. The only thing not covered in this would be transaction handling for a non-Alfresco database.