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 http://dev.mysql.com/doc/refman/5.0/en/connector-j-installing-upgrading.html#connector-j-installing-upgrading-5-1 , 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
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
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.
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.
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:
Post atleast one post a day.
Add atleast a 50 word comment if I am posting a video.
Add a section called Cool Tech
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.