topic Re: error Oracle 10G connectivity with Alfresco-Community-3.2r2 in Alfresco Archive

error Oracle 10G connectivity with Alfresco-Community-3.2r2

vipul_kapadia — Wed, 17 Feb 2010 08:57:40 GMT

Hi Gurus,I have a problem in connectivity of oracle and Alfresco-Community-3.2r2,can anyone help me???Error is….when i use OracledailectCaused by: java.lang.UnsupportedOperationException: join type not supported by OracleJoinFragment (use Oracle9Dialect)at org.hibernate.sql.OracleJoinFragment.addJoi

Re: error Oracle 10G connectivity with Alfresco-Community-3.2r2

mikeh — Wed, 17 Feb 2010 09:48:52 GMT

Oracle databases aren't supported for the Community product, only Enterprise.

We recommend MySQL for Alfresco Community.

Thanks,
Mike

Re: error Oracle 10G connectivity with Alfresco-Community-3.2r2

dnguyen — Wed, 28 Apr 2010 16:31:44 GMT

Mike,

Wow..are you serious ? So we can't use Alfresco-Community-3.2r2 with Oracle ?
I am currently using Alfresco-Community 2.1 (Linux version) with Oracle 10g and I am thinking of upgrading to Community-3.2r2.

Thanks

Re: error Oracle 10G connectivity with Alfresco-Community-3.2r2

mikeh — Wed, 28 Apr 2010 19:51:01 GMT

Please read John Newton's blog post on the subject: http://newton.typepad.com/content/2009/03/building-a-stronger-open-source-product.html

There's obviously nothing stopping you migrating the MySQL or PostgreSQL scripts we supply to an Oracle dialect should you be committed to using Oracle with Alfresco.

Thanks,
Mike

Re: error Oracle 10G connectivity with Alfresco-Community-3.2r2

sselvan — Tue, 10 Aug 2010 10:31:10 GMT

I even get the same error in Alfresco Enterprise 3.3 sp1. Let me know, if anyone has a solution around it!

Re: error Oracle 10G connectivity with Alfresco-Community-3.2r2

sselvan — Tue, 10 Aug 2010 11:26:14 GMT

Vipul.kapadia,

use Oracle9Dialect, instead of Oracle9gDialect

atleast you won't get JoinFragment error.

thank you