Database connection error after the upgrade

Openfire Openfire Support
1

@wroot @akrherz,

We are having same issue, we have upgraded from 4.2.2 to 4.2.3

DB - Oracle
Error -
java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised

Regards

2

Are you sure it was update to 4.2.3? Maybe 4.3.2?

3

sorry it is 4.3.2 @wroot

4

Hi @wroot
issue resolved.
oracle jdbc jar file was not there in lib folder after upgrade.
we copied ojdbc jar file(from backup) to lib folder then it was working fine.

Please raise this as bug. Thank you for usual support.

Regards

5

I don’t see such file in the default 4.2.3 installation. Maybe you added it manually at some point? What is the exact name of that library file?

6

@wroot,
My mistake, that jar was added manually, it is for oracle db connector .

Thank you

7

I have filed https://issues.igniterealtime.org/browse/OF-1757 to investigate this. But i suspect you are using Oracle DB version not supported by included connectors. Especially if you had to also add it manually for older 4.2.3 version.

What is your Oracle DB version?

8

version - Oracle 12c

9

Oracle drivers cannot be included and have to be downloaded manually. Gdt will update the documentation https://github.com/igniterealtime/Openfire/pull/1360/files