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.