hussain.miah Posted July 2, 2014 Share Posted July 2, 2014 Hi there,I have previously installed Jasper Reports on a Linux server which was running in a BST timezone which worked fine. I am now trying to install the same version of Jasper Reports server on a linux machine which is set to UTC time.Whenever I try to start the tomcat service I get the following error:Caused by: org.postgresql.util.PSQLException: FATAL: invalid value for parameter "TimeZone": "BST"at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:572)at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:177)at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)at org.postgresql.Driver.makeConnection(Driver.java:393)at org.postgresql.Driver.connect(Driver.java:267)at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221) I have checked and the postgres database is using thre UTC timezone but for some reason the Jasper webapp seems to be stuck in BST for some reason. Any help would be appreciated. Link to comment Share on other sites More sharing options...
hozawa Posted July 2, 2014 Share Posted July 2, 2014 Shouldn't be happening if you did a fresh install of JasperReports Server and Postgres on you new server. Seems like your instance is trying to access the old PostregreSQL. Try deleting that to make sure the new instance will access the new Postgres server. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now