topic Re: How to: alfresco 3.2 with ORACLE in Alfresco Archive

How to: alfresco 3.2 with ORACLE

paulweb — Tue, 13 Oct 2009 04:56:24 GMT

I have done alfresco 3.2 with oracle database. I can write article about it or load on forge alfresco-oracle-3.2.amp. Write that better.My test configurationS: xp sp2 Database: oracle 10gAlfresco: alfresco-comminity-3.2 with following modules recordsmanagment ,reporting Vardar ,auditsurf ,wikisp

Re: How to: alfresco 3.2 with ORACLE

norgan — Tue, 13 Oct 2009 07:11:57 GMT

Best approach is to add a WIKI article, editing your information there and link from here. If you need to develope software or somehting, add a alfresco-forge project with this. And maybe talk with Alfresco about it, since they do support Oracle for the Enterprise Version already.

Re: How to: alfresco 3.2 with ORACLE

paulweb — Tue, 13 Oct 2009 07:51:18 GMT

And maybe talk with Alfresco about it, since they do support Oracle for the Enterprise Version already.

read this http://forums.alfresco.com/en/viewtopic.php?f=8&t=21938 and especially read MikeH's posts

Best approach is to add a WIKI article, editing your information there and link from here

I will write article how to force to work alfesco with any database on an example with oracle.

If you need to develope software or somehting, add a alfresco-forge project with this

Tomorrow I still will test with centos 5.2 and kerberos. And this weeks I will add the project in forge.

Re: How to: alfresco 3.2 with ORACLE

achied — Tue, 13 Oct 2009 11:04:40 GMT

Contribution for Oracle Configuration

https://issues.alfresco.com/jira/browse/ALFCOM-3454

Re: How to: alfresco 3.2 with ORACLE

paulweb — Tue, 13 Oct 2009 11:42:54 GMT

It is just necessary to set an example, that alfresco it is possible to force to work with any database. The main desire in this business.

I looked your code and have found some distinctions with which alfresco refused to work while I have not changed.

Re: How to: alfresco 3.2 with ORACLE

achied — Wed, 14 Oct 2009 05:34:02 GMT

What differences do you mean?

In my opinion, writing dbscripts of each database and setting the corresponding mapping iBATIS could work with any database.
The dialects covered in org.alfresco.repo.domain.schema.SchemaBootstrap are likely to be used.

Re: How to: alfresco 3.2 with ORACLE

paulweb — Wed, 14 Oct 2009 06:25:12 GMT

In my opinion, writing dbscripts of each database and setting the corresponding mapping iBATIS could work with any database.
The dialects covered in org.alfresco.repo.domain.schema.SchemaBootstrap are likely to be used.

You are right. But only not which users are lazy it to make or do not know as.The dialects covered in org.hibernate.dialect are likely to be used.

What differences do you mean?

my version alfresco 3.2 latest version.
1)add new files:
audit-insert-SqlMap.xml
propval-insert-SqlMap.xml
and others
2) in your file activities-insert-SqlMap.xml you set insert.activity.feedcontrol. it is error, correct insert_activity_feedcontrol
3) in dbscripts\create you add one folder 3.2, but need following files
AlfrescoPostCreate-2.2-MappedFKIndexes.sql
AlfrescoPostCreate-2.2-Extra.sql
post-create-indexes-04.sql
create-activities-extras.sql
AlfrescoPostCreate-3.2-LockTables.sql
AlfrescoPostCreate-3.2-ContentTables.sql
AlfrescoPostCreate-3.2-PropertyValueTables.sql
AlfrescoPostCreate-3.2-AuditTables.sql

Re: How to: alfresco 3.2 with ORACLE

paulweb — Wed, 14 Oct 2009 07:06:27 GMT

Here the list of databases
MySQLInnoDBDialect - ok
HSQLDialect -no
DerbyDialect -no (At the revision 16892 Derby dialect are deleted)
AlfrescoOracle9Dialect -ok
AlfrescoSQLServerDialect-no
AlfrescoSybaseAnywhereDialect-no
DB2Dialect-ok
PostgreSQLDialect-ok

ok - is available in community
no - is not present in community

Re: How to: alfresco 3.2 with ORACLE

achied — Wed, 14 Oct 2009 07:40:36 GMT

At the revision 16892 Derby dialect are deleted

Missing files in Oracle Dialect (as your comment):
- AlfrescoPostCreate-3.2-AuditTables.sql
- AlfrescoPostCreate-3.2-AvmTables.sql
- AlfrescoPostCreate-3.2-PropertyValueTables.sql

I will do

Missing files from alfresco-SqlMapConfig.xml (as your comment):
- propval-insert-SqlMap.xml
- audit-insert-SqlMap.xml
- avm-insert-SqlMap.xml

I will do

Ok, I need to fix activities-insert-SqlMap.xml you to set insert_activity_feedcontrol.

About

AlfrescoPostCreate-2.2-MappedFKIndexes.sql
AlfrescoPostCreate-2.2-Extra.sql
post-create-indexes-04.sql
create-activities-extras.sql

are to prior 3.2 version.

Maybe we should create the upgrade script from 2.x to 3.x

Re: How to: alfresco 3.2 with ORACLE

paulweb — Wed, 14 Oct 2009 08:16:08 GMT

I have sent in alfrescoforge inquiry about project registration on support oracle database.
If will register that I will upload my worker amp if is not present then on own site or through jirra

Maybe we should create the upgrade script from 2.x to 3.x

yes it is. When there is a first installation alfresco starts these scripts.

P.S: But it seems to me that the project will not register as oracle and mssql this advantage enterprise version alfresco.
Then what for in alfresco to use orm hibernate if they limit use of databases.
And if will register then achied join it

Re: How to: alfresco 3.2 with ORACLE

paulweb — Thu, 15 Oct 2009 03:06:55 GMT

Yes, project is registered. http://forge.alfresco.com/projects/oracle/
Today I will upload mine amp.

Re: How to: alfresco 3.2 with ORACLE

achied — Thu, 15 Oct 2009 09:38:56 GMT

Good news.

I would like to contribute with dbscripts and ibatis configurations for Oracle.