How to: alfresco 3.2 with ORACLE

[paulweb]

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 configuration:
OS: xp sp2
Database: oracle 10g
Alfresco: alfresco-comminity-3.2 with following modules recordsmanagment ,reporting  Vardar ,auditsurf ,wikispace for web-client, formatting.
About modules look this post http://forums.alfresco.com/en/viewtopic.php?f=33&t=22274

P.S: I have made today, therefore still it is necessary to test.

Community support oracle

[norgan]

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.

[paulweb]

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.

[achied]

Contribution for Oracle Configuration

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

[paulweb]

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.

[achied]

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.

[paulweb]

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

[paulweb]

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

[achied]

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

[paulweb]

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