Using Simba JDBC Driver for Athena in ReadyAPI (SoapUI)

Hello,

Thank you for your response and extended patience with us.

I reproduce this issue in my testing environment with following steps:

• Downloaded Athena JDBC Driver "AthenaJDBC42-2.0.35.1000.jar " from this document.
• Installed ReadyAPI Application and try adding driver directly from the Download folder.
• It failed with same error message java.lang.IllegalArgumentException: Malformed \uxxxx encoding.

Analysing the above issue, it seem this issue occurs when you try to load the JDBC driver from the local Download folder. From my testing, I found that ReadyAPI uses the jar files from the bin/ext directory of your ReadyAPI installation. So, it is required to place jar file inside the bin/ext.

To mitigate this issue, I followed this document which has mentioned following steps:

1. Download and install the needed JDBC driver package.
2. Put the driver files in the bin/ext directory of your ReadyAPI installation.
3. Restart ReadyAPI to load the driver.
4. In ReadyAPI, go to  Preferences > JDBC Drivers and add the new connection template.

Note: My test environment was macos. So, I added Athena jar file in following location: /Applications/ReadyAPI-3.46.1.app/Contents/java/app/bin/ext . This might be different depending on your operating system.

Once the above steps(1-3) is completed. For step 4, I used following configuration

Driver Name: AwsAthena/com.simba.athena.jdbc.Driver
Connection String template: jdbc:awsathena://athena.amazon.com:443

Then, I open Database connection and specify the unique name for JDBC connection with following properties:

Please refer to the document for more information in Amazon Simba Athena JDBC Data Connector

I hope that the above information will help to answer your query.

Please let me know if you have any queries/concerns or would like to share any other information.

Have a great day and stay safe !!

Thank you for using Amazon Athena.