WebFOCUS Newsletter >> Current Issue >> Get a Jump Start on Apache Derby

This document has some details on installing and setting up Derby. A couple of images are missing from the online document, namely the ones that show how to configure the MRREALM driver.

I'd like to know if anyone has had success with this and if they'd like to share any tips.

Thank you,

This message has been edited. Last edited by: Kerry,

The article is also available in a webfocus newsletter, which can be downloaded here. This document does contain the images.
BTW, I haven't looked at Derby (aka Cloudscape) yet.

Gamp,

Thanks for the link. Meanwhile, IBI has corrected the online document.

I was hoping someone would share their experience with installing/using Derby.

Cheers,

I tried this a few years ago with an old release much before there was even talk of using Derby to replace the basedir (I think I was using 762, but it might have been as late as 764).

I was attempting to use the embedded driver of Derby instead of the network version.

I seem to recall having a difficult time getting the Realm Util to actually create the repository tables, though I had no problem with ReportCaster.

Based on the article I either did something wrong when I tried this, the Realm Util handles the network version of Derby very differently from the embedded, or the technique outlined only works properly with later releases of WebFOCUS. At the time I was just playing around with Derby, and didn't have the time to troubleshoot properly to see what was actually going on.

Just in case anyone else has any trouble, however, you can verify if the tables are created properly by using the following free tool called DbVisualizer:

http://www.minq.se/products/dbvis/

The product is a JDBC Driver based database manager. It allows you to connect to any database using JDBC and view table structures, run SQL commands, etc.

Since as far as I remember there is no GUI tool for managing a Derby database, this is extremely handy when checking out what is going on in Derby.

Doug, thanks very much for the information.

I haven't started the exercise yet, but I think I recall the documentation suggesting the network version is the one to use.

Cheers,