nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

Find more posts tagged with

Comments

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

paulweb

Yes, project is registered.

http://forge.alfresco.com/projects/oracle/
Today I will upload mine amp.

achied

Good news.

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