jdeppuser Posted May 5, 2016 Share Posted May 5, 2016 My first attempt at JasperSoft Reports, community edition.Installed the necessary plugin to get it to work in Spring Tool Suite. Created a new report project and added the data adapter to connect to a sql database and the connection worked fine. Then tried to create a new report and select a datasource and design a query. This is where the error is produced: user lacks privilege or object not found: and the object in this case happens to be the DB table. I have been unable to retrieve any solution online and hoping someone can direct me here. Appreciate your response. Link to comment Share on other sites More sharing options...
hozawa Posted May 7, 2016 Share Posted May 7, 2016 Did you select the data set (second icon from the left) to use in your report? Does the user you've set in the data adapter have privileges to the table you wish to use? Link to comment Share on other sites More sharing options...
jdeppuser Posted May 9, 2016 Author Share Posted May 9, 2016 HozawaThanks for your response. Yes, within the datasource selection in the report wizard I selected the data adapter but not sure what the dataset you referring to.As I mentioned above, I tested the data adapter with the test connection and it worked fine so user credentials show privileges. Could you please look at the image:/sites/default/files/images/JaspersoftReportWizard.png Link to comment Share on other sites More sharing options...
jdeppuser Posted May 11, 2016 Author Share Posted May 11, 2016 Does anyone have any tutorials or example related jasper projects that are created within spring tool suite? 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