Topic
2 replies Latest Post - ‏2007-12-19T01:29:36Z by Stan
SystemAdmin
SystemAdmin
1525 Posts
ACCEPTED ANSWER

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 derby.properties file using this:

derby.properties
derby.drda.logConnections=false
derby.stream.error.file=../log/derby.log

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

networkServer.logConnections(false);

and

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);

networkServer.start(null);

waitForServerStart();

log.info("Persistence database server started");
log.info(networkServer.getSysinfo());
log.info(networkServer.getCurrentProperties());
log.info(networkServer.getRuntimeInfo());
} catch (Exception e) {
log.error(e.getMessage(), e);
}

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

Thanks

Message was edited by: TimGraf
More info:

Version: CSS10011/10.1.1.0 Build: 224373 DRDA Product Id: CSS10011
  • listing properties --
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.host=xxxxxxxx
derby.drda.traceAll=false

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: 2.6.16.27-0.6-smp
Java user name: root
Java user home: /root
Java user dir: /xxxxxxxxxx
java.specification.name: Java Platform API Specification
java.specification.version: 1.6

Derby Information
JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
[/org/apache/derby/info/DBMS.properties] 10.1.1.0 - (224373)
[/org/apache/derby/info/tools.properties] 10.1.1.0 - (224373)
[/org/apache/derby/info/net.properties] 10.1.1.0 - (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.host=xxxxxxx, 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
    SystemAdmin
    1525 Posts
    ACCEPTED ANSWER

    Re: Can Not Turn Connection Loggin Off

    ‏2007-12-17T22:31:30Z  in response to SystemAdmin
    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
    Stan
    267 Posts
    ACCEPTED ANSWER

    Re: Can Not Turn Connection Loggin Off

    ‏2007-12-19T01:29:36Z  in response to SystemAdmin
    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