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.