Great! With XPages and the Extension Library we can connect to external databases easily! But what if you have connection problems? Or what if your queries are wrong? You want to be able to debug them, right?Â So how do you test this?
The easiest way would be ifÂ you could test right in Domino Designer.Â Luckily enough, we’re in an Eclipse environment, so there are plugins available we can install.Â And there happens to be the QuantumDB Eclipse Plugin that does exactly this.
Install the plugin
Installation is straight forward, not that different from other plugins:
- Choose File – Application – Install…
- Click Search for new features to install
- Press Add Remote Location:
- Name: Quantum DB
- URL: http://quantum.sourceforge.net/update-site
- Press Finish
- Select all features (I’m not sure you need them all, but hey, it won’t hurt you :-))
- Restart your Notes.
Use QuantumDB Eclipse Plugin
To make use of it, switch to the Quantum DB perspective: choose Window – Open Perspective – Other… and select Quantum DB.
You now get a nice screen like this:
Well… not exactly.Â You first need to add your data source(s).Â You can do this with the small little button in the top left corner to create aÂ New Bookmark…Â
You then have to Add Driver to add jdbc drivers.Â In my example, I added 2 jars for DB2: one is the actual driver, the other is for licensing.
The Class name I obtained by using the Browse…Â button.Â Finish returns you to the bookmark screen, and after a Next, you get the screen for username/password/server/… etc.Â If you’re not sure what to enter here, talk to your database manager for assistances.Â That’s it!
QuantumDB has some nice features, such as an export to Excel, so make sure you try it out!