Playing With Wire » PostgreSQL http://www.playingwithwire.com The Internet Startup Blog Wed, 20 Jul 2011 18:45:29 +0000 en-US hourly 1 Adding support for Postgresql on iReport 3.0.0 http://www.playingwithwire.com/2009/01/adding-support-for-postgresql-on-ireport-300/ http://www.playingwithwire.com/2009/01/adding-support-for-postgresql-on-ireport-300/#comments Tue, 13 Jan 2009 09:33:00 +0000 http://www.playingwithwire.com/2009/01/adding-support-for-postgresql-on-ireport-300/ Shortly after getting iReport running using the fix described in this article, we ran into a new problem — the Postgresql support. After some Googeling, it became clear that one had to add the the driver for Postgresql by hand from here. If not, you will encounter this error message:

Error: java.lang.ClassNotFoundException: org.postgresql.Driver

When adding the driver, beware of what version you’re selecting. After banging our heads in the wall for a while, we realized that we picked the wrong version. On Mac OS X 10.5.6 (with all latest updates installed) the version you’re looking for is the ‘JDBC3′ branch (assuming you’re using the java version that comes with OS X). Once we figured this out, the installation was easy. First, download this file. Then you need to move it into the ‘lib’ folder in iReport.

If you’re a console user like us, here are the steps:

cd iReport-3.0.0/lib
wget http://jdbc.postgresql.org/download/postgresql-8.3-604.jdbc3.jar

Easy as pie.

]]> http://www.playingwithwire.com/2009/01/adding-support-for-postgresql-on-ireport-300/feed/ 0