Hi,
A couple of things I wanted to ask you (or anyone that knows).
First, while its a bit off topic..I just read up on InterBase 6, and
discovered that it is free, open-source. InterBase is a pretty nice RDBMS,
and I am not sure if its better than say Hypersonic SQL, mysql, and any
other free one, but it is pretty nice for a free one. On that note, would
you happen to know if InterBase 6, because its open-source and free now, is
not as powerful (lacks features maybe) as the 5.5, 5.6 versions? I had the
5.6 version installed and it seemed to have a few other things on the
properties windows that come up that the 6.0 doesn't have. My thought here
is that perhaps they changed the way the windows are..but my main concern
is..is it a full featured RDBMS like the commercial product used to be (and
better since its a newer version), or is this free version lacking some
stuff and you have to pay for it, or the licenses for connections?
Second, we place our Oracle JDBC.jar driver in the WEB-INF/lib dir of our
apps. Is there a reason this wont work with InterClient.jar? I would rather
place it in orion/lib so that all apps running have it..but I was just
curious if there is some reason you couldn't do this.
Third, any idea on how to use the driver in the Class.forName() call? I have
the InterBase 6 server running on my box, but I would like to load the
driver in Java and use it. I can't find any instructions on this so far.
Fourth, tied to the third, I only have one server right now, but when I get
a second one, I want to move Interbase to it so that I am not hitting a
local copy of the database server. Is there any differences in how to access
the database? I assume its just //servername/path or something like that.
Here at work we use an IP address to hit our oracle database, passing to it
the password, login, etc. I am wondering if with various databases each
require a different setup, or if there is some "standard" way to access any
RDBMS, no matter what it is..so long as you have the jdbc2.0 .jar for it.
Last, is there any way that you may know of to fail-over InterBase?
Thanks.
