Unknown column name

[2006 IR Open Dicussion]

By: karibouxe - karibouxe

Unknown column name

2006-07-07 02:43

Hi,

 

I am able to generate my report with Ireport, but when I want to generate with my application then i've that:

net.sf.jasperreports.engine.JRException: Unknown column name : nombre

at net.sf.jasperreports.engine.JRResultSetDataSource.getColumnIndex(JRResultSetDataSource.java:357)

at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:113)

at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:727)

 

 

 

By: Teodor Danciu - teodord

RE: Unknown column name

2006-07-07 02:57

 

Hi,

 

So which one is it? nombre or number?

Check your query again and see if it really

returns a column with such a name.

Otherwise remove the corresponding report field.

 

I hope this helps.

Teodor

 

 

 

By: karibouxe - karibouxe

RE: Unknown column name

2006-07-07 04:15

i'm french, it's 'nombre'. But for this forum, i want to write in english, that's why i translate my field name.

 

but the name is "nombre".

I try to execute this requete in sql browser: it work. In Ireport designer: it work but when i take this report and put in my application, i'm this error:

net.sf.jasperreports.engine.JRException: Unknown column name : nombre

at net.sf.jasperreports.engine.JRResultSetDataSource.getColumnIndex(JRResultSetDataSource.java:357)

at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:113)

at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:727)

 

Thanks for your helps