JasperServer - External DataBase Authentication

[nageshit2011]

Hi,

I done external database configuration in jasperserver 5.2 distribution war. Its working in window.But its not working in Linux. 

Can you please guide me.

[ilona]

What is the error you're getting in Linux?

Thanks,

Ilona

[nageshit2011]

Error Log:

17:23:17,740 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5) org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: FATAL: invalid value for parameter "TimeZone": "IST"

17:23:17,749 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5)      at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)

17:23:17,755 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5)      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:573)

17:23:17,760 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5)      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)

17:23:17,765 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5)      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:662)

17:23:17,770 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5)      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:702)

17:23:17,775 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5)      at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:112)

 

 

Finally i fixed it. postgres driver problem. Currently distribution contains 9.2 version. Now i chnaged to 9.1. its working fine.but i am unable to connect iwth ireport. while connecting with ireport i am getting soap related exception.

if possible can you guide me.