subdataset / SQL query

[babarincairo]

Hi,

 

I want to build a crosstable with a subdataset but I've a problem with the sql query :

 

Code:

SELECT VED_complet,YEAR(VED_crea_date) as VED_annee
FROM VED_vedette

 

The problem comes from YEAR(VED_crea_date) as VED_annee

 

When I execute the report, I have the following error :

 

Code:

[code]org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@141e072 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@1f680ea, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Unknown column name : VED_annee

 

I think that Jasper doesn't support the keyword "AS" but I don't know to do without

 

Can anyone help me ?

 

Thanks

[lucianc]

What database and JDBC driver (incl version) are you using?

 

Regards,

Lucian

[babarincairo]

I use :

 

- MySQL 5.0.21

- JDBC 5.0.3

[lucianc]

There are a couple of bugs (artf1368 and artf1545) related to this. There is not fix yet.

 

MySQL JDBC connector 5.0 breaks backward compatibility by changing the semantics of the ResultSetMetaData.getColumnName() method. According to this bug report, the 5.0.4 connector will feature a compatibility flag (useOldAliasMetadataBehavior) so that applications which used to work with the 3.1 connector work with the 5.0 connector as well.

 

Regards,

Lucian