8.11.1 Connection-related trace collection points and trace information that can be collected
This subsection describes the connection-related trace collection points and trace information that can be collected.
- Organization of this subsection
(1) Trace get point and the PRF trace get level
The following four tables describe the event IDs, trace collection points, and PRF trace collection levels with reference to each event ID:
-
In the case of 0x8B00, 0x8B01, 0x8B80-0x8B83, 0x8C00-0x8C03, 0x8C10-0xC13, 0x8C20-0x8C29, 0x8C2A-0x8C3F (when connection-related processing is executed)
Reference: Table 8-74
-
In the case of 0x8C80-0x8C93 (when a method of the java.sql.Statement interface is executed)
Reference: Table 8-75
-
In the case of 0x8CC0-0x8CD9 (when a method of the java.sql.PreparedStatement interface is executed)
Reference: Table 8-76
-
In the case of 0x8D00-0x8D19 (when a method of the java.sql.CallableStatement interface is executed)
Reference: Table 8-77
- Tip
-
For details about the event ID 0x8C41, see the sections 8.8 Trace collection points of an EJB container and 8.10 Trace collection points of a JTA.
|
Event ID |
No. in the figure# |
Trace acquisition points |
Level |
|
|---|---|---|---|---|
|
0x8B00 |
2 |
Immediately after invoking the connection acquisition request from the resource adapter |
B |
|
|
0x8B01 |
5 |
Immediately before the return of the connection acquisition request from the resource adapter |
B |
|
|
0x8B80 |
3 |
Immediately before the invocation of physical connection creation |
B |
|
|
0x8B81 |
4 |
Immediately after the return of physical connection creation |
B |
|
|
0x8B82 |
14 |
Immediately before the invocation of physical connection discard |
B |
|
|
0x8B83 |
15 |
Immediately after the return of physical connection discard |
B |
|
|
0x8C00 |
1 |
When a database connection is established with javax.sql.DataSource.getConnection() |
When the processing starts |
A |
|
0x8C01 |
6 |
When the processing ends |
A |
|
|
0x8C02 |
1 |
When a database connection is established with javax.sql.DataSource.getConnection(String username, String password) |
When the processing starts |
A |
|
0x8C03 |
6 |
When the processing ends |
A |
|
|
0x8C10 |
1 |
When a database connection is established with javax.sql.DataSource.getConnection() during the use of the connection pool clustering functionality (compatibility functionality) |
When the processing starts |
A |
|
0x8C11 |
6 |
When the processing ends |
A |
|
|
0x8C12 |
1 |
When a database connection is established with javax.sql.DataSource.getConnection(String username, String password) during the use of the connection pool clustering functionality (compatibility functionality) |
When the processing starts |
A |
|
0x8C13 |
6 |
When the processing ends |
A |
|
|
0x8C20 |
13 |
When the database and JDBC resources of the Connection object are released with java.sql.Connection.close() |
When the processing starts |
A |
|
0x8C21 |
16 |
When the processing ends |
A |
|
|
0x8C22 |
11 |
java.sql.Connection.commit() |
When the processing starts |
B |
|
0x8C23 |
12 |
When the processing ends |
B |
|
|
0x8C24 |
11 |
java.sql.Connection.rollback() |
When the processing starts |
B |
|
0x8C25 |
12 |
When the processing ends |
B |
|
|
0x8C26 |
11 |
java.sql.Connection.rollback(Savepoint savepoint) |
When the processing starts |
B |
|
0x8C27 |
12 |
When the processing ends |
B |
|
|
0x8C28 |
7 |
java.sql.Connection.createStatement() |
When the processing starts |
B |
|
0x8C29 |
8 |
When the processing ends |
B |
|
|
0x8C2A |
7 |
java.sql.Connection.createStatement(int resultSetType, int resultSetConcurrency) |
When the processing starts |
B |
|
0x8C2B |
8 |
When the processing ends |
B |
|
|
0x8C2C |
7 |
java.sql.Connection.createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) |
When the processing starts |
B |
|
0x8C2D |
8 |
When the processing ends |
B |
|
|
0x8C2E |
7 |
java.sql.Connection.prepareCall(String sql) |
When the processing starts |
B |
|
0x8C2F |
8 |
When the processing ends |
B |
|
|
0x8C30 |
7 |
java.sql.Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency) |
When the processing starts |
B |
|
0x8C31 |
8 |
When the processing ends |
B |
|
|
0x8C32 |
7 |
java.sql.Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) |
When the processing starts |
B |
|
0x8C33 |
8 |
When the processing ends |
B |
|
|
0x8C34 |
7 |
java.sql.Connection.prepareStatement(String sql) |
When the processing starts |
B |
|
0x8C35 |
8 |
When the processing ends |
B |
|
|
0x8C36 |
7 |
java.sql.Connection.prepareStatement(String sql, int autoGeneratedKeys) |
When the processing starts |
B |
|
0x8C37 |
8 |
When the processing ends |
B |
|
|
0x8C38 |
7 |
java.sql.Connection.prepareStatement(String sql, int[] columnIndexes) |
When the processing starts |
B |
|
0x8C39 |
8 |
When the processing ends |
B |
|
|
0x8C3A |
7 |
java.sql.Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency) |
When the processing starts |
B |
|
0x8C3B |
8 |
When the processing ends |
B |
|
|
0x8C3C |
7 |
java.sql.Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) |
When the processing starts |
B |
|
0x8C3D |
8 |
When the processing ends |
B |
|
|
0x8C3E |
7 |
java.sql.Connection.prepareStatement(String sql, String[] columnNames) |
When the processing starts |
B |
|
0x8C3F |
8 |
When the processing ends |
B |
|
- Legend:
-
A: Standard
B: Advanced
Note: Event ID of DB Connector is not output, if you are using SQL Server 2005.
- #
-
Corresponds to the numbers in Figure 8-45.
|
Event ID |
No. in the figure# |
Trace acquisition points |
Level |
|
|---|---|---|---|---|
|
0x8C80 |
9 |
execute(String sql) |
When the processing starts |
B |
|
0x8C81 |
10 |
When the processing ends |
B |
|
|
0x8C82 |
9 |
execute(String sql, int autoGeneratedKeys) |
When the processing starts |
B |
|
0x8C83 |
10 |
When the processing ends |
B |
|
|
0x8C84 |
9 |
execute(String sql, int[] columnIndexes) |
When the processing starts |
B |
|
0x8C85 |
10 |
When the processing ends |
B |
|
|
0x8C86 |
9 |
execute(String sql, String[] columnNames) |
When the processing starts |
B |
|
0x8C87 |
10 |
When the processing ends |
B |
|
|
0x8C88 |
9 |
executeBatch() |
When the processing starts |
B |
|
0x8C89 |
10 |
When the processing ends |
B |
|
|
0x8C8A |
9 |
executeQuery(String sql) |
When the processing starts |
B |
|
0x8C8B |
10 |
When the processing ends |
B |
|
|
0x8C8C |
9 |
executeUpdate(String sql) |
When the processing starts |
B |
|
0x8C8D |
10 |
When the processing ends |
B |
|
|
0x8C8E |
9 |
executeUpdate(String sql, int autoGeneratedKeys) |
When the processing starts |
B |
|
0x8C8F |
10 |
When the processing ends |
B |
|
|
0x8C90 |
9 |
executeUpdate(String sql, int[] columnIndexes) |
When the processing starts |
B |
|
0x8C91 |
10 |
When the processing ends |
B |
|
|
0x8C92 |
9 |
executeUpdate(String sql, String[] columnNames) |
When the processing starts |
B |
|
0x8C93 |
10 |
When the processing ends |
B |
|
- Legend:
-
B: Advanced
- #
-
Corresponds to the numbers in Figure 8-45.
|
Event ID |
No. in the figure# |
Trace acquisition points |
Level |
|
|---|---|---|---|---|
|
0x8CC0 |
9 |
execute() |
When the processing starts |
B |
|
0x8CC1 |
10 |
When the processing ends |
B |
|
|
0x8CC2 |
9 |
execute(String sql) |
When the processing starts |
B |
|
0x8CC3 |
10 |
When the processing ends |
B |
|
|
0x8CC4 |
9 |
execute(String sql, int autoGeneratedKeys) |
When the processing starts |
B |
|
0x8CC5 |
10 |
When the processing ends |
B |
|
|
0x8CC6 |
9 |
execute(String sql, int[] columnIndexes) |
When the processing starts |
B |
|
0x8CC7 |
10 |
When the processing ends |
B |
|
|
0x8CC8 |
9 |
execute(String sql, String[] columnNames) |
When the processing starts |
B |
|
0x8CC9 |
10 |
When the processing ends |
B |
|
|
0x8CCA |
9 |
executeBatch() |
When the processing starts |
B |
|
0x8CCB |
10 |
When the processing ends |
B |
|
|
0x8CCC |
9 |
executeQuery() |
When the processing starts |
B |
|
0x8CCD |
10 |
When the processing ends |
B |
|
|
0x8CCE |
9 |
executeQuery(String sql) |
When the processing starts |
B |
|
0x8CCF |
10 |
When the processing ends |
B |
|
|
0x8CD0 |
9 |
executeUpdate() |
When the processing starts |
B |
|
0x8CD1 |
10 |
When the processing ends |
B |
|
|
0x8CD2 |
9 |
executeUpdate(String sql) |
When the processing starts |
B |
|
0x8CD3 |
10 |
When the processing ends |
B |
|
|
0x8CD4 |
9 |
executeUpdate(String sql, int autoGeneratedKeys) |
When the processing starts |
B |
|
0x8CD5 |
10 |
When the processing ends |
B |
|
|
0x8CD6 |
9 |
executeUpdate(String sql, int[] columnIndexes) |
When the processing starts |
B |
|
0x8CD7 |
10 |
When the processing ends |
B |
|
|
0x8CD8 |
9 |
executeUpdate(String sql, String[] columnNames) |
When the processing starts |
B |
|
0x8CD9 |
10 |
When the processing ends |
B |
|
- Legend:
-
B: Advanced
- #
-
Corresponds to the numbers in Figure 8-45.
|
Event ID |
No. in the figure# |
Trace acquisition points |
Level |
|
|---|---|---|---|---|
|
0x8D00 |
9 |
execute() |
When the processing starts |
B |
|
0x8D01 |
10 |
When the processing ends |
B |
|
|
0x8D02 |
9 |
execute(String sql) |
When the processing starts |
B |
|
0x8D03 |
10 |
When the processing ends |
B |
|
|
0x8D04 |
9 |
execute(String sql, int autoGeneratedKeys) |
When the processing starts |
B |
|
0x8D05 |
10 |
When the processing ends |
B |
|
|
0x8D06 |
9 |
execute(String sql, int[] columnIndexes) |
When the processing starts |
B |
|
0x8D07 |
10 |
When the processing ends |
B |
|
|
0x8D08 |
9 |
execute(String sql, String[] columnNames) |
When the processing starts |
B |
|
0x8D09 |
10 |
When the processing ends |
B |
|
|
0x8D0A |
9 |
executeBatch() |
When the processing starts |
B |
|
0x8D0B |
10 |
When the processing ends |
B |
|
|
0x8D0C |
9 |
executeQuery() |
When the processing starts |
B |
|
0x8D0D |
10 |
When the processing ends |
B |
|
|
0x8D0E |
9 |
executeQuery(String sql) |
When the processing starts |
B |
|
0x8D0F |
10 |
When the processing ends |
B |
|
|
0x8D10 |
9 |
executeUpdate() |
When the processing starts |
B |
|
0x8D11 |
10 |
When the processing ends |
B |
|
|
0x8D12 |
9 |
executeUpdate(String sql) |
When the processing starts |
B |
|
0x8D13 |
10 |
When the processing ends |
B |
|
|
0x8D14 |
9 |
executeUpdate(String sql, int autoGeneratedKeys) |
When the processing starts |
B |
|
0x8D15 |
10 |
When the processing ends |
B |
|
|
0x8D16 |
9 |
executeUpdate(String sql, int[] columnIndexes) |
When the processing starts |
B |
|
0x8D17 |
10 |
When the processing ends |
B |
|
|
0x8D18 |
9 |
executeUpdate(String sql, String[] columnNames) |
When the processing starts |
B |
|
0x8D19 |
10 |
When the processing ends |
B |
|
- Legend:
-
B: Advanced
- #
-
Corresponds to the numbers in Figure 8-45.
The following figure shows the trace collection points in a DB Connector and JCA container.
|
|
![[Figure]](GRAPHICS/ZU073000.GIF)
(2) Trace information that can be collected
The trace information that can be collected in a DB Connector or JCA container is described below. The details are explained in correlation to the numbers of Figure 8-45.
-
Trace information corresponding to numbers 1-6 and 11-16
The following table describes the event IDs and trace information corresponding to numbers 1-6 and 11-16.
Table 8‒78: Trace information that can be collected in a DB Connector and JCA container (when connection-related processing is executed) No. in the figure#
Event ID
Level
Information that you can acquire
Interface name
Operation name
Optional
1
0x8C00
A
--
--
--
0x8C02
A
--
--
--
0x8C10
A
--
--
--
0x8C12
A
--
--
--
2
0x8B00
B
--
--
--
3
0x8B80
B
--
--
--
4
0x8B81
B
--
--
-
When normal:
Entrance-time
-
For an exception:
Entrance-time exception-name
5
0x8B01
B
--
--
6
0x8C01
A
Connection ID
--
0x8C03
A
Connection ID
--
0x8C11
A
Connection ID
--
0x8C13
A
Connection ID
--
11
0x8C22
B
--
--
--
0x8C24
B
--
--
--
0x8C26
B
--
--
--
12
0x8C23
B
--
--
-
When normal:
Entrance-time
-
For an exception:
Entrance-time exception-name
0x8C25
B
--
--
0x8C27
B
--
--
13
0x8C20
A
Connection ID
--
--
14
0x8B82
B
--
--
--
15
0x8B83
B
--
--
-
When normal:
Entrance-time
-
For an exception:
Entrance-time exception-name
16
0x8C21
A
--
--
- Legend:
-
A: Standard
B: Advanced
--: Not applicable
- #
-
Corresponds to the numbers in Figure 8-45.
-
-
Trace information corresponding to number 7
The event IDs corresponding to number 7 are as follows:
0x8C28, 0x8C2A, 0x8C2C, 0x8C2E, 0x8C30, 0x8C32, 0x8C34,
0x8C36, 0x8C38, 0x8C3A, 0x8C3C, 0x8C3E
The trace information that can be collected at these event IDs is as follows:
-
PRF trace collection level
All Advanced.
-
Interface name and operation name
Not output at these event IDs.
-
Optional
If an sql exists in the method argument, the SQL statement is displayed:
-
-
Trace information corresponding to number 8
The event IDs corresponding to number 8 are as follows:
0x8C29, 0x8C2B, 0x8C2D, 0x8C2F, 0x8C31, 0x8C33, 0x8C35,
0x8C37, 0x8C39, 0x8C3B, 0x8C3D, 0x8C3F
The trace information that can be collected at these event IDs is as follows:
-
PRF trace collection level
All Advanced.
-
Interface name and operation name
Not output at these event IDs.
-
Optional
At these event IDs, the entrance time is displayed when the processing is performed normally. When an exception occurs, the entrance time and exception are displayed.
-
-
Trace information corresponding to number 9
The event IDs corresponding to number 9 are as follows:
0x8C80, 0x8C82, 0x8C84, 0x8C86, 0x8C88, 0x8C8A, 0x8C8C, 0x8C8E, 0x8C90, 0x8C92, 0x8CC0, 0x8CC2, 0x8CC4, 0x8CC6, 0x8CC8, 0x8CCA, 0x8CCC, 0x8CCE, 0x8CD0, 0x8CD2, 0x8CD4, 0x8CD6, 0x8CD8, 0x8D00, 0x8D02, 0x8D04, 0x8D06, 0x8D08, 0x8D0A, 0x8D0C, 0x8D0E, 0x8D10, 0x8D12, 0x8D14, 0x8D16, 0x8D18
The trace information that can be collected at these event IDs is as follows:
-
PRF trace collection level
All Advanced.
-
Interface name and operation name
Not output at these event IDs.
-
Optional
If an sql exists in the method argument, the SQL statement is displayed:
-
-
Trace information corresponding to number 10
The event IDs corresponding to number 10 are as follows:
0x8C81, 0x8C83, 0x8C85, 0x8C87, 0x8C89, 0x8C8B, 0x8C8D, 0x8C8F, 0x8C91, 0x8C93, 0x8CC1, 0x8CC3, 0x8CC5, 0x8CC7, 0x8CC9, 0x8CCB, 0x8CCD, 0x8CCF, 0x8CD1, 0x8CD3, 0x8CD5, 0x8CD7, 0x8CD9, 0x8D01, 0x8D03, 0x8D05, 0x8D07, 0x8D09, 0x8D0B, 0x8D0D, 0x8D0F, 0x8D11, 0x8D13, 0x8D15, 0x8D17, 0x8D19
The trace information that can be collected at these event IDs is as follows:
-
PRF trace collection level
All Advanced.
-
Interface name and operation name
Not output at these event IDs.
-
Optional
At these event IDs, the entrance time is displayed when the processing is performed normally. When an exception occurs, the entrance time and exception are displayed.
-