It seems that no current JPA implementation is able to paginate the result using Apache Derby 10.5 OFFSET/FETCH mechanism. So javax.persistence.Query setFirstResult and setMaxResults don’t really translate into proper pagination with “OFFSET/FETCH” TopLink/EclipseLink org.eclipse.persistence.platform.database.DerbyPlatform Hibernate org.hibernate.dialect.DerbyDialect OpenJPA. org.apache.openjpa.jdbc.sql.DerbyDictionary
It’s not easy to get information on derby keys once you created them. I was looking for a command like “SHOW CREATE TABLE ” but no luck. I realized that the answer should lay in SYS tables. After googling a while I found the following bit of wisdom: The following query will give you the UNIQUE constraints on a table: select c.constraintname, c.constraintid from sys.systables t, sys.sysconstraints c where t.tablename = ‘FOO’ and t.tableid = c.tableid and c.type = ‘U’; ...
The JDBC Sampler always commits (it doesn’t honor the auto-commit = false parameter) http://issues.apache.org/bugzilla/show_bug.cgi?id=42018. I’ve provided a patch that solved it at Bugzilla
I released the Enhanced JDBC Sampler for Apache JMeter 2.2 source code today. See the bottom of this page to find the downloadable zip and instructions.
I just released the source code for the other Apache Jmeter plugin that I host here. Just go to the end of this page to download the file and get instructions.
If you are tired of the old “Graph Results” listener that JMeter provides and want better charts in your Jmeter test plan take a look at this JMeter plugin. This is how the old “Graph Results” look like: Click on the above image or here to see an enlarged version of the old Graph Results Checkout this new JMeter plugin that provides a new Statistical Aggregate Report listener. (see the screenshot) ...
UPDATE2:: It seems that my bugreport has been reviewed and the patch I submitted is merged into the JMeter svn tree. I also submitted a couple of patches dealing with COMMIT behavior that also have been included into the svn tree. so I strongly advise to use the standard JDBC Sampler as it includes alll features of the Enhanced JDBC Sampler plus other corrections UPDATE: It seems that the patch has been merged with the standard JMeter source code tree as SVN r528906. I think, however, that the change it’s not present yet in the 2.2 release you need to download the Nightly Build. ...
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.
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 ...
I’ve been working with Apache JMeter 2.2 mainly for JDBC benchmarks and I found a couple of bugs.