Wont populate fields list for certain schema

[dwallen]

I just started using Ireport...

 

Using the Report Wizard per the tutorial works fine with several of out MySQL databases.

 

On one database (the one I am actually interested in), when I use the query designer to select a table either by double-clicking it or dragging it to the work area, I just get a tiny dialog box with no fields to check.

 

All of the databases are MySQL. They all test OK using the JDBC "Test" in Ireports. There is nothing special that I can think of regarding the schema that Irports wont work with.

 

Any ideas? As near as I can tell, Ireports lacks any diagnostics, so I'm not sure where to go next.

[mmflynn]

I'm having the same problem with the Query Designer if anyone can suggest a solution. I updated iReport 1.3.3 and Java to 1.6 to make sure that's not the issue.

 

Mary

[mmflynn]

Some more background info--I duplicated the problem with the stand-alone SQLeonardo download from Sourceforge. It's easiest to reproduce using the SugarCRM sample data. Fields do not appear for the "Orders" table in the Query Designer, but fields for "accounts" do appear.

[file name=sqleonardo_nocolumns.gif size=1805]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/sqleonardo_nocolumns.gif[/file]

 

More info--command line output. Are the table names case-sensitive?

<pre>

Microsoft Windows XP [Version 5.1.2600]

© Copyright 1985-2001 Microsoft Corp.

 

C:Program Files>cd SQLeonardo

 

C:Program FilesSQLeonardo>ls

sqleonardo-2007.03.zip sqleonardo.jar

 

C:Program FilesSQLeonardo>java -jar sqleonardo.jar

com.sun.java.swing.plaf.windows.WindowsLookAndFeel

loading resources...

loading session...

loading window...

Can't find the translation for key = application.menu.content: using default (sh

ow content...)

Can't find the translation for key = application.menu.definition: using default

(show definition...)

[ DiagramLoader::getPrimaryKeys ]

java.sql.SQLException: Table 'sugarcrm.orders' doesn't exist

[ DiagramLoader::run ]

java.sql.SQLException: Table 'sugarcrm.orders' doesn't exist

[ DiagramLoader::getPrimaryKeys ]

java.sql.SQLException: Table 'sugarcrm.orders' doesn't exist

[ DiagramLoader::run ]

java.sql.SQLException: Table 'sugarcrm.orders' doesn't exist

 

C:Program FilesSQLeonardo>

</pre>

Post edited by: mmflynn, at: 2007/05/04 20:14