topplethepat
topplethepat

Reputation: 531

UnsupportedClassVersionError with mysql jdbc driver in AWS Data Pipeline

I am trying to run a Data Pipeline job in AWS. I added the field "Jdbc Driver Jar Uri" and placed the jar file in my s3 bucket, per instructions here, because it seems "Connector/J" that is installed by AWS Data Pipeline does not work.

I'm using mysql-connector-java-8.0.23 and my mysql database version is the same.

java.lang.UnsupportedClassVersionError: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0 
  at java.lang.ClassLoader.defineClass1(Native Method) 
  at java.lang.ClassLoader.defineClass(ClassLoader.java:808) 
  at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) 
  at java.net.URLClassLoader.defineClass(URLClassLoader.java:443) 
  at java.net.URLClassLoader.access$100(URLClassLoader.java:65) 
  at java.net.URLClassLoader$1.run(URLClassLoader.java:355) 
  at java.net.URLClassLoader$1.run(URLClassLoader.java:349) 
  at java.security.AccessController.doPrivileged(Native Method) 
  at java.net.URLClassLoader.findClass(URLClassLoader.java:348) 
  at java.lang.ClassLoader.loadClass(ClassLoader.java:430) 
  at java.lang.ClassLoader.loadClass(ClassLoader.java:363) 
  at java.lang.Class.forName0(Native Method) 
  at java.lang.Class.forName(Class.java:278) 
  at amazonaws.datapipeline.database.JdbcDriverInitializer.getDriver(JdbcDriverInitializer.java:75) 
  at amazonaws.datapipeline.database.ConnectionFactory.getRdsDatabaseConnection(ConnectionFactory.java:158) 
  at amazonaws.datapipeline.database.ConnectionFactory.getConnection(ConnectionFactory.java:74) 
  at amazonaws.datapipeline.database.ConnectionFactory.getConnectionWithCredentials(ConnectionFactory.java:302) 
  at amazonaws.datapipeline.connector.SqlDataNode.createConnection(SqlDataNode.java:100) 
  at amazonaws.datapipeline.connector.SqlDataNode.getConnection(SqlDataNode.java:94) 
  at amazonaws.datapipeline.connector.SqlDataNode.prepareStatement(SqlDataNode.java:162) 
  at amazonaws.datapipeline.connector.SqlInputConnector.open(SqlInputConnector.java:49) 
  at amazonaws.datapipeline.connector.SqlInputConnector.<init>(SqlInputConnector.java:26) 
  at amazonaws.datapipeline.connector.SqlDataNode.getInputConnector(SqlDataNode.java:79) 
  at amazonaws.datapipeline.activity.copy.SingleThreadedCopyActivity.processAll(SingleThreadedCopyActivity.java:47) 
  at amazonaws.datapipeline.activity.copy.SingleThreadedCopyActivity.runActivity(SingleThreadedCopyActivity.java:35) 
  at amazonaws.datapipeline.activity.CopyActivity.runActivity(CopyActivity.java:22) 
  at amazonaws.datapipeline.objects.AbstractActivity.run(AbstractActivity.java:16) 
  at amazonaws.datapipeline.taskrunner.TaskPoller.executeRemoteRunner(TaskPoller.java:136) 
  at amazonaws.datapipeline.taskrunner.TaskPoller.executeTask(TaskPoller.java:105) 
  at amazonaws.datapipeline.taskrunner.TaskPoller$1.run(TaskPoller.java:81) 
  at private.com.amazonaws.services.datapipeline.poller.PollWorker.executeWork(PollWorker.java:76) 
  at private.com.amazonaws.services.datapipeline.poller.PollWorker.run(PollWorker.java:53) 
  at java.lang.Thread.run(Thread.java:748)

I've looked at this question for a solution, but I wasn't able to figure out how to adapt those answers to solving it in AWS Data Pipeline.

Can someone explain what steps need to be taken to fix this ClassVersion error?

Upvotes: 0

Views: 239

Answers (0)

Related Questions