Enhanced JDBC Sampler for Apache JMeter

I’ve moved this post to the following page. **UPDATE**: The files here will only run in JRE 1.6. I will try to provide JRE 1.5-compatible files as soon as possible. Thanks to Daniel for pointing this out. Some time ago I posted a bug report for Apache JMeter benchmarking utility (you can find my other jmeter bug reports here) . The bug report contains an enhancement of the current JDBC Sampler to allow JMeter to invoke PreparedStatements and also to change the way Callable Statements are handled to avoid performance problems when using some JDBC drivers (mainly Sybase). Because I don't know if this bug report will ever be integrated in JMeter or when. I decided to release this "Enhanced JDBC Sampler" as a JMeter plugin. The **installation** is quite simple just unzip the EnhancedJdbcSampler.zip and put the `EnhancedJdbcSampler.jar` file in the `$JMETER_HOME/lib/ext` directory. Once you restart JMeter you should see a new option under Add -> Samplers called "Enhanced JDBC Request". It works just like the old JDBC Sampler (see docs on how to use JDBC sampler here and here). The difference with the conventional JDBC Sampler is that you now have more options under *Query type* and there are two new text boxes at the bottom of the page. In the first box, you write the param values, and in the second box you write the param types. See the image below for an example. In this example there are two parameters: the literal `1` and the variable `${A}`. (In this particular case the ${A} comes from a Counter). The type of both parameters is INT. Check the list of JDBC Types.

December 14, 2006

Better JMeter Graphs

I’ve moved this post to the following location **UPDATE**: The files here will only run in JRE 1.6. I will try to provide JRE 1.5-compatible files as soon as possible. Thanks to Daniel for pointing this out. If you are tired of the old "Graph Results" listener that JMeter provides Click on the above image or here to see an enlarged version Checkout this new JMeter plugin that provides a new Statistical Aggregate Report ...

December 12, 2006

Opensource java

Finally Sun has released Java under GPL2 license. Read more about it at Tor Norbye’s blog or at this digg entry. Some highlights: HotSpot VM and JavaC compiler will be opensourced under the OpenJDK project SE 7.0 to be OS’ed first, SE6 to follow License GPV2 a la GNU/Linux with a GNU/Classpath exception to allow linking to non-GPL code. GPLv2 chosen due to popularity, compatability and protection (non-public fork not legal) Possibility of eventual GPLv3 upgrade when the FSF releases it. Easier to distribute runtime as well as SDK with Linux etc. Commercial licence policies remain in place.

November 15, 2006

Apache JMeter bugs

I’ve been working with Apache JMeter 2.2 mainly for JDBC benchmarks and I found a couple of bugs.

October 29, 2006

Using GroovyMonkey to obtain all eclipse icons 2

I’ve been playing with GroovyMonkey that is more or less a patch to EclipseMonkey that allows to run other languages besides Javascript. With this Eclipse plugin you can run javascript, groovy, etc. scripts that interacts with the Eclipse API. To get an impression of what you can do with GroovyMonkey take a look to these posts (1, 2, 3, 4 ). Following those post you can make a script to download all eclipse icons from the eclipse repository. My first GroovyMonkey script generates a webpage with all eclipse icons (previously downloaded with the example scripts) to easily spot the icons. ...

September 25, 2006

Sapir-Whorf is not a Klingon - OReilly ONLamp Blog

Good article about why closures and continuations are not taken seriously by most Java programmers Sapir-Whorf is not a Klingon - OReilly ONLamp Blog

September 13, 2006

Sun has hired the two primary JRuby developers

read about it in this post

September 11, 2006

Welcome to Eclipse on Swing

Interesting project Welcome to Eclipse on Swing

August 29, 2006

Logback

I didn’t know that there is a replacement for log4j that backed up by the founder of log4j. Logback Main Site - Logback Site

August 25, 2006

Useful resources to Eclipse Plugin Development

If you are new to Eclipse Plugin Development like me, you must now that in the Eclipsepedia you can find very useful code snippets like How to write to the eclipse console view from a plugin. The best way to find information there is to use google query like site:wiki.eclipse.org console write

August 24, 2006