on of the steps in my load test is to connect to the database and verify some email address
import groovy.sql.Sql
//update database to verify account
driver = Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
sql = Sql.newInstance("jdbc:sqlserver://servername;etc etc;")
sql.execute("UPDATE dbo.aspnet_Membership set IsApproved = 1 where UserId=(select UserId from dbo.aspnet_membership where LoweredEmail=${Email})");
I notice that when I run my testcase under load I see various TCP/IP errors. Is this because I am not closing connections and the OS is maxing out connection ? any suggestions ?
Ali