My Oracle Support Banner

MySql Connection Fails With 'java.lang.NoClassDefFoundError': Com/mysql/jdbc/jdbc2/optional/MysqlCon (Doc ID 2772543.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate Veridata - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

When creating a new MySQL database connection for Veridata Agent it fails with 

[2021-04-26T10:30:15.211-04:00] [veridata] [INCIDENT_ERROR] [OGGV-60013] [oracle.veridata.agent] [tid: 25] [ecid: 0000N^E_c605qY^5PV8Dyd1WXgtc000003,0] [arg: java.lang.NoClassDefFoundError] [arg: com/mysql/jdbc/jdbc2/optional/MysqlConnectionPoolDataSource] Unhandled exception 'java.lang.NoClassDefFoundError': com/mysql/jdbc/jdbc2/optional/MysqlConnectionPoolDataSource

[2021-04-26T10:30:15.211-04:00] [veridata] [INCIDENT_ERROR] [] [oracle.veridata.agent] [tid: 25] [ecid: 0000N^E_c605qY^5PV8Dyd1WXgtc000003,0] Exception stack trace[[
java.lang.NoClassDefFoundError: com/mysql/jdbc/jdbc2/optional/MysqlConnectionPoolDataSource
at com.goldengate.veridata.db.pool.VeridataMySQLConnectionPool.<init>(VeridataMySQLConnectionPool.java:19)
at com.goldengate.veridata.db.MySQLDatabase.createDataSource(MySQLDatabase.java:66)

 

Changes

agent.properties is set with

server.jdbcDriver=mysql-connector-java-commercial-8.0.14.jar

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.