Subject Re: [Firebird-Java] Where do I put what files to use FireBird JDBC in JMagallanes
Author Mark Rotteveel
On 21-11-2014 18:08, venussoftop@... [Firebird-Java] wrote:
> I am trying to use JDBC direver to access my FireBird 2.5 database and
> have Java 1.7 on my computer. The Java app that I am trying to access
> my data from is Magallanes Project - Argentina 2005 - Grupo Calipso
> <>
> < div class="link-enhancr-element"
> style="width:1px;background-color:#e5e5e5;">
> image <>
> Magallanes Project - Argentina 2005 - Grupo Cal...
> <>
> Welcome to Magallanes. The open source project JMagallanes is an end
> user application for Olap and Dynamic Reports written in Java/J2EE.
> View on jmagallanes.sourcef... <>
> Preview by Yahoo
> In the form to connect with a SQL statment I have provided various
> classname and URLs that I have been able to Google upon but to no avail.
> I have copied the JayBird DLLs to the Windows\System32 as well as the
> JMagallanes folder but nothing helped. I also did the same by copying
> FBClient.DLL to both these two place.

For most usages Jaybird doesn't need the DLLs, so you can usually ignore

> I have also copied the jaybird-full-2.2.5.jar both both the folder
> pointed by CLASSPATH environment variable as well as the folder for
> JMagallanes, no joy

Almost all java applications ignore the CLASSPATH environment variable,
but looking at this application, this one seems to be the exception.
However if you want to reference a jar file, you need to add the
jar-file itself to the classpath, not just the folder containing the

The simplest way is to use addjar.bat included in the application:

From cmd:
addjar D:\mypath\to\jaybird-full-2.2.5.jar

This will add D:\mypath\to\jaybird-full-2.2.5.jar to the CLASSPATH.

> The question is how do I use the JayBird / JDBC driver with
> JMagallanes? What do I copy where? Any other information that I need
> to know. I am an absolute starter in Java and it's use, though I have
> been using FireBird and it's ODBC driver in Windows but I am a newbie in
> Java.
> All the help I can get for this is highly appreciated. Please advise

Looking at this tool it seems to be very basic and no longer maintained.
If you are looking for a reporting tool, you might want to consider
looking at something more mature like Jaspersoft Studio


Mark Rotteveel