Hi Pramod,

I have 5.0.51a installed locally so I tried your sample report with 51a.  With 51a, I got  no result – no branch office displayed.  I also tried the “Pramod JDBC sample” report on the test server (MySQL / 5.0.45), and got no branch office returned on that report either:

“Sample Report to test if JDBC Data sources work in Mifos Birt reports

Branch:”

So I’m not sure the behavior is tied to a specific MySQL version.   I also tried your sample report via BIRT and was unable to preview the results without error.  In BIRT, I received the following error:

The following items have errors:

Data (id = 19):

+ Invalid field name: display_name

I then modified your report and added additional cell and new data set for DISPLAY_NAME and was able see results with that added row.  I’ve attached my modified Birt report if you’d like to look at the differences.  I also uploaded the modified report to the test server – the link on the reports page is “Revised Jeff JDBC BCC”.    Here are the results I see from this report:

Sample Report to test if JDBC Data sources work in Mifos Birt reports

Branch:

RevisedBranch:

BRANCH_OFFICE_1

More updates on this.

The "Branch Cash Confirmation" report which ships with Mifos works on Mysql 5.0.51a, but not on
5.0.51b.
It is possible this is a MySQL version issue. The report was originally tested against a server running
5.0.51a. But the Mifos release was later standardized as 5.0.51b (http://thread.gmane.org/gmane.comp.finance.mifos.devel/5091).

However, the below sample report still failed on 5.0.51b. I am not sure why. If anybody has 51a installed,
can you try either this or the BCC report against it?

Thanks,
Pramod Biligiri,
ThoughtWorks

mifos-developer-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org wrote on 08/28/2008 03:21:26 PM:

>
> Hi,
> JDBC data sets are not working at all, hfor BIRT reports uploaded to
> Mifos. I want to know
> if anyone else is seeing the same issue. Can someone try the attached
> report on your Mifos install and
> tell me if it works? This probably broke *just* before we shipped 1.1.
> I'm trying to figure out when.
>
> I created a barebones JDBC report with JDBC data set and datasource.
> The DataSet preview from within
> Eclipse shows the results of the query quite fine, but I only see
> blanks when report file is viewed through Mifos.
> I looked at MySQL query logs and it shows the query is actually running.
>
> I've uploaded this report on http://test.mifos.org:8085/mifos/. (Look
> for Reports -> Misc -> "Pramod Jdbc Sample")
> The report contains this one query to show Branch Name: select
> display_name from office where office_id = 5
>
> I hope my connection string, username and password are correct for the
> test server (jdbc:mysql://localhost:3306/mifos?
> useUnicode=true&characterEncoding=UTF-8, root, mysql)
>
> I have also attached that report file to this mail if you want to test
> it yourself.
>
>
>
> Pramod Biligiri,
> ThoughtWorks[attachment "JdbcBCC.rptdesign" deleted by Pramod
> Biligiri/India/ThoughtWorks]
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/

Pramod,

I am having a BCC report which works on Mifos with a direct jdbc connection.

This is a modified version of the initial Branch Cash confirmation report which came with 1.1

It has some issue with the parameter handling.

I had done some modifications with the report to make it run.

This might help you to find out why the JDBC might not be working. Also the server name [localhost & IP in jdbc], username & password might be a reason for the report to fail.

You have to modify the following for the data source in the report for it to work

Driver Class : com.mysql.jdbc.Driver

URL: jdbc:mysql://localhost:3307/mifos

Username:root

Password:mifos

See if it is of some help

Regards,

Nagananda Kumar. K.N

Asst. General Manager [Information Technology]

Grameen Financial Services Pvt. Ltd

Avalahalli, Anjanapura Post,

Bangalore

Karnataka

India

PinCode: 560062

Ph: 080-28436237, Fax: 080 28436577

Mob: 9845104252

Email:naganand-T4d6g3KmHTYYusOVjxUodA@public.gmane.org

            naganandkn-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org

Website: www.grameenkoota.org

More updates on this.

The "Branch Cash Confirmation" report which ships with Mifos works on Mysql 5.0.51a, but not on
5.0.51b.
It is possible this is a MySQL version issue. The report was originally tested against a server running
5.0.51a. But the Mifos release was later standardized as 5.0.51b (http://thread.gmane.org/gmane.comp.finance.mifos.devel/5091).

However, the below sample report still failed on 5.0.51b. I am not sure why. If anybody has 51a installed,
can you try either this or the BCC report against it?

Thanks,
Pramod Biligiri,
ThoughtWorks

mifos-developer-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org wrote on 08/28/2008 03:21:26 PM:

>
> Hi,
> JDBC data sets are not working at all, hfor BIRT reports uploaded to
> Mifos. I want to know
> if anyone else is seeing the same issue. Can someone try the attached
> report on your Mifos install and
> tell me if it works? This probably broke *just* before we shipped 1.1.
> I'm trying to figure out when.
>
> I created a barebones JDBC report with JDBC data set and datasource.
> The DataSet preview from within
> Eclipse shows the results of the query quite fine, but I only see
> blanks when report file is viewed through Mifos.
> I looked at MySQL query logs and it shows the query is actually running.
>
> I've uploaded this report on http://test.mifos.org:8085/mifos/. (Look
> for Reports -> Misc -> "Pramod Jdbc Sample")
> The report contains this one query to show Branch Name: select
> display_name from office where office_id = 5
>
> I hope my connection string, username and password are correct for the
> test server (jdbc:mysql://localhost:3306/mifos?
> useUnicode=true&characterEncoding=UTF-8, root, mysql)
>
> I have also attached that report file to this mail if you want to test
> it yourself.
>
>
>
> Pramod Biligiri,
> ThoughtWorks[attachment "JdbcBCC.rptdesign" deleted by Pramod
> Biligiri/India/ThoughtWorks]
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/