0

I'm a problem in JDBC Connection Configuration. When i execute my test (only JDBC Request - insert), doesn't appear any results in report (View Results Tree).

The connection is SQL Server. See below the configuration:

  • database URL: jdbc:sqlserver://${myURL}
  • JDBC driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
  • Username: ${user}
  • Password: ${password}

Could someone help me?

Thanks!!!

jarlh
  • 42,561
  • 8
  • 45
  • 63
Estevao FPM
  • 113
  • 1
  • 9

1 Answers1

1

  1. Make sure to add Microsoft JDBC Driver for SQL Server to JMeter Classpath and restart JMeter to pick up the .jar

  2. Check jmeter.log file for any suspicious entries

  3. Be informed that JDBC Connection Configuration is a Configuration Element hence it's being executed before anything else so your variables like ${myURL}, ${user} and ${password} might not have their respective values yet

  4. Check that your query returns results in mssql-cli

  5. Set the validation query to select 1 if it's different:

    enter image description here

You can check out The Real Secret to Building a Database Test Plan With JMeter article for more comprehensive steps if needed.

Dmitri T
  • 159,985
  • 5
  • 83
  • 133