HP Driver for JDBC User's Manual

80 AppendixC

HP JDBC Server

JDBC Server Logs

This is a sample of a JDBC Server log ﬁle. This log ﬁle was generated

using the LOGGING CONNECTION, LOGGING IN, and LOGGING TIMESTAMP

logging levels set in the server conﬁguration ﬁle.

17039 [12:26:14.152] Connected to SOLID DM on Wed Oct 7 12:26:14

17039 [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: 0x0000010000000100

17039 [12:26:15. 43] TID: 'SET_OPTIONS'

17039 [12:26:15. 44] [TID_SET_OPTIONS] datalen: 8 data: 0x0001000000010000

17039 [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] Disconnected

17039 [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 ﬁle shows when the server was started and the IP

address of the client. The ﬁrst column shows the UNIX process id

number (PID) of the process that is logging the information. The second

column shows the timestamp.