A logo showing the text blog.marcnuri.com
Español
Home»Java»Getting started with JasperReports // JDBC connections (Part II)

Recent Posts

  • Fabric8 Kubernetes Client 6.4.0 is now available!
  • I bought an iPad
  • Three years at Red Hat
  • Fabric8 Kubernetes Client 6.3.1 is now available!
  • Eclipse JKube 1.10 is now available!

Categories

  • Front-end
  • Java
  • JavaScript
  • Legacy
  • Operations
  • Personal
  • Pet projects
  • Tools

Archives

  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • December 2019
  • October 2019
  • September 2019
  • July 2019
  • March 2019
  • November 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • December 2017
  • July 2017
  • December 2015
  • November 2015
  • November 2008
  • November 2007
  • September 2007
  • August 2007
  • July 2007
  • June 2007
  • May 2007
  • April 2007
  • March 2007

Getting started with JasperReports // JDBC connections (Part II)

2007-06-29 in Java / Legacy tagged BI / Business Intelligence / Jasper / Jasper Reports / Java / Reports by Marc Nuri | Last updated: 2021-02-14

This is the second part of a series of articles to get people started with JasperReports. In the second part, I'll explain how to access your database to run simple queries and show them in a very simple report created with iReport.

The first thing we need to do to get moving is to have iReport ready. So if you haven't got it installed do so. The next step is to have the database driver in your iReport library folder. This means that you will need a JDBC jar packaged driver copied to the ./lib/ directory of iReport's base folder. This step is really important not doing so will not allow you to connect to the database. Most databases provide their own JDBC driver, there are many tutorials and references that speak about JDBC.

Now is the time to configure access to your database. You have to go to the menu "Data -> Connections/Datasources". Then you must click the "New" button.

A screen shot of iReport JDBC connection dialog
A screen shot of iReport JDBC connection dialog

When you get this dialog, the first thing to do is to give a name to the connection "Name". Next is to specify the driver to connect to your database. Then you'll have to modify the JDBC URL to access your database (You can use the wizard to do this too). Finally, you must specify the username and password with permission to get access to the database. It's convenient to test the connection before saving.

With your connection ready, is time to query the database. In my case, I will be using PostgreSQL and I will build a simple query to get the database table names. For this, you must go to the menu "Data -> Report Query".

A screen shot of iReport Data -> Report Query dialog
A screen shot of iReport Data -> Report Query dialog

When you insert your SQL query, in my case SELECT * FROM pg_tables ORDER BY 1 iReport automatically gets the metadata for your query and stores them as report fields so you can use them during the development of your report.

Finally with the retrieved report fields we can now create our report. This is the result:

A screen shot of iReport print preview showing the final result
A screen shot of iReport print preview showing the final result
Twitter iconFacebook iconLinkedIn iconPinterest iconEmail icon

Comments in "Getting started with JasperReports // JDBC connections (Part II)"

  • Avatar for Barry Klawans
    Barry Klawans
    2007-06-29 18:00
    You might want to point out the "Query Designer" button in the query window.

    It brings up a graphical query builder so folks who aren't that experienced with SQL can still create a query.

    -Barry Klawans

Post navigation

← Getting started with JasperReports // Printing reports from your java app (Part III)Getting started with JasperReports // Reporting in Java (Part I) →
© 2007 - 2023 Marc Nuri