Oracle 12.2 & Alfresco Content Services 5.2.2

cancel
Showing results for 
Search instead for 
Did you mean: 
ivanovpavel1983
Active Member

Oracle 12.2 & Alfresco Content Services 5.2.2

Hello.

When we are stopping the application with "./alfresco.sh stop" command, we have an error:

The parameters is:

db.driver=oracle.jdbc.OracleDriver
db.url=jdbcSmiley Surprisedracle:thin:@//srv-alfdb01.isb:1521/ALFEKKA
db.pool.max=375
db.pool.min=20
db.pool.statements.max=300
db.pool.validate.query=select 1 from dual

JDBC Driver is : ojdbc8.jar

JAVA Oracle 1.8 Update 161

DB Oracle + DATABASE RELEASE UPDATE 12.2.0.1.180116

With the jdcb7 driver, the application does not start at all...

 

4 Replies
afaust
Master

Re: Oracle 12.2 & Alfresco Content Services 5.2.2

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.

cesarista
Customer

Re: Oracle 12.2 & Alfresco Content Services 5.2.2

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

Supported Platforms | Alfresco Documentation 

Regards.

--C.

ivanovpavel1983
Active Member

Re: Oracle 12.2 & Alfresco Content Services 5.2.2

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

afaust
Master

Re: Oracle 12.2 & Alfresco Content Services 5.2.2

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...