kobruleht Posted March 8, 2007 Share Posted March 8, 2007 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 ClassNotFoundError!This class may not have found: postgresql-8.2-504.jdbc4.jar Any ida hot to use PostgreSQL with iReport ? Andrus. Link to comment Share on other sites More sharing options...
rjmacneil Posted March 9, 2007 Share Posted March 9, 2007 I think the JDBC Driver should be: postgresql.org.Driver Rod Link to comment Share on other sites More sharing options...
rjmacneil Posted March 9, 2007 Share Posted March 9, 2007 Sorry, I think I got that wrong. Try org.postgresql.Driver Rod Link to comment Share on other sites More sharing options...
kobruleht Posted March 12, 2007 Author Share Posted March 12, 2007 I selected this driver but clicking Test button causes erorr ClassNotFoundError!Msg: org.postgresql.DriverThis 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 More sharing options...
Waldi5001 Posted March 14, 2007 Share Posted March 14, 2007 Goto Options->Classpath set your driver.jar file there. Link to comment Share on other sites More sharing options...
kobruleht Posted March 15, 2007 Author Share Posted March 15, 2007 Class path contains C:DISTRIBPROGEDpostgresql-8.2-504.jdbc4.jar I verified, this file is present: Directory of C:DISTRIBPROGED 02.03.2007 21:36 441Â333 postgresql-8.2-504.jdbc4.jar Andrus. Link to comment Share on other sites More sharing options...
schaibaa Posted March 15, 2007 Share Posted March 15, 2007 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: Code:jdbc:«»postgresql://~~~~~~~~~~Post edited by: schaibaa, at: 2007/03/15 14:01 Link to comment Share on other sites More sharing options...
kobruleht Posted March 16, 2007 Author Share Posted March 16, 2007 I changed "JDBC URL" field in Connection Properties to jdbc:postgresql://postgresql-8.2-504.jdbc4.jar 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 More sharing options...
igp05airiau Posted March 22, 2007 Share Posted March 22, 2007 Hi, I've got the same problem. Have you find a solution ? thx... Edit : hi, i just find the solution B) ! Try this driver instead of the last sql jdbc driver : http://jdbc.postgresql.org/download/postgresql-8.1-408.jdbc2.jar Post edited by: igp05airiau, at: 2007/03/22 13:28 Link to comment Share on other sites More sharing options...
kobruleht Posted March 22, 2007 Author Share Posted March 22, 2007 I havent found any solution.It seems that it is not possible to use PostgreSQL from JasperReports. Do you know good report designer which supports Postgres ? Link to comment Share on other sites More sharing options...
igp05airiau Posted March 22, 2007 Share Posted March 22, 2007 sorry for the double post, check my last post, it's the version of jdbc driver. with iReporte 1.3.1 and the jdbc driver of my last post it's run. B) 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