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.

6 comments:

  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
    Replies
    1. IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai Project Centers in Chennai

      Delete
  2. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.

    Java Training in Bangalore

    ReplyDelete
  3. Thanks for one marvelous posting! I enjoyed reading it; you are a great author. I will make sure to bookmark your blog and may come back someday. I want to encourage that you continue your great posts, have a nice weekend!

    Java Training in Bangalore

    ReplyDelete
  4. Great tips, thanks! I followed it step-by-step and everything worked out great, and its very strange for me cause I had found similar articles before, but non of them did not help me with solution of this annoying problem! Now I finally will make my project in time. By the way yesterday I found this service that also can help with database connectivity https://explainjava.com/jdbc/ if you have some troubles, so hope it will be helpful for u.

    ReplyDelete
  5. This is most informative and also this post most user-friendly and super navigation to all posts.
    Data Science
    Selenium
    ETL Testing
    AWS
    Python Online Classes

    ReplyDelete