javi_123 Posted October 15, 2008 Share Posted October 15, 2008 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now