Installation of Jaspersoft Studio & Server – Configuration of Jasper Server

Posted on by By admin, in Jaspersoft | 0

Steps to install Jaspersoft Studio

Make data easy with Helical Insight. Helical Insight is the world’s best open source business intelligence tool.

Click Here to Free Download

  1. Download Jaspersoft Studio 7.9 version
  2. Follow the installation process
  3. Create a workspace
  4. Switch the workspace in Jaspersoft Studio pointing to Step-3

Steps to install Jasperserver

  1. Download Jasperserver 7.9 version
  2. Follow the installation process
  3. Jasperserver will be installed on 8080 port
  4. Access jasperserver using the following link

Steps to change the port number(8081) of Jasperserver

1. Open server.xml in ..\jasperreports-server-7.9.0\apache-tomcat\conf

2. In the below line update port value as needed

<Connector port="8081" URIEncoding="UTF-8" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" compressibleMimeType="text/html,text/xml,text/css,text/javascript,application/json,application/javascript" compression="on" compressionMinSize="128" noCompressionUserAgents="gozilla,traviata"/>

3. In the below line update the shutdown port value as needed

<Server port="8006" shutdown="SHUTDOWN">

4. Save server.xml

5. Restart the server

Steps for jasperserver to point the jasperserver database on another server

1. Go to the jasperreportsserver/postgres/bin folder


2. Take a backup of the jasperserver database

pg_dump -U jasperdb -W -F p jasperserver ><Folder_path>\jasperserver_backup.sql

3. Copy the backup file to another server

4. Create jasperserver database in another postgres server

Make data easy with Helical Insight. Helical Insight is the world’s best open source business intelligence tool.

Claim Your 30 Days Free Trail

CREATE DATABASE jasperserver;

5. Create jasperdb user with password as “password” in another postgres server

CREATE USER jasperdb WITH PASSWORD 'password';

6. Go to bin folder of postgres in another server


7. Execute the following to restore the jasperserver database

psql -U postgres -d jasperserver -f <Folder_path>\jasperserver_backup.sql -p 5433

8. Go to buildomatic folder in jasperserver


9. Update the file with another server postgres details and save the file

# database type

# database location and connection settings


# additional database parameters
# (uncomment these if you want non-default settings)


10. Restart the jasperserver

Steps to test that jasperserver is pointing to another postgres server

1. Add a new role in jasperserver

2. Go to postgres on another server and execute the following query

3. The role created from jasperserver should be in the resultset of the query

Steps to update JNDI connection

Make data easy with Helical Insight. Helical Insight is the world’s best open source business intelligence tool.

Lets Register For Live Demo

1. Go to context.xml in the following location

2. Update jasperserver with the postgres details on another server

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="jasperdb" password="password" driverClassName="org.postgresql.Driver" accessToUnderlyingConnectionAllowed="true" validationQuery="SELECT 1" testOnBorrow="true" url="jdbc:postgresql://;amp;characterEncoding=UTF-8&amp;amp;autoReconnect=true&amp;amp;autoReconnectForPools=true" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"/>

3. Save context.xml

4. Restart the server


Helical It Solutions


Best Open Source Business Intelligence Software Helical Insight is Here


A Business Intelligence Framework

0 0 votes
Article Rating
Notify of
Inline Feedbacks
View all comments