1. Home
  2. Development
  3. RE: Setting Up Liferay 7.4 CE with MariaDB and Connector to External Oracle DB

RE: Setting Up Liferay 7.4 CE with MariaDB and Connector to External Oracle DB

Olaf Kock, modified 1 Year ago.
Setting Up Liferay 7.4 CE with MariaDB and Connector to External Oracle DB
New Member Post: 1 Join Date: 1/29/24 Recent Posts

Hi All,

We have been struggling for a couple weeks trying to set up Liferay 7.4 CE with a default connection into MariaDB and a secondary external connection into Oracle DB. We have exhausted our the resources provided to us and are in need of some direction. Some of the resources include:

We have gotten to the point where we have completed the context switching as we are using the tomcat context and server xmls to provide our connection strings. However, we are running into a wall when trying to connect as we get the following error: Cannot load JDBC driver class 'oracle.jdbc.OracleDriver' java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver cannot be found

The ojdbc8.jar file is located in the shielded-container-lib as well.

Please advise.

Version of Liferay: ​​​​​​​liferay-ce-portal-7.4.3.100-ga100

7.4
thumbnail
Olaf Kock, modified 1 Year ago.
RE: Setting Up Liferay 7.4 CE with MariaDB and Connector to External Oracle DB
Liferay Legend Posts: 6441 Join Date: 9/23/08 Recent Posts

To me, it would be infinitely more helpful if you mentioned what you specifically have done, and what the message was.

Right now, you're listing a lot of resources, that would take me a couple of hours to follow - and then I might do something differently than you and succeed, which would give neither of us some insight.

Ideally, please provide a (minimal) code example, that clarifies what you're trying to do - e.g. are you trying to connect ServiceBuilder to a secondary datasource? (likely: Won't work within CE, unless you specifically install custom Oracle Support)