How to reconfigure JasperSoft 6.x when changing/moving JasperSoft SQL database/repository

How to reconfigure JasperSoft 6.x when changing/moving JasperSoft SQL database/repository

JasperSoft uses a repository data source to store its profile data and this repository database is an integral part of the JasperSoft application. Without it, JasperSoft will not function. If making any changes to this repository data source such as its database server (Postgres, MySQL, SQL, Oracle, etc), configuration (port),  and/or access credential (name and password),  changes are required to the application context to reflect the repository data source changes.

In this example, the JasperSoft SQL database will be moved to another SQL server location.  Similar steps can be used if other JasperSoft database changes (i.e. port, user name) are made.

1.  Stop the Apache Tomcat service on the JasperSoft server

2.  Take a backup of the SQL JasperSoft database and restore it to the new SQL server

3.  Take a backup of the <Apache Install Directory>\webapps\jasperserver-pro\META-INF\context.xml file on the JasperSoft server

4.  Using a text editor, open the <Apache Install Directory>\webapps\jasperserver-pro\META-INF\context.xml file on the JasperSoft server

5.  Locate the section that looks similar to the following

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="jasper" password="Password" driverClassName="tibcosoftware.jdbc.sqlserver.SQLServerDriver" accessToUnderlyingConnectionAllowed = "true" validationQuery="SELECT 1" testOnBorrow="true" url="jdbc:tibcosoftware:sqlserver://localhost:1433;databaseName=jasperserver;SelectMethod=cursor;sendTimestampEscapeAsString=false factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"/>

6.  Change the URL parameter to reflect the new location of the JasperSoft database.

7.  Save changes to the file

8.  If it exists, delete the JASPERSERVER-PRO.XML file from the <Apache Install Directory>conf\Catalina\localhost directory on the JasperSoft server

9.  Restart the Apache Tomcat service on the JasperSoft server

10.  Test JasperSoft UI and functionality