how to add non osgi jar in global

Message Boards

Scarletake Bwi, modified 2 Years ago.

how to add non osgi jar in global

Expert Posts: 326 Join Date: 12/20/10 Recent Posts

i try use ojdbc8.jar in my module, and i know it's non-osgi

so i download the jar and put it in <TOMCAT>\lib\ext

and check module.framework.system.packages.extra from portal.properties, in liferay ce 7.4.2 ga3, oracle.jdbc is already in the list

module.framework.system.packages.extra=\
com.ibm.crypto.provider,\
com.ibm.db2.jcc,\
com.microsoft.sqlserver.jdbc,\
com.mysql.cj.jdbc,\
com.mysql.jdbc,\
com.p6spy.engine.spy,\
com.sun.security.auth.module,\
com.sybase.jdbc4.jdbc,\
oracle.jdbc,\ <===========here
org.postgresql,\
org.hsqldb.jdbc,\
org.mariadb.jdbc,\
sun.misc,\
sun.net.util,\
sun.security.provider,\
\
#
# WebSocket Support
#
\
com.ibm.websphere.wsoc,\
io.undertow.websockets.jsr,\
javax.websocket,\
javax.websocket.server,\
org.apache.tomcat.websocket.server,\
weblogic.websocket.tyrus

and i modify my build.gradle

dependencies {
compileOnly group: "com.liferay.portal", name: "release.portal.api"
compileOnly group: 'com.oracle.database.jdbc', name: 'ojdbc8', version: '21.3.0.0'
}

but it still get ClassNotFoundException, the message shows :oracle.jdbc.OracleDriver cannot be found by com.test.ci.plm_1.0.0"

can anyone help?

Fernando Paz, modified 2 Years ago.

RE: how to add non osgi jar in global

New Member Posts: 11 Join Date: 9/16/16 Recent Posts

Hi AFAIK you need make a OSGI module for suport it. Check this HOW TO url https://github.com/amusarra/liferay-portal-database-all-in-one-support. Hope it helps!!

Scarletake Bwi, modified 2 Years ago.

RE: RE: how to add non osgi jar in global

Expert Posts: 326 Join Date: 12/20/10 Recent Posts

hi Fernando

thank you for reply.

i will try it, but it looks likw for liferay ce to use oracle/sql server as main database, but i just want to connect external database to query some data.

anyway, i will feedbake the result doday, again, thank you.