Ibator (formerly knows as ‘Abator’) is an invaluable code generator to create all necessary code to access database tables with the (also pretty invaluable) Java OR framework Ibatis.
Ibator creates a variety of SQL code to easily build here-clauses to acces your tables. The one thing that is missing is support for the SQl “limit” clause which is offered by Mysql and other popular databases.

A guy called harawata has created a plugin for Ibator, which creates code to easily add “limit” clauses to your db-calls. Thank a lot for this (once again invaluable) tool! You might also want to check out his other plugins.

Ok, so now how to add these Plugins to the code generator? You need to compile the classes with ibator.jar in the classpath.

Then enable the Plugin in your ibatorConfig.xml file within the <ibatorContext>:

<ibatorPlugin type=”AddLimitClausePlugin”></ibatorPlugin>

Finally add the resulting Plugin-file to the classpath when calling Ibator:

java -cp ibator.jar:limit.jar org.apache.ibatis.ibator.api.IbatorRunner -configfile ibatorConfig.xml -overwrite

Of course this will also work when starting Ibator from an ant file.

Update:
The Standard Definition version of episode 2 has now been uploaded. Still nothing in HD though. But I think this is pointing to a technical problem at Apple. Way to screw up on the premiere day of one the best shows on TV, Apple!

Last night the final season of LOST started. Apple offers season passes for this season in it’s iTunes store. Previously with these passes you could download episodes as soon as they aired.

It’s has now been 15 hours since the first two episodes of LOST Season 6 aired and they are still not on iTunes. Allegedly the episodes of the new series “Caprica” are delayed 5 days on iTunes! Could it be that ABC made Apple delay LOST before putting it on iTunes?
Also, Apple should be forward in this case and clearly tell when episodes are available, before I actually shell out $50 for the seasons pass.

Of course there is no communication from Apple’s side and I can just hope that a shitstorm breaks loose on blogs and Twitter which warns people of buying TV shows from Apple’s iTunes store.

There is already a mild uproar on Twitter going on among LOST fans.

But probably it’s just a technical issue of some sort. Stay tuned as this story develops…

Update:
I am an iPhone Application developer and had to accept new term of service for putting my Apps on iTunes just today. Probably this also required some maintenance in the store which delays the episodes?

Check the indexes fo your Mysql tables, kids Because this happens when you’ve got a rather complicated join over two not even very big tables. Mysql “slow statements” keep ramping up, consuming a lot of cpu time and (more importantly clogging Mysql, so that other statements have to wait quite a while.