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,
Get latest updates about Open Source Projects, Conferences and News.