My activities

Procedure to Configure a JNDI Connection in JasperServer

Applies to RiskVision Versions: 7.5, 8.0 

Procedure to create  a JNDI connection in JasperServer:

  1. Create a resource in the context.xml file 
  2. Open file context.xml ('%ReportServer_Home%\apache-tomcat\webapps\jasperserver-pro\META-INF') in a text editor. 
  3. Create a resource by adding the following text to the bottom of the file  <Resource name="jdbc/RiskVision" auth="Container" type="javax.sql.DataSource"  maxActive="100" maxIdle="30" maxWait="10000"  username="reportuser" password="<password>"  driverClassName="com.mysql.jdbc.Driver"  validationQuery="SELECT 1" testOnBorrow="true"  url="jdbc:mysql://localhost:3306/agiliance autoReconnect=true&amp;autoReconnect  ForPools=true"/>  **Update with reportuser password and hostname reference 
  4. Create a resource in the web.xml file 
  5. Open file web.xml ('%ReportServer_Home%\apache-tomcat\webapps\jasperserver-pro\WEB-INF') 
  6. Locate <resource-ref> tag in the file and append the following text with this reference.  <resource-ref>  <description>AgiJNDI </description>  <res-ref-name>jdbc/agiliance</res-ref-name>  <res-type>javax.sql.DataSource</res-type>  <res-auth>Container</res-auth>  </resource-ref> 
  7. Save and close this file. 
  8. Set the Data source Type and Properties 
  9. Login to JasperSoft as sysadmin  http://localhost:8480/jasperserver-pro/login.html 
  10. Click Create Datasource 
  11. Enter values  - Type: JNDI Data Source  - Name: JNDI Agiliance  - ID: JNDI Agiliance  - Service Name: JNDI Agiliance  - Save Location: /public/Data_Sources 
  12. Click "Test Connection" and verify it is successful 
  13. Click "Save" once the test connection is successful 
  14. Open a report in edit mode, Click Data source and change data source to: /public/Data_Sources/JNDI_Agiliance 
  15. Click submit 
  16. Run one of the slow reports and let us know the timings. 

For further details, refer to the JasperReports-Server-Admin-guide  Section: JNDI Services. page 250  Explains how to create a resource in the context.xml and web.xml files  Section: JNDI Data Sources page 71  Explains how to create a data source  Contact product support if there are questions or issues with the defined process

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk