XML vs SQL

[visert]

Hi to all

I need to produce a PDF using a ireport template in a J2ee web-app.

 

I see two main way:

1) passing a XML file to ireport class and produce PDF.

2) build the report with a JDBC connection that take data using SQL (SELECT) directly on database.

PRO/CONS?

are there some contraindications to use 1) or 2) ?

 

For example... using a jdbc connection could be critical for DBMS calling it by a j2ee back-end EJB class?

In solution 2) the transaction of SELECT QUERY is managed by ireport template class...is secure for eventual loop o error ( could be?) of the query? Is DBMS secure in this way?

 

thank u