search

amusarra / liferay-portal-database-all-in-one-support

This is the driver implementation to add support for Oracle, SQL Server and DB2 database for Liferay 7, 7.1, 7.2, 7.3 and 7.4 CE
http://bit.ly/2IQ6X4n
GNU Lesser General Public License v2.1
5 stars 7 forks source link

how to add ojdbc8(oracle database driver) in liferay #7

Closed ScarleTAKE closed 3 years ago

ScarleTAKE commented 3 years ago

hi i'd like to know, how to add ojdbc8 in liferay, i download the jar manually and put it in tomcat/lib/ext, and modify build.gradle of module: compileOnly group: 'com.oracle.database.jdbc', name: 'ojdbc8', version: '21.3.0.0' it's doesn't work.

my environment is OS: Windows JVM: oracle jdk8 Liferay: Liferay CE 7.4.2 ga3 Database: MySQL 5.7

amusarra commented 3 years ago

Hi @ScarleTAKE The current version (1.2.1) of the oracle driver has not been tested with Liferay version 7.4. However, there is no need to specify the Oracle JDBC driver as a dependency, it just needs to be installed on tomcat / lib / ext. Also remember to install the driver (liferay-portal-database-all-in-one-support) in the correct location.

I reiterate the fact that this version of Liferay is currently not supported, so it is possible that the driver will not work.

amusarra commented 3 years ago

Hi @ScarleTAKE Read well the README of the project, where I indicated the notes for a correct installation of the driver for Liferay 7.4 GA3.

ScarleTAKE commented 3 years ago

Hi @amusarra

thank you, thank you very much for all your assistance and I really appreciate your help in resolving this issue. I was suspected the folder tomcat-9.0.43/webapps/ROOT/WEB-INF/shielded-container-lib because mysql.jar is placed here. but it's still doesn't work. I create a thread in liferay div: question-about-add-external-ojdbc-jar using a simple mvc-module and try use very simple jdbc code to access database. although it still shows "ClassNotFoundException:oracle.jdbc.OracleDriver", but when i use "import oracle.jdbc.*; " in my java code, it shows normal.

amusarra commented 3 years ago

Well, then close this issue.