![[Contents]](FIGURE/CONTENT.GIF)
uCosminexus Application Server, Maintenance and Migration Guide
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
This subsection describes the connection-related trace collection points and trace information that can be collected.
The following four tables describe the event IDs, trace collection points, and PRF trace collection levels with reference to each event ID:
Table 8-88 Details of trace collection points in a DB Connector and JCA container (when connection-related processing is executed) 1
| 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 | 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 | 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 | |
Note: Event ID of DB Connector is not output, if you are using SQL Server 2005.
Table 8-89 Details of trace collection points in a DB Connector and JCA container (when a method of the java.sql.Statement interface is executed) 2
| 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 | |
Table 8-90 Details of trace collection points in a DB Connector and JCA container (when a method of the java.sql.PreparedStatement interface is executed) 3
| 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 | |
Table 8-91 Details of trace collection points in a DB Connector and JCA container (when a method of the java.sql.CallableStatement interface is executed) 4
| 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 | |
The following figure shows the trace collection points in a DB Connector and JCA container.
Figure 8-52 Trace collection points in a DB Connector and JCA container (connection-related)
![[Figure]](FIGURE/ZU073000.GIF)
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-52.
Table 8-92 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 | -- | -- |
|
| 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 | -- | -- |
|
| 0x8C25 | B | -- | -- | ||
| 0x8C27 | B | -- | -- | ||
| 13 | 0x8C20 | A | Connection ID | -- | -- |
| 14 | 0x8B82 | B | -- | -- | -- |
| 15 | 0x8B83 | B | -- | -- |
|
| 16 | 0x8C21 | A | -- | -- | |
All Rights Reserved. Copyright (C) 2013, Hitachi, Ltd.