• 2 replies
  • Latest Post - ‏2007-12-19T01:29:36Z by Stan
1525 Posts

Pinned topic Can Not Turn Connection Loggin Off

‏2007-12-14T22:42:12Z |
We have an XML-RPC based server application which also uses an embedded Cloudscape database network server. I've been trying to turn off the connection logging and no matter which method I use the derby.log file always shows connection logging.

I've tried tunning of logging in the file using this:

I've also tried programmatically turning off logging using both of these approaches.



networkServer.getCurrentProperties().put("derby.drda.logConnections", "false");
Our derby.log file always shows connection logging.
cat derby.log
Server is ready to accept connections on port 1527.
Connection number: 1.
Connection number: 2.
Connection number: 3.
Connection number: 4.
Connection number: 5.
Connection number: 6.
Connection number: 7.
Connection number: 8.
The snippet of code I use to start the server is here.

try {
networkServer = new NetworkServerControl(serverAddress, Configuration.PERSISTENCE_PORT);


waitForServerStart();"Persistence database server started");;;;
} catch (Exception e) {
log.error(e.getMessage(), e);

I was curious if anyone has run into this problem before?


Message was edited by: TimGraf
More info:

Version: CSS10011/ Build: 224373 DRDA Product Id: CSS10011
  • listing properties --

Java Information
Java Version: 1.6.0_03
Java Vendor: Sun Microsystems Inc.
Java home: /usr/java/jdk1.6.0_03/jre
Java classpath: JavaDS.jar
OS name: Linux
OS architecture: i386
OS version:
Java user name: root
Java user home: /root
Java user dir: /xxxxxxxxxx Java Platform API Specification
java.specification.version: 1.6

Derby Information
JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
[/org/apache/derby/info/] - (224373)
[/org/apache/derby/info/] - (224373)
[/org/apache/derby/info/] - (224373)

Locale Information

INFO 2007-12-14 11:34:30,779 JavaWebServer - {derby.drda.maxThreads=0, derby.drda.keepAlive=true, derby.drda.minThreads=0, derby.drda.portNumber=1527, derby
.drda.logConnections=false, derby.drda.timeSlice=0, derby.drda.startNetworkServer=false,, derby.drda.traceAll=false}
INFO 2007-12-14 11:34:30,818 JavaWebServer - --- Derby Network Server Runtime Information ---

Session Information
Session # :4

  1. Connection Threads : 1
  2. Active Sessions : 1
  3. Waiting Sessions : 0

Total Memory : 5177344 Free Memory : 4482848

Message was edited by: TimGraf

Message was edited by: TimGraf
Updated on 2007-12-19T01:29:36Z at 2007-12-19T01:29:36Z by Stan
  • SystemAdmin
    1525 Posts

    Re: Can Not Turn Connection Loggin Off

    Well my solution seems to have been to migrate from Cloudscape to Java DB. I probably could have just gone with Apache Derby's newest release as well but I already have Java DB with the latest JDK from Sun. Changing over to Java DB required minimal effort and changes on my part and connection logging is now turned off by default as it should be.
  • Stan
    267 Posts

    Re: Can Not Turn Connection Loggin Off

    You called it. I checked and I get the same results with 10.1. This did not happen using 10.2.2. It's a 10.1 bug