You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by The Earl <u1...@sneakemail.com> on 2006/06/06 19:16:15 UTC
JDBC MySQL and SNMP
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: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC MySQL and SNMP
Posted by The Earl <u1...@sneakemail.com>.
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 <u1...@sneakemail.com> 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: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC MySQL and SNMP
Posted by sebb <se...@gmail.com>.
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 <u1...@sneakemail.com> 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: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org