Skip navigation links

MySQL Forums :: Connector/JDBC and Java :: How integrate JasperReports 1.2.5 with mysql-connector-java-5.0.3 to execute query´s with aliases on fields


Advanced Search

How integrate JasperReports 1.2.5 with mysql-connector-java-5.0.3 to execute query´s with aliases on fields
Posted by: Pedro Fabián ()
Date: March 20, 2007 04:53PM

Hi, I working on jasperreports and use AS expresion in an sql statement, example: SELECT field_a + field_b AS sum FROM table_1, But using JDBC (mysql-connector-java-5.3.0-bin.jar) the alias sum is send back '' or null as title of field. I´m working with MySQL 5.0.24 and jdk 1.4.0 and jasperreports 1.2.5. Any suggest

I provee with mysql-connector-java-3.1.11-bin.jar and work fine but the strore procedures not.

Thanks.

Options: ReplyQuote


Subject Written By Posted
How integrate JasperReports 1.2.5 with mysql-connector-java-5.0.3 to execute query´s with aliases on fields Pedro Fabián 03/20/2007 04:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.