Nothing happens on "Read Fields"

[2004 IR Help]

By: smeet - smeet

Nothing happens on "Read Fields"

2004-08-05 06:19

Hello,

I'm new with iReport and I have the following problem :

I defined a JDBC Connection, which works well (the 'Test' button returns "successfull"). I'm using Oracle Driver for Oracle 9i. I'm using iReport 0.3.2.

 

Now, I'm trying to insert fields in my report. I created a simple query : SELECT * from TEST_TABLE, and nothing happen when I click on 'Read Fields'. I tried to check/uncheck the 'Automatically Retrieve Fields Button', and it doesn't change.

 

If someone could help me, i'd be gratefull ^^

Damien++

 

 

 

 

By: Giulio Toffoli - gt78

RE: Nothing happens on "Read Fields"

2004-08-05 06:27

 

Have you set your connection as "active connection" ?

 

To do it, go to the build menu->Set Active Connection.

 

If you have done it, be sure that there is not an sql error.

 

If you have trouble, be sure you have set "save password" = yes for your connection (this was a problem with old versions of iReport).

 

Giulio

 

 

 

 

By: smeet - smeet

RE: Nothing happens on "Read Fields"

2004-08-05 06:52

Thank you very much ! That actually was my problem !

I was absolutely no looking in the 'build' menu, because I was thinking this menu was only used to generate reports.

Thanks again.

Damien++

 

 

 

 

 

 

By: urmeli70 - urmeli70

RE: Nothing happens on "Read Fields"

2004-08-12 01:49

Hi,

read fields doesn't work with xml-datasources, so I can't make the fields appearing in the lower half of the window.

 

I have the sample files from the addressbook-example, but after all I didn't manage to connect the report to the xml-datasource-file.

 

If anyone had a hint, would be great...

Jan.

[martynhiemstra]

This has nothing to do with not saving passwords, xml databases or active connections.

 

This is a genuine BUG in iReport. It has been in there since at least 2.0.1. I have tried everything. I even tried a simple query SELECT * FROM {RANDOMTABLE} but nothing. Connection test works fine. The query is OK and the connection is the active connection. I even tried SELECT STRING_FIELD FROM TABLE since someone suggested that it might have to do with Date fields but that didnt work either. I can connect to the database using a client application and using that client I can execute the query perfectly.

 

The fact that no error is displayed or thrown indicates a bug in iReport.

Post edited by: martynhiemstra, at: 2007/11/21 12:44