avik.paul Posted November 16, 2015 Share Posted November 16, 2015 I'm trying to run a report with a stored proc that returns "java.sql.SQLException: ResultSet is from UPDATE. No Data." exception in Jasper Server. However, it runs fine fro iReport. If I delete the body of the Stored proc and return a static data, the report works fine in Jasperserver. Tried every possible way to my knowledge... Its still out there.!My question is How to solve this issue? or atleast where can I search for any clue....???A quick reply would be appreciated. Link to comment Share on other sites More sharing options...
zh3ntil Posted November 16, 2015 Share Posted November 16, 2015 Hi,Your SP have to return a result set. I mean your SP have to end with a SELECT query. And in studio, you should change your query language to 'plsql' and publish to server. After that, Report should run correctly. 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