From: Rama Mohan Pacific Net <ramohan@pa...> - 2004-11-15 15:26:19
Firstly, JasperReports is 'Java'. I.e., u can specify all file paths
using / (forward slash). UNIX or DOS.
Secondly, there are a few ways to address SQL issues.
1) pass the SQL as a parameter and use the following
2) use ANSI-SQL and desist from using database specific extensions
(e.g., ORACLE's + for outer join)
3) use a product like OJB to query data and pass the queried data as a
Collection of Java Beans.
Hope this helps.
Rao (Rama Mohan Rao)
--- Original Message ----
I pass SQL connection to jasper fillManager() which in turn executes the SQL
queries written in query section of the template. The queries written are
MS-SQL specific. Now, I want to use same template for Oracle DB. Now, the
problem is SQL queries written in query section of template will fail on
So, can I pass query string in parameter map ? If yes, how to access the
parameter map in query section ?
Current setup is Windows 2000 with MS-SQL 2000. So, all our templates have
MS-SQL specific queries hard-coded in template design with subreports
included in main templates and accessed like
Now, we are moving towards SOLARIS - ORACLE combination. We do not want to
keep two copies of template with only change in query section. This will
increase our maintenance. So, our aim is to create OS + DB independent
Also, the path mentioned above uses back slash but Solaris needs front slash
(I am not sure). How to achieve same in the template during design time
All you suggestions/comments are most welcome.
We want to submit the efforts required at earliest. So, please give me
suggestions at earliest.
Thanks and Regards,