Cannot Connect To MySQL Database In OAG 11.1.2.2.0 Gateway, Analytics, Or Policy Studio

(Doc ID 1626880.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle API Gateway - Version 11.1.2 and later
Information in this document applies to any platform.

Symptoms

MySQL is used as a reporting database with Oracle API Gateway 11.1.2.2.0 or newer, and error messages are observed related to "org.gjt.mm.mysql.Driver".

Example error message when dbsetup is run to configure the database:

# ./dbsetup --dburl=jdbc:mysql://127.0.0.1:3306/reports  --dbuser=root --dbpass=mypassword
[...]
** Database Error: org.gjt.mm.mysql.Driver <---- problem here.


Example exception thrown by Policy Studio:

org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.vordel.common.db.DbConnection.<init>(DbConnection.java:236)
at com.vordel.client.manager.filter.db.DBConnectionDialog.testConnection(DBConnectionDialog.java:129)
at com.vordel.client.manager.filter.db.DBConnectionDialog.access$000(DBConnectionDialog.java:39)
at com.vordel.client.manager.filter.db.DBConnectionDialog$1.widgetSelected(DBConnectionDialog.java:106)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3910)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3503)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
at org.eclipse.jface.window.Window.open(Window.java:796)
at com.vordel.client.manager.actions.generic.EditEntityAction.runAction(EditEntityAction.java:25)
at com.vordel.client.manager.actions.ManagerEntityAction.run(ManagerEntityAction.java:34)
at com.vordel.client.gui.policystudio.editor.reusable.ReusableEditor$MasterDetailsPage$3.linkActivated(ReusableEditor.java:375)
at org.eclipse.ui.forms.widgets.AbstractHyperlink.handleActivate(AbstractHyperlink.java:228)
at org.eclipse.ui.forms.widgets.ImageHyperlink.handleActivate(ImageHyperlink.java:177)
at org.eclipse.ui.forms.widgets.AbstractHyperlink.handleMouseUp(AbstractHyperlink.java:316)
at org.eclipse.ui.forms.widgets.AbstractHyperlink.access$2(AbstractHyperlink.java:300)
at org.eclipse.ui.forms.widgets.AbstractHyperlink$4.handleEvent(AbstractHyperlink.java:119)

 

Changes

This problem does not occur in OAG 11.1.2.1.0.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms