title: How to set jdbc connection configuration via system variables in Jmeter
body: <p>We have common testing machine due to the security reasons  one tester should not see the other tester's jdbc configuration details in the sampler as there is a chance to misuse username and password and other details.</p>
  
  <p><strong>1.Is there any way to set system variables for different jdbc connection configurations for multiple databases such as MySQL,DB2 and Microsoft SQL. Ex : Application X uses  Microsoft SQL  where as application Y uses DB2 and application  Z uses MySQL . Y and Z are integration layers.</strong>
  Variables for Database URL, JDBC Driver class,Username,Password.Please provide the example.</p>
  
  <p><strong>2.Tester need to run the #1 via command line before test starts how to do that?what are the command lines?</strong>.Please provide the example.</p>
  
  <p><strong>3.In JDBC request instead of hard coding the sql scripts how to send the SQL scripts path which may contain bunch of SQL scripts or single SQL script.</strong> .Please provide the example.</p>
  
  <p>I have tried the below as showed in the screenshots, but always return results  for the only  sql query  only, but when looked at the sampler request i see all the queries sent,but response is only for the 1st query.</p>
  
  <p><a href="https://i.stack.imgur.com/4N9nJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4N9nJ.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/1pZ0U.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1pZ0U.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/3iDoU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3iDoU.png" alt="enter image description here"></a></p>
  
  <p><strong>4.For Distributed testing any special care required for the above.</strong>.Please provide the example.</p>
  
  <p>How can I achieve #1 ,#2 ,#3 and # 4.</p>
  
  <p><a href="https://i.stack.imgur.com/ntI03.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ntI03.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/9bkhU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9bkhU.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/btubz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/btubz.png" alt="enter image description here"></a>
  <a href="https://i.stack.imgur.com/JFM3c.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JFM3c.png" alt="enter image description here"></a></p>
  
  <p><strong>Below are the Latest Screenshots</strong>
  For #1 and # 2 below are the screenshots
  <a href="https://i.stack.imgur.com/7TQDK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7TQDK.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/AIgtj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AIgtj.png" alt="enter image description here"></a></p>
  
  <p>For  #3 below are the screenshots</p>
  
  <p><a href="https://i.stack.imgur.com/HpAfP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HpAfP.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/0ubAI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0ubAI.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/Bjkeq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Bjkeq.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/JLqRs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JLqRs.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/CB0wk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CB0wk.png" alt="enter image description here"></a></p>
  
  <p>Thanks,
  Raj</p>