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

[vipul_kapadia]

Hi Gurus,

I have a problem in connectivity of oracle and Alfresco-Community-3.2r2,can anyone help me???

Error is….


when i use Oracledailect

Caused by: java.lang.UnsupportedOperationException: join type not supported by OracleJoinFragment (use Oracle9Dialect)
at org.hibernate.sql.OracleJoinFragment.addJoin(OracleJoinFragment.java:94)

When i use Oracle10gdailect/Oracle9gdailect

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialect': FactoryBean threw exception on object creation; nested exception is java.sql.SQLException: Unsupported feature

[mikeh]

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

We recommend MySQL for Alfresco Community.

Thanks,
Mike

[dnguyen]

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

[mikeh]

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

[sselvan]

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

[sselvan]

Vipul.kapadia,

use Oracle9Dialect, instead of Oracle9gDialect

atleast you won't get JoinFragment error.

thank you