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.
2 Answers:
Posted on March 15, 2014 at 5:53pm
>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.
Posted on March 17, 2014 at 12:55am
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): &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&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true" username="root" validationQuery="SELECT 1"/>
<!-- Comment this line to enable session persistence across Tomcat restarts -->
<Manager pathname=""/>
</Context>
