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, tools, and much more.