Cannot Connect To MySQL Database In OAG 11.1.2.2.0 Gateway, Analytics, Or Policy Studio
(Doc ID 1626880.1)
Last updated on APRIL 10, 2024
Applies to:
Oracle API Gateway - Version 11.1.2.1.0 and laterInformation 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:<PORT>/<DATABASE> --dbuser=<ROOT> --dbpass=<PASSWORD>
[...]
** Database Error: org.gjt.mm.mysql.Driver <---- problem here.
[...]
** 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 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)
...
Changes
This problem does not occur in OAG 11.1.2.1.0.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |