topic Oracle 12.2 & Alfresco Content Services 5.2.2 in Alfresco Forum

Oracle 12.2 & Alfresco Content Services 5.2.2

ivanovpavel1983 — Wed, 30 May 2018 06:38:58 GMT

Hello.When we are stopping the application with "./alfresco.sh stop" command, we have an error:The parameters is:db.driver=oracle.jdbc.OracleDriverdb.url=jdbcracle:thin:@//srv-alfdb01.isb:1521/ALFEKKAdb.pool.max=375db.pool.min=20db.pool.statements.max=300db.pool.validate.query=select 1 from dualJD

Re: Oracle 12.2 & Alfresco Content Services 5.2.2

afaust — Wed, 30 May 2018 10:59:44 GMT

The error during stopping of the Alfresco server is just an unlucky timing of an asynchronous thread trying to run a job when the DB connection has / is already (been) shut down.

As for Alfresco not starting up, it is hard to tell without any logs. One of my customer is running Alfresco 5.2.1 with Oracle 12.1 and jdbc7 driver JAR without any hiccups.

Re: Oracle 12.2 & Alfresco Content Services 5.2.2

cesarista — Wed, 30 May 2018 11:07:35 GMT

In fact Ojdbc7.jar is the "supported" driver for Oracle 12:

Supported Platforms | Alfresco Documentation

Regards.

--C.

Re: Oracle 12.2 & Alfresco Content Services 5.2.2

ivanovpavel1983 — Wed, 06 Jun 2018 10:35:55 GMT

When we try to use ojdbc7.jar, we have errors:

Re: Oracle 12.2 & Alfresco Content Services 5.2.2

afaust — Thu, 07 Jun 2018 09:54:37 GMT

That error likely does not have antyhing to do with the DB driver. This is an issue where apparently someone tried to persist objects in Tomcat sessions that cannot be stored. Alfresco itself does not try to store such data in the session, so there must be a 3rd-party extension / customisation at play...