What are the Essential DB Role required for DBUserName JBoss -Jasperreport server installation
Issue
- We would like to verify the specific underlying DB role of the dbuser ( that configured to connect the reporting database server) needed for JBoss and Jasper Reporting server installation and generating WAR files ?
- we need to know what are the essential specific DB roles to be granted during setup JBoss and Jasper reporting server ?
The related error message with no sufficient permission granted:
Error Message:
[org.infinispan.factories.GlobalComponentRegistry] (ServerService Thread Pool -- 76) ISPN000128: Infinispan version: Infinispan 'Brahma' 5.1.2.FINAL22:04:43,967 INFO [stdout] (ServerService Thread Pool -- 76) 2015-08-31 22:04:43,967 ERROR JDBCExceptionReporter,ServerService Thread Pool -- 76:101 - [TIBCO][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'JIResourceFolder', database 'DEDMT3', schema 'dbo'.
22:04:43,967 INFO [stdout] (ServerService Thread Pool -- 76) 2015-08-31 22:04:43,967 ERROR JDBCExceptionReporter,ServerService Thread Pool -- 76:101 - [TIBCO][SQLServer JDBC Driver][SQLServer]The cursor was not declared.
22:04:44,341 INFO [stdout] (ServerService Thread Pool -- 76)
Environment
- Red Hat JBoss Enterprise Application Platform 6.4.0
- Jasper Server
- MS SQL 2008 R2.
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
