iReport Database Connection Instructions

NM Collector Software JE (Java Edition) Collecting Software


Contact Us


Any Computer | Any Collection | for Windows, Mac and Linux.

Instructions to connect to NM Collector Software Database with iReport 3.6.1

I do not know what if anything about these instructions must be changed for later versions of iReport.
  1. Open the Services window (Menu > Window > Services)
  2. Right click on "Databases" and select "New Connection ..."
  3. Click Name drop down and select New Driver...
  4. Click the Add... button and browse to your NM Collector JE installation directory then the nmcswDB folder and open the file named derby.jar
  5. Click OK to close New JDBC Driver window.
  6. Leave User Name and Password fields blank.
  7. Enter a JDBC URL as shown below with a path to your database.  
  8. Under the Advanced tab, ensure "APP" is selected in the "Select Schema:"
  9. Click OK.
  10. In the Services window, double click the new connection to open it.
  11. There is a connections drop down at the top of the iReport 3.6.1 window.  Just to the left of it is an icon that looks like a database with a blue power cord plug super imposed on it.  Click that icon to open up the "Connections / Datasources" window.
  12. In that window, click the New button. 
  13. Select NetBeans Database JDBC connection and click Next.
  14. Name your connection.  May I suggest "NM Collector" as an appropriate name?
  15. Ensure the database service you defined in steps 1 - 10 is selected in the Connection drop down.
  16. Click the Test button if you want to test your connection.  Click Save to continue.
  17. Close the Connections / Datasources window.
  18. Now you can select your new connection in the connection drop down at the top of the iReport 3.6.1 window.
You can now use iReport to build reports against the NM Collector Software database.  How to do that is beyond the scope of these instructions but here are some hints.


Last Revised: October 16, 2010

Copyright © 2008, 2009, 2010 by Clayton J. Pryor. All rights reserved.