Execute sql query from expression editor ireports

0

Hi,

I am trying to work out the multi tenancy service where we have multiple customer's using the same application layer but different database.

I have created a new table in jasperserver database and i want to retrieve the data which will be passed in a parameter.

The parameter i have created has class type java.sql.PreparedStatement and inside the expression editor i have $P{REPORT_CONNECTION}.prepareStatement("select * from table") but i think this is not the right way to execute a sql through expression editor.

i NEED TO KNOW HOW TO EXECUTE A SQL STATEMENT USING EXPRESSION EDITOR..

Please reply back with the solution.

javi_123's picture
Joined: Aug 21 2008 - 1:15am
Last seen: 1 month 1 week ago

Answers:

No answers yet
Feedback
randomness