This is a sample of a JDBC Server log file. This log file
was generated using the LOGGING CONNECTION, LOGGING IN, and LOGGING TIMESTAMP logging levels set in the server configuration
file.
17039 [12:26:14.152] Connected to SOLID DM on Wed Oct 7 12:26:1417039 [12:26:14.156] Connected from '15.0.121.172' by '<unavailable>'17039 [12:26:14.243] TID: 'SET_LIB_OPTIONS'17039 [12:26:14.443] TID: 'CONNECT'17039 [12:26:14.445] [connect_to_db] dbname: '/tmp/db/mydb'17039 [12:26:14.638] [connect_to_db] Connected.17039 [12:26:14.843] TID: 'SET_OPTIONS'17039 [12:26:14.844] [TID_SET_OPTIONS] datalen: 8 data: 0x000001000000010017039 [12:26:15. 43] TID: 'SET_OPTIONS'17039 [12:26:15. 44] [TID_SET_OPTIONS] datalen: 8 data: 0x000100000001000017039 [12:26:15. 55] TID: 'GET_DBMS_TYPE'17039 [12:26:15.261] TID: 'GET_INFO'17039 [12:26:15.644] TID: 'GET_METADATA'17039 [12:26:15.645] [get_metadata] metadatatypestr: 'INFO'17039 [12:26:15.844] TID: 'GET_METADATA'17039 [12:26:15.845] [get_metadata] metadatatypestr: 'max_values'17039 [12:26:19.643] TID: 'PREPARE_SQL'17039 [12:26:19.645] [TID_PREPARE] inbuf: 'select * from mytest'17039 [12:26:19.655] [After Parse] stmt_buf2: 'SELECT * FROM mytest '17039 [12:26:19.736] TID: 'EXECUTE_SQL'17039 [12:26:45.391] [TID_DISCONNECT] Disconnected17039 [12:26:45.392] Client exited.17039 [12:26:45.392] Connection ended on Wed Oct 7 12:26:45 |
This sample shows a single client connection connecting to
the /tmp/db/mydb database, issuing the SQL statement SELECT * FROM MYTEST, and disconnecting.
The beginning of the file shows when the server was started
and the IP address of the client. The first column shows the UNIX
process id number (PID) of the process that is logging the information.
The second column shows the timestamp.