Glue can't make a connection from AWS GLUE Notebook to AS400 db

Viewed 18

I tryed to make a connection to IBM AS400 database:

df = (
    spark
    .read 
    .format("jdbc") 
    .option("url", "jdbc:as400://aabb1100.db.site.com/db") 
    .option("dbtable", "db") 
    .option("user", "user1") 
    .option("password", "password1")
    .option("driver", "com.ibm.as400.access.AS400JDBCDriver")
).load()

But it returns:

Py4JJavaError: An error occurred while calling o251.load.
: java.lang.ClassNotFoundException: com.ibm.as400.access.AS400JDBCDriver 

I download this driver to the S3 basket but can't understand how to connect spark with it.

0 Answers
Related