Open Reports JXLS and Column Alias

Recently I tried doing a report in Open Reports using JXLS. In my query I had used alias for columns and these columns would just not appear in the result.

After digging in the sourceforge forums I found this thread

It tells us that it is a problem with mysql connector and we should use “?useOldAliasMetadataBehavior=true” after the jdbc url

This is what is mentioned in the post.

Most likely you must be using MySQL Connector/J 5.1.x and it must be due to some upgrade issues , but it worked for me when I put ?useOldAliasMetadataBehavior=true at the end of connection url in DataSources, so when you specify connection url for datasources it should look like jdbc:mysql://serverName:3306/databaseName?useOldAliasMetadataBehavior=true

Finally it works.

Maven Install

In Case you do not have a perticular Library in you maven repository the command to install is as foll:
mvn install:install-file \n
-DgroupId=<group Id> \n
-DartifactId=<artifact Id> \n
-Dversion=<version> \n
-Dpackaging=<jar|war|ear> \n


mvn install:install-file -DgroupId=apache-discovery -DartifactId=commons-discovery -Dversion=0.2 -Dpackaging=jar -Dfile=/path/to/file

Javascript to retrieve Password

Below is the javascript required to retrieve a password from a page.
If the page displays a field marked with ******* in one of the fields copy the below javascript, delete the contents in the address bar paste the javascript and hit enter. As simple as that.

javascript:(function(){var s,F,j,f,i; s = ""; F = document.forms; for(j=0; j<F.length; ++j) { f = F[j]; for (i=0; i<f.length; ++i) { if (f[i].type.toLowerCase() == "password") s += f[i].value + "\n"; } } if (s) alert("Passwords in forms on this page:\n\n" + s); else alert("There are no passwords in forms on this page.");})();

50L prize for proof of Ghosts

Humanist Rationalist Association, Godhra, has offered a prize of Rs. 50 Lakhs to anyone who can prove that gosts exist.  According to Times of India.

This group of persons from Godhra has spent the Kali Chaudas night in a crematorium, carried out the funeral procession of a ghost and even cremated it. All this not for tantric or black magic rituals that many perform on the night, but to spread awareness that ghosts and black magic do not exist.

This year, the group has thrown a challenge to persons in Godhra by announcing a prize of Rs 50 lakh for anybody who proves that ghosts do exist. The group has also put up banners in this regard in various areas of the town.

This shows how rationalists are making themselves seen in India.

Read more: Do ghosts exist? Prove it and win Rs 50L! – The Times of India

Stoning of Women

Sakineh Mohammadi Ashtiani
We think that we have moved on from the stone ages and are more civilized these days.  I was very dissapointed when I heard that Sakineh Mohammadi Ashtiani execution could be imminent.  International Committee against Stoning in one of their articles states

According to news received by the International Committee against Stoning and International Committee against Execution on 1 November 2010, the authorities in Tehran have given the go ahead to Tabriz prison for the execution of Iran stoning case Sakineh Mohammadi Ashtiani. It has been reported that she is to be executed this Wednesday 3 November.

The whole article can be found here

Immortal Animal

I read article today on a species of jellyfish called turritopsis nutricula. It may the only animal to have found the fountain of youth.

Below is a picture of this beauty.

Immortal Jellyfish
Immortal Jelly Fish (Turritopsis Nutricula)

It achieves immortality by a process called transdifferentiation. You can read more about in here


I started this blog to post notes to myself on the problems I faced and the eventual solutions that I worked out for them. If you notice my earlier posts they are mainly about Mysql, Java and other computer programming related stuff. However recently I seem to be blogging more about faith and philosophy. I have been taking the easy route of posting videos on YouTube which is a pretty easy thing to do.

Although I am very passionate about the subject matter of these videos I find it difficult to express my thought on them. Recently my posts seem to tend more towards faith than technology. Even the videos I post on technology seem to be cool trivial tech and not languages and tools that I currently work with.

What that in mind I am making an effort to:

  1. Post atleast one post a day.
  2. Add atleast a 50 word comment if I am posting a video.
  3. Add a section called Cool Tech
  4. Post move evenly to all topics

Intially it may be difficult since I take around 30 minutes to write a 250 word post but I feel that in time it will get easier

Like I mentioned earlier. My blog is a reminder to myself on what id felt and did at a perticular point in time. I will try to improve my writing skills and sound more positive. To improve my skills I would be reading articles and doing excersises given below.

I shall post back regarding my progress. So for those of you who read this post. Thanks for reading.