Ireport - JasperServer: PostgreSQL error (Driver)

I am trying to run my report created on iReport 4 on the jasperserver with a postgresql database (On my localhost).

The report runs perfect on the preview on iReport. Now when I upload it to the jasperServer I get the following error:

1 - org.postgresql.Driver java.lang.Exception: 1 - org.postgresql.Driver  at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403)  at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320)  at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70)  at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)  开发者_如何转开发 at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)

Then I checked my OLAP settings on my jasperServer and noticed it doesn't have a postgresql driver.

mondrian.jdbcDrivers sun.jdbc.odbc.JdbcOdbcDriver,org.hsqldb.jdbcDriver,oracle.jdbc.OracleDriver,com.mysql.jdbc.Driver

And on my jasperreport I use the following driver:

PostgreSQL (org.postgresql.Driver)

I think this is the problem. Does anyone know how I can add this postgresql driver to my jasperserver? Or is there a different problem?

The PostgreSQL driver jar should go into the lib directory of your application server. If you are using the bundled version of tomcat that comes with jasperServer, this will be

<jasperServer_install>\apache-tomcat\lib

More detailed instructions are available here.