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.

Alfresco 3.2 & Oracle DB

uzbekjon

Has anyone managed to install/configure Alfresco 3.2 with Orable database?

I have tried putting alfresco-global.properties into the /extensions dir with correct properties, but gettin an exception.

Anyone has managed to configure Alfresco 3.2 to work with Oracle ?

Thanks,
Uzbekjon.

PS. I know that Enterprise version supports Oracle and MS SQL. I simply want to know if we can somehow configure Alfresco Community Edition to work with Oracle or the Alfresco team made a special effort …

Find more posts tagged with

Comments

kbonnet

As from version 3.2 your alfresco-global.properties needs to be in the tomcat/lib or tomcat/shared directory.

uzbekjon

As from version 3.2 your alfresco-global.properties needs to be in the tomcat/lib or tomcat/shared directory.

Yeap, I know that. But it's still not working !

kbonnet

Then i'm affraid you'll have to post the exception for the experts

mikeh

Community Edition v3.2 supports MySQL and PostgreSQL only.

Thanks,
Mike

pjanuario

I'm trying to use the 3.2 with oracle with no success too.
I'm have the 3.0Stable comunity version currently working with oracle, it's still possible to work with community 3.2 and oracle?
Is there any workaround?

dward

I'm afraid Oracle is only supported with the enterprise versions, which come with Oracle installation scripts and upgrade scripts from previous versions.

shoover

Is it possible to use some of the scripts from the enterprise version to configure the community version to run with oracle?
I've got the Enterprise trial version running with oracle but would like to evaluate the community version(on a seprate server) using oracle for a "side by side" comparison.
Thanks, Steve.

mrogers

No I don't think so. The Oracle scripts are Enterprise only.

atita

hi ,

I have been trying pretty much the same like configuring oracle 10g with Alfresco 3.2 enterprise edition (trial version).
I followed the steps & made modifications to the {ALFRESCO_HOME}\tomcat\shared\classes\alfresco-global.properties.
As :

db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=1521
#
# Oracle connection
#
oracle#db.driver=oracle.jdbc.OracleDriver
oracle#db.url=jdbc:oracle:thin:@${db.host}:${db.port}:${db.name}
hibernate.default_schema=ALFRESCO
‍‍‍‍‍‍‍‍‍‍‍‍‍

I also created a user alfresco identified by alfresco in my database as suggested.

Surprisingly , there's no problem in booting the servers up , also there's no problem in creating user spaces but when i try to upload some content the upload fails each time.
Through my log files i found this exception :

12:26:17,312 ERROR [org.alfresco.repo.activities.post.lookup.PostLookup] Exception during select of posts
com.mysql.jdbc.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
   at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
   at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
   at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
   at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
   at sun.reflect.GeneratedMethodAccessor353.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.util.AutoCommitInterceptor.invoke(AutoCommitInterceptor.java:41)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy67.getConnection(Unknown Source)
   at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
   at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy.getConnection(TransactionAwareDataSourceProxy.java:109)
   at com.ibatis.sqlmap.engine.transaction.external.ExternalTransaction.init(ExternalTransaction.java:53)
   at com.ibatis.sqlmap.engine.transaction.external.ExternalTransaction.getConnection(ExternalTransaction.java:90)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
   at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
   at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)
   at org.alfresco.repo.domain.activities.ibatis.ActivityPostDAOImpl.selectPosts(ActivityPostDAOImpl.java:49)
   at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:122)
   at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)
   … 32 more
Caused by: java.net.ConnectException: Connection refused: connect
   at java.net.PlainSocketImpl.socketConnect(Native Method)
   at java.net.PlainSocketImpl.doConnect(Unknown Source)
   at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
   at java.net.PlainSocketImpl.connect(Unknown Source)
   at java.net.SocksSocketImpl.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at java.net.Socket.<init>(Unknown Source)
   at java.net.Socket.<init>(Unknown Source)
   at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
   … 33 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I wonder if this can be worked out ?
Can anyone help or comment ?
would really appreciate. thanks !!!