该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
Jmeter版本4.0,数据库驱动包sqljdbc41.jar、sqljdbc42.jar,都放在了jmeter/lib里面
用Jmter链接数据库(sqlserver),按照要求配置的数据
运行过后,结果树中无响应,在黄色三角中有下面报错显示
2018-07-24 14:36:57,931 INFO o.a.j.e.StandardJMeterEngine: Running the test!
2018-07-24 14:36:57,931 INFO o.a.j.s.SampleEvent: List of sample_variables: []
2018-07-24 14:36:57,932 INFO o.a.j.t.TestPlan: added D:\Aldrich\Jmeter\apache-jmeter-4.0\lib\sqljdbc42.jar to classpath
2018-07-24 14:36:57,932 INFO o.a.j.t.TestPlan: added D:\Aldrich\Jmeter\apache-jmeter-4.0\lib\mysql-connector-java-5.1.28.jar to classpath
2018-07-24 14:36:57,933 INFO o.a.j.g.u.JMeterMenuBar: setRunning(true, *local*)
2018-07-24 14:36:58,007 INFO o.a.j.e.StandardJMeterEngine: Starting ThreadGroup: 1 : 线程组
2018-07-24 14:36:58,008 INFO o.a.j.e.StandardJMeterEngine: Starting 1 threads for group 线程组.
2018-07-24 14:36:58,008 INFO o.a.j.e.StandardJMeterEngine: Thread will continue on error
2018-07-24 14:36:58,008 INFO o.a.j.t.ThreadGroup: Starting thread group... number=1 threads=1 ramp-up=1 perThread=1000.0 delayedStart=false
2018-07-24 14:36:58,008 INFO o.a.j.t.ThreadGroup: Started thread group number 1
2018-07-24 14:36:58,008 INFO o.a.j.e.StandardJMeterEngine: All thread groups have been started
2018-07-24 14:36:58,011 INFO o.a.j.t.JMeterThread: Thread started: 线程组 1-1
2018-07-24 14:36:58,024 INFO o.a.j.t.JMeterThread: Thread finished: 线程组 1-1
2018-07-24 14:36:58,025 ERROR o.a.j.JMeter: Uncaught exception:
java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4098) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3160) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:43) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3123) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1981) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773) ~[sqljdbc41.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168) ~[sqljdbc41.jar:?]
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:260) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2337) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2323) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2056) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) ~[commons-dbcp2-2.2.0.jar:2.2.0]
at org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl.getConnection(DataSourceElement.java:326) ~[ApacheJMeter_jdbc.jar:4.0 r1823414]
at org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(DataSourceElement.java:191) ~[ApacheJMeter_jdbc.jar:4.0 r1823414]
at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:79) ~[ApacheJMeter_jdbc.jar:4.0 r1823414]
at org.apache.jmeter.threads.JMeterThread.executeSamplePackage(JMeterThread.java:490) ~[ApacheJMeter_core.jar:4.0 r1823414]
at org.apache.jmeter.threads.JMeterThread.processSampler(JMeterThread.java:416) ~[ApacheJMeter_core.jar:4.0 r1823414]
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:250) ~[ApacheJMeter_core.jar:4.0 r1823414]
at java.lang.Thread.run(Unknown Source) [?:?]
2018-07-24 14:36:58,028 INFO o.a.j.e.StandardJMeterEngine: Notifying test listeners of end of test
2018-07-24 14:36:58,028 INFO o.a.j.g.u.JMeterMenuBar: setRunning(false, *local*)