Dynamic connection to the db

[mardeea]

Hello,

It is possible to set a dynamic connection to an Oracle database for Jasper reports when we call them from Oracle Forms? 

In other words, we need Jasper reports to connect to the database with the user and the password of the current user that runs the report (the user and the password with which the user connects to the application). This is needed in context of the existing implemented application.

Thank you

[Filip C.]

How do you connect to JasperServer ? What API are you using ?

Normally you should be able to send Username and Password to JasperServer ... Unless you enabled anonymous access, you should be doing so already ... If not you cannot acces Jasperserver. SO it would be a question of implementing some extra code in your Oracle Forms

[mardeea]

At the moment we are trying to run the report on the weblogic server (we imported the jasper libraries into forms), but we ran into a "Could not initialize class net.sf.jasperreports.engine.util.JRStyledTextParser" error when we try to run it from the application (from cmd line it works) and at the moment we are stuck, even though we tried many solutions we found online.
As far as we could understand Jasper reports server is using data adaptors which means that the users and passwords need to be already on the server, the ideal way would be to have only one user to connect to the db (correct me if i'm wrong).
We have a 1:1 report between the application users and the database users, so we need to be able to connect with many users, including newly created ones. That doesn't seem very feasable with data adaptors, at least from what we read up until now. Could we run the report on the jasper server without using the data adaptors and instead sending the password from Oracle Forms somehow?

TIA