Subject | SQL logging for interclient |
---|---|
Author | David Jencks |
Post date | 2001-06-18T19:44:39Z |
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
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