Jump to content
Changes to the Jaspersoft community edition download ×

Wont populate fields list for certain schema


dwallen

Recommended Posts

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.

Link to comment
Share on other sites

  • 4 weeks later...
  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...