Ahh, I had set up a connection pool, but had not named it.
Thanks On 6/6/06, sebb sebbaz-at-......... |Listserv| <...> wrote:
Works for me. The way that you set up JDBC has changed; you need to create a pool using JDBC Config, and then use the pool in the JDBC Sampler. Make sure you use the same name for both. [The documentation on this has been improved in the current builds...] On 06/06/06, The Earl <[EMAIL PROTECTED]> wrote: > It appears that the 2.1.1 JDBC Sampler does not work with MySQL. I get > an SQL exception (below) with MySQL JDBC 3.1.8. > > This same Jar / config works with 2.0.3. > > Also, is there current SNMP support in JMeter? Where would I start if > I wanted to implement it? > > Thanks > > TE > > 2006/06/05 16:18:26 INFO - jmeter.engine.StandardJMeterEngine: > Running the test! > 2006/06/05 16:18:26 DEBUG - > jmeter.protocol.jdbc.config.DataSourceElement: MaxPool: 10 Timeout: > 10000 TrimInt: 60000 > 2006/06/05 16:18:26 DEBUG - > jmeter.protocol.jdbc.config.DataSourceElement: KeepAlive: true Age: > 5000 CheckQuery: Select 1 > 2006/06/05 16:18:26 DEBUG - > jmeter.protocol.jdbc.config.DataSourceElement: Driver: > com.mysql.jdbc.Driver DbUrl: jdbc:mysql://sign/mysql User: root > 2006/06/05 16:18:26 DEBUG - > jmeter.protocol.jdbc.config.DataSourceElement: Loading new driver: > com.mysql.jdbc.Driver > 2006/06/05 16:18:27 INFO - jmeter.gui.util.JMeterMenuBar: > setRunning(true,local) > 2006/06/05 16:18:27 INFO - jmeter.engine.StandardJMeterEngine: > Starting 1 threads for group JDBC Status. Ramp up = 1. > 2006/06/05 16:18:27 INFO - jmeter.engine.StandardJMeterEngine: > Continue on error > 2006/06/05 16:18:27 WARN - jmeter.threads.JMeterThread: > jmeterthread.startearlier=true (see jmeter.properties) > 2006/06/05 16:18:27 INFO - jmeter.threads.JMeterThread: Thread JDBC > Status 1-1 started > 2006/06/05 16:18:27 DEBUG - jmeter.protocol.jdbc.sampler.JDBCSampler: > sampling jdbc > 2006/06/05 16:18:27 DEBUG - jmeter.protocol.jdbc.sampler.JDBCSampler: > DataSourceComponent: null > 2006/06/05 16:18:27 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: > Error in JDBC sampling java.sql.SQLException: No pool created > at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:76) > at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:247) > at java.lang.Thread.run(Unknown Source) > > 2006/06/05 16:18:27 INFO - jmeter.threads.JMeterThread: Thread JDBC > Status 1-1 is done > 2006/06/05 16:18:27 INFO - jmeter.engine.StandardJMeterEngine: Ending thread 0 > 2006/06/05 16:18:27 INFO - jmeter.engine.StandardJMeterEngine: Stopping test > 2006/06/05 16:18:27 INFO - jmeter.engine.StandardJMeterEngine: > Notifying test listeners of end of test > 2006/06/05 16:18:27 INFO - jmeter.gui.util.JMeterMenuBar: > setRunning(false,local) > 2006/06/05 16:18:27 INFO - jmeter.engine.StandardJMeterEngine: Test has ended > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
