How to: alfresco 3.2 with ORACLE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-13-2009 12:56 AM
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
- Labels:
-
Archive
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-13-2009 03:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-13-2009 03:51 AM
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 hereI 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 thisTomorrow I still will test with centos 5.2 and kerberos. And this weeks I will add the project in forge.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-13-2009 07:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-13-2009 07:42 AM
I looked your code and have found some distinctions with which alfresco refused to work while I have not changed.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-14-2009 01:34 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-14-2009 02:25 AM
In my opinion, writing dbscripts of each database and setting the corresponding mapping iBATIS could work with any database.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.
The dialects covered in org.alfresco.repo.domain.schema.SchemaBootstrap 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-14-2009 03:06 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-14-2009 03:40 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-14-2009 04:16 AM
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.xyes 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
