Jasper Server is very slow when using Seperate Cloud servers for Jasper war and Database

0

Hi,

         I using Seperate Cloud servers for Jasper war (tomcat) and Jasper Database (Mysql). It is Very slow. Sometimes only its working fine, most of the time its not working, came Communication link error in log. Please suggess me if anything I miss in Configuration.

vasanth.i2it's picture
Joined: Aug 16 2013 - 12:09am
Last seen: 3 years 3 months ago

2 Answers:

0

>Please suggess me if anything I miss in Configuration.

Difficult to answer your question becuase you haven't posted any of your configuration.

It just seems like you're having network performance problem between your JasperReport Server cloud instance and your MySQL cloud instance. Nevertheless, first check if your MySQL is returning results in a reasonable amount of time and then check how much time it's requiring JasperReports Server to get the resultset back.

hozawa's picture
56312
Joined: Apr 24 2010 - 4:31pm
Last seen: 7 months 2 weeks ago
0
Hi hozawa,
        Copied jasperserver/META_INF/context.xml file  below. I need to change anything?
 
<?xml version="1.0" encoding="UTF-8"?><Context path="/jasperserver" reloadable="false">
 
    <!-- maxActive: Maximum number of dB connections in pool. Make sure you
         configure your mysqld max_connections large enough to handle
         all of your db connections. Set to 0 for no limit.
    -->
    <!-- maxIdle: Maximum number of idle dB connections to retain in pool.
         Set to -1 for no limit.  See also the DBCP documentation on this
         and the minEvictableIdleTimeMillis configuration parameter.
     -->
    <!-- maxWait: Maximum time to wait for a dB connection to become available
         in ms, in this example 10 seconds. An Exception is thrown if
         this timeout is exceeded.  Set to -1 to wait indefinitely.
    -->
 
    <!-- Additional properties to consider. Settings for specifying a      -->
    <!-- validation query to help with reconnect/timeout errors.           -->
    <!-- Exact syntax may vary with database type (this tested on mysql.   -->
    <!--                                                                   -->
    <!--   validationQuery="select 1"                                      -->
    <!--   testOnBorrow="true"                                             -->
    <!--   (and add this to url property): &amp;autoReconnectForPools=true -->
 
 
 
    <Resource auth="Container" driverClassName="org.mariadb.jdbc.Driver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/jasperserver" password="pass" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:mysql://[My_IP]:3306/jasperserver5.5?useUnicode=true&amp;characterEncoding=UTF-8&amp;autoReconnect=true&amp;autoReconnectForPools=true" username="root" validationQuery="SELECT 1"/>
 
 
 
 
 
    <!-- Comment this line to enable session persistence across Tomcat restarts -->
    <Manager pathname=""/>
</Context>
vasanth.i2it's picture
Joined: Aug 16 2013 - 12:09am
Last seen: 3 years 3 months ago
Feedback
randomness