Subject SQL logging for interclient
Author David Jencks
Hi,

Michael Wyraz (michael.wyraz@...) has contributed an sql logging
feature to interclient 20 that I have checked in. To use it, start
interserver with the command line switch -l.

This can be done in inetd by the line

interserver stream tcp nowait root /opt/interbase/bin/interserver
interserver
-l

This can be done using xinetd with the configuration:


# 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_args = -l #this is the crucial line
log_type = FILE /usr/interclient/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
}

I don't know how to do this from windows family systems.

The sql log is put into the file /usr/interclient/interserver_sql.log.



Michael has also fixed a problem with PreparedStatement long input
parameters: the previous code was using a nonexistent BigDecimal
constructor, he changed it to use the correct factory method.

david jencks