Jump to content
Changes to the Jaspersoft community edition download ×

How to use PostgreSQL


Recommended Posts

I installed iReports from iReport-1.3.1-windows-installer.exe in windows xp.


I saved postgresql-8.2-504.jdbc4.jar file from postgresql.org to C:Program FilesJasperSoftiReport-1.3.1lib



In iReports connection properties I specified:


Type of Connection/Data Source: Database JDBC connection


JDBC driver: postgresql-8.2-504.jdbc4.jar


JDBC url: jdbc://localhost:5432/mydb



Clicking Test button causes error



This class may not have found: postgresql-8.2-504.jdbc4.jar



Any ida hot to use PostgreSQL with iReport ?



Link to comment
Share on other sites

  • Replies 10
  • Created
  • Last Reply

Top Posters In This Topic

I selected this driver but clicking Test button causes erorr



Msg: org.postgresql.Driver

This class may not have been found: org.postgresql.Driver


Check your classpath.



I'm new to java.

What I'm doing wrong ?

How to force it to use the postgresql-8.2-504.jdbc4.jar or any other free Postgres driver ?

Link to comment
Share on other sites

org.postgresql.Driver can be found in that jar - jar name != driver name.


If the file is in your iReportlib folder, it doesn't have to be on the classpath - allthough it doesn't hurt.


Change your url to:


Post edited by: schaibaa, at: 2007/03/15 14:01

Link to comment
Share on other sites

I changed "JDBC URL" field in Connection Properties to




but clicking test button still shows ClassNotFoundError


postgresql-8.2-504.jdbc4.jar file is specified in classpath and copied to iReport lib directory.


What I'm doing wrong ?

Post edited by: kobruleht, at: 2007/03/15 19:14

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...