We use JasperServer 6.0.1 to connect Redshift, of which the former is also on the AWS, database driver version is compatible JDBC4.0 1.1.13, connection is good, most of the time but occasionally appear this problem, the symptom is JasperServer cannot perform database query returns the query results, view JasperServer log to see 'the Not Connected' mistakes, only through a restart JasperServer to restore,

This article mentioned the http://wiki.pentaho.com/display/analysis/PA_CR_PA-3.9.0.0-RC1_redshift_08.00.0002_RedshiftJDBC-1.0.13.1313 exactly the same error log, say when using connection pool occasionally happen this problem, but can't reproduce uncertainty;
AWS support timeout problem, suggest that we set the TCP Keepalive, because unable to reproduce, can only make the system run in a modified then there waiting if it again, but it is too passive, once the bad to use, the customer will be submitted, affect the quality of the product prestige,

Could you tell me who understand the problem, or give your opinion,

CodePudding user response:

I'm sorry, because my ability is limited, can't help you,