Hello,
I am trying to use Jmeter to stress test an SQL database.
As I searched a little bit to set it up, it could be useful to add to
the bottom of the manual page
http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html how
to connect to a SQL server database.
I am using MS JDBC driver:
Driver class com.microsoft.sqlserver.jdbc.SQLServerDriver
for Database URL: jdbc:sqlserver://host:port;DatabaseName=dbname
I also wanted to use NULL values for parameters but could not find a way
to do so. Looking at the code it does not seem possible, do you agree?
Also, it took me some time to identify a typo in the JDBC type, and it
may be usefull to add some code to capture nullpointerexception when
calling getJdbcType, something like:
try {
int targetSqlType = getJdbcType(argumentType);
pstmt.setObject(i+1, argument, targetSqlType);
} catch (NullPointerException e}
log.warn("Invalid Type " + argumentType, e);
throw e;
}
I did not get yet the environment to compile Jmeter, so could not
validate the code, but this would provide a warning showing the exact
entry that is failing.
Lastly I could not find a way to use OUT parameters when using callable
statement, is there any way?
Stephane
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
