[BUG] jdbc connection - Githubissues

microsoft / azure-load-testing

MIT License

22 stars 3 forks source link

[BUG] jdbc connection #5

Closed szymonlngr closed 1 year ago

szymonlngr commented 2 years ago

Describe the bug Trying to call sql queries in SQL DB on VM (whitelisted IPs) but cannot

Error ,java.sql.SQLException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver',172.18.59.5

Expected behavior on Desktop jmeter it works fine

Additional context Do workers have jdbc driver? or there should be different syntax to connect to DB?

AB#1640622

johnsta commented 2 years ago

Hi @szymonlngr, thank you for raising this scenario. The product team is looking at this issue and will respond with more information soon.

kaumishra commented 2 years ago

Hi @szymonlngr we currently do not support this scenario. However this is on our roadmap. I will update with a comment here once I have a timeline for it.

Sachid26 commented 1 year ago

@szymonlngr . we currently support the scenario. You would need to upload your dependency JDBC JAR along with the JMeter script. Closing this for now, Please feel free to open the issue in case the issue persists.

mcapped commented 1 year ago

@Sachid26 I followed what you had suggested in uploading the JAR, but I'm getting the same error as the original poster. It works as expected in JMeter on my pc. Error: java.sql.SQLException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'

Sachid26 commented 1 year ago

@mcapped... have you configured the JDBC configuration into your JMeter test plan to connect to the sql server instance assuming you are connecting to sql server?