Deepak,

                Thank you for responding. Last night I did send a reply
back to your question but the mail system bounced it back due to some of
the text in the error. I’m going to try this again.



I have been using the following software and Drivers

   - JMeter 5.6.2
   - Java openjdk 17.0.7 2023-04-18 LTS.
   - AWS Athena JDBC driver AthenaJDBC42-2.0.34.1000.jar which I downloaded
   from here Connecting to Amazon Athena with JDBC - Amazon Athena
   <https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html>



Using 5.6.2 with driver AthenaJDBC42-2.0.34.1000.jar JMeter will not start
in GUI mode. I tried to start it via the CLI and I got the following error.
.

AsyncWaitStrategyFactoryConfig"'s signer information does not match signer
information of other classes in the same package



I am also running DBeaver which uses driver version
AthenaJDBC42-2.0.34.1000.jar and DBeaver is able to connect to Athena
without issue. So, I tried that driver jar with JMeter as well and I get
the same error as above.



I then started testing older versions of JMeter and I found when I got back
to JMeter 5.5 the error above didn’t happen and JMeter would start up.
However, when I tried to connect it would stop right away and I got another
Java error like.

at
com.simba.athena.amazonaws.auth.profile.internal.BasicProfileConfigFileLoader.getProfilesConfigFile(BasicProfileConfigFileLoader.java:71)
~[AthenaJDBC42-2.1.1.1001.jar:?]



I then tested JMeter 5.4.3. The UI would also launch and this time when I
started my test it didn’t die right away. But the JMeter log showed this
error.

Invalid type definition for type
com.simba.athena.amazonaws.services.athena.model.AmazonAthenaException:
Failed to call setAccess() on Method 'setCause' (of class
java.lang.Throwable`) due to java.lang.reflect.InaccessibleObjectException,
problem: Unable to make final void
java.lang.Throwable.setCause(java.lang.Throwable) accessible: module
java.base does not "opens java.lang" to unnamed module @747ddf94



Here is an example of my connection string. The user, password and bucket
below is not my actual user, password or bucket.

jdbc:awsathena://
athena.us-east-2.amazonaws.com:443/iceberg_tpcds_sf1000_01?user=KCABLAHBLAHBLAHBLAHW&password=WKBLAHBLAHBLAHBLAH4lXKtDkbjWblahBLAHblahLblah&s3_staging_dir=s3://athena-results-bucket-name-us-west-2/

-- 

*Kyle Payne*

Technical Director, Enablement



920.475.7014

kyle.pa...@starburstdata.com

<https://www.starburst.io/>



*From:* Deepak Goel <deic...@gmail.com>
*Sent:* Friday, November 17, 2023 12:17 AM
*To:* JMeter Users List <user@jmeter.apache.org>
*Subject:* Re: Using JMeter to connect to AWS Athena



What's the error? Can you please paste it here?




Deepak

"The greatness of a nation can be judged by the way its animals are treated
- Mahatma Gandhi"

+91 73500 12833
deic...@gmail.com

Facebook: https://www.facebook.com/deicool
LinkedIn: www.linkedin.com/in/deicool



"Plant a Tree, Go Green"



Make In India : http://www.makeinindia.com/home





On Fri, Nov 17, 2023 at 8:06 AM Kyle Payne <kyle.pa...@starburstdata.com>
wrote:

I’ve been using JMeter to connect to multiple data sources like Databricks,
Trino and Starburst and I’ve never had an issue. Tonight, I tried to
connect to AWS Athena. I’m getting an error from the JDBC driver from AWS
and I did open a support call with AWS. I’m reaching out to this list
server only to see if there are any other users who have connected JMeter
to Athena.

-- 

*Kyle Payne*

Technical Director, Enablement



920.475.7014

kyle.pa...@starburstdata.com

<https://www.starburst.io/>

Reply via email to