Tuesday, 30 April 2013

How to setup JDBC connection in iReport


Jaspersoft, iReport doesn’t have JDBC connector for MySQL  in built. Hence to make JDBC connection to MySql database you have to download the MySql JDBC connector and configure the iReport.

Follow the steps mentioned below to set-up JDBC connection to MySql database:


2. Launch iReport designer.

3. Goto  "Tools --> Options" menu and select iReport Tab in the Options window.

4. Click on Classpath tab and Check if the MySql database driver is already present.

5. Click "Add JAR" and then locate the MySql JDBC Drivers downloaded in Step 1 and Click Ok.

6.Click "Report Datasources" icon  in toolbar.

7. Click "New" and set up a "Database JDBC Connection" using driver from Step 1.

8. Click "Test" to verify the data source works correctly.

9. Click "Save" to save the data source.

You can use this method to add database drivers/connectors for any database. Let me know, if you face any issues with this process.

1 comment:

  1. I have read your blog its very attractive and impressive. I like it your blog.

    Java Training in Chennai Core Java Training in Chennai Core Java Training in Chennai

    Java Online Training Java Online Training Core Java 8 Training in Chennai Core java 8 online training JavaEE Training in Chennai Java EE Training in Chennai

    ReplyDelete