Subject Re: [IBDI] Firebird and Java
Author David Jencks
On 2001.08.30 08:19:24 -0400 Ferrari Massimo wrote:
> Hello,
> does firebird provide JDBC connectivity?
yes
> I mean, can I use InterClient 2.0 provided by borland to connect to
> Firebird
> with java?

You may have to do some work, but yes. I haven't checked Borland's ic2
lately, however here are some possible problems:

1. You may need to recompile interclient (java part) on jdk 1.3 or later.
One way to do this is with the ant build script on firebirds' cvs in
interclient/dev/20/firebird/build.xml

2. On xinetd based linux systems, I don't know if borland's install
supplies an appropriate file. You want a file called interserver in
xinetd.d like this:

# default: on
# description: Interserver, java JDBC for Interbase/Firebird

service interserver
{
type = UNLISTED
port = 3060
protocol = tcp
socket_type = stream
wait = no
# only_from = localhost
user = root
# server = /usr/interclient/interserver
server = /usr/local/firebird/dev/interclient/20/bin/interserver
server_args = -l
# log_type = FILE /usr/interclient/log
log_type = FILE /usr/local/firebird/log/xinetd.log
log_on_success += PID
log_on_success += HOST
log_on_success += USERID
log_on_success += EXIT
log_on_success += DURATION
log_on_failure += USERID
log_on_failure += HOST
disable = no
per_source = UNLIMITED
}


(change paths to suit your system)

3. Borland's interclient used to have some problems with databasemetadata
calls. I fixed them on the firebird version, but don't have an installable
package. On linux systems (at least rh7 and above) it should be easy to
build both interclient and interserver using the ant script. I don't know
how to build it on windows, and there may be a compatibility problem.

> Thank you
> Massimo
>
> Community email addresses:
> Post message: IBDI@yahoogroups.com
> Subscribe: IBDI-subscribe@yahoogroups.com
> Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> List owner: IBDI-owner@yahoogroups.com
>
> Shortcut URL to this page:
> http://www.yahoogroups.com/community/IBDI
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>