PostgreSql JDBC Driver

[openxadmin]

Hi everyone.

I have installed PostgreSql-8.2.3(latest version) and want to create a report using IReport-1.3.1.

 

I first tried to create the connection, the JDBC driver was in the drop down list, but when I asked to test the connection, IReport displayed an error message telling that the JAR file couldn´t be located in the classpath.

Then I downloaded the JDBC driver from www.postgreSql.com. I got the driver for JDBC 4 which is the standard API used by Java 1.6.0 and copied the file to <IREPORT-INSTALL>lib directory. Then the connection test worked.

 

Another problema came, The next step in Report Wizard asks you to provide a SQL statement. I entered the following SQL stat.

select * from cliente;

 

but it simply says:

SQL problems: ERROR: relation "cliente" does not exist{2}

 

I have checked if the table exists and entered the SQL statement "select * from cliente;" in the PGSQL and it worked fine.

 

Anybody helps??

[anandharaj]

I face this kind of problem when i have two/more datasource. It could be only postgresql but different database. So you need to select the datasource first.

 

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=9&id=23585#23585

[charlles]

Hi! My name is Charlles and I am Brazilian.

You are Indian, aren´t you?

 

What programming language do you use? JSE ou JEE?

 

We could keep contact to exchange knowledge.

 

My mail is charlles.cuba@gmail.com

[anandharaj]

Hi,

 

Im not a programmer, so i just know a little bit of J2SE.