Thursday, March 20, 2008

Live JasperSoft Seminar

I was lucky enough to attend the JasperSoft Seminar held at their headquarters in San Francisco yesterday (March 19, 2008). There were basically 3 sessions and I personally did not get much from the seminar.

What I found interesting was that I was able to talk to Guilio Toffoli who created the iReport which is basically the GUI software to create JasperReport xml files. We talked about performance limits of the software, problems that I had with designing the queries using SQLeonardo, and other stuff.

2 comments:

Anonymous said...

Hi, I'd like to know which kind of problems did you had with designing the queries using SQLeonardo...I'm really interested! Thanks!

nickyb

Bichonfrise74 said...

It has been a long time since I last tested JasperSoft so some of the items below might not be 100% accurate. There were a couple of problems with SQLeonardo namely,

1. It doesn't work with MySQL 4.1 when the table names are in uppercase. It would say something like the tables don't exist. -- The workaround for me was changing the table names in lowercase.

2. I tested this in MySQL 5.0 and I had problems dragging the table names to the 'drawing board'. If I recall, either the lines are not being drawn properly, or the table are overlapping each other.

Anyway, in the end, SQLeoanardo was not intuitive enough for me.