Hitachi

Hitachi Application Server V10 User's Guide (For Windows® Systems)

10.3.6 Trace collection points of JDBC

The following provides details on the trace collection points of JDBC.

The figure below shows the trace collection points of JDBC.

Figure 10‒11: Trace collection points of JDBC

[Figure]

Reference note

This figure shows the workflow for collecting traces as an extension of a request. This figure does not show all of the triggers for collecting traces Other triggers for collecting traces exist.

The table below lists event IDs, trace levels, trace collection points, and information that can be collected.

Table 10‒13: Details on the trace collection points of JDBC

Event ID

Number in the figure

PRF trace collection level

Trace collection point

Information that can be collected

Interface name

Operation name

Option

0xB600

1

Standard level

Start of the processing to establish database connection by using javax.sql.DataSource.getConnection()

-

-

-

0xB601

2

Standard level

End of the processing to establish database connection by using javax.sql.DataSource.getConnection()

-

-
In a normal state

Connection ID

In an abnormal state

Exception name

0xB602

1

Standard level

Start of the processing to establish database connection by using javax.sql.DataSource.getConnection(String username, String password)

-

-

-

0xB603

2

Standard level

End of the processing to establish database connection by using javax.sql.DataSource.getConnection(String username, String password)

-

-
In a normal state

Connection ID

In an abnormal state

Exception name

0xB604

9

Standard level

Start of the processing to release the Connection object's database and JDBC resources by using java.sql.Connection.close()

-

-

Connection ID

0xB605

10

Standard level

End of the processing to release the Connection object's database and JDBC resources by using java.sql.Connection.close()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB606

7

Standard level

Start of the processing for java.sql.Connection.commit()

-

-

-

0xB607

8

Standard level

End of the processing for java.sql.Connection.commit()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB608

7

Standard level

Start of the processing for java.sql.Connection.rollback()

-

-

-

0xB609

8

Standard level

End of the processing for java.sql.Connection.rollback()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB60A

7

Standard level

Start of the processing for java.sql.Connection.rollback(Savepoint savepoint)

-

-

-

0xB60B

8

Standard level

End of the processing for java.sql.Connection.rollback(Savepoint savepoint)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB60C

3

Standard level

Start of the processing for Connection.prepareCall(String sql)

-

-

SQL statement

0xB60D

4

Standard level

End of the processing for Connection.prepareCall(String sql)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB60E

3

Standard level

Start of the processing for Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency)

-

-

SQL statement

0xB60F

3

Standard level

End of the processing for Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB610

4

Standard level

Start of the processing for Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

-

-

SQL statement

0xB611

3

Standard level

End of the processing for Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB612

3

Standard level

Start of the processing for Connection.prepareStatement(String sql)

-

-

SQL statement

0xB613

4

Standard level

End of the processing for Connection.prepareStatement(String sql)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB614

3

Standard level

Start of the processing for Connection.prepareStatement(String sql, int autoGeneratedKeys)

-

-

SQL statement

0xB615

4

Standard level

End of the processing for Connection.prepareStatement(String sql, int autoGeneratedKeys)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB616

3

Standard level

Start of the processing for Connection.prepareStatement(String sql, int[] columnIndexes)

-

-

SQL statement

0xB617

4

Standard level

End of the processing for Connection.prepareStatement(String sql, int[] columnIndexes)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB618

3

Standard level

Start of the processing for Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency)

-

-

SQL statement

0xB619

4

Standard level

End of the processing for Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB61A

3

Standard level

Start of the processing for Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

-

-

SQL statement

0xB61B

4

Standard level

End of the processing for Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB61C

3

Standard level

Start of the processing for Connection.prepareStatement(String sql, String[] columnNames)

-

-

SQL statement

0xB61D

4

Standard level

End of the processing for Connection.prepareStatement(String sql, String[] columnNames)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB61E

5

Standard level

Start of the processing for Statement.execute(String sql)

-

-

SQL statement

0xB61F

6

Standard level

End of the processing for Statement.execute(String sql)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB620

5

Standard level

Start of the processing for Statement.execute(String sql, int autoGeneratedKeys)

-

-

SQL statement

0xB621

6

Standard level

End of the processing for Statement.execute(String sql, int autoGeneratedKeys)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB622

5

Standard level

Start of the processing for Statement.execute(String sql, int[] columnIndexes)

-

-

SQL statement

0xB623

6

Standard level

End of the processing for Statement.execute(String sql, int[] columnIndexes)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB624

5

Standard level

Start of the processing for Statement.execute(String sql, String[] columnNames)

-

-

SQL statement

0xB625

6

Standard level

End of the processing for Statement.execute(String sql, String[] columnNames)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB626

5

Standard level

Start of the processing for Statement.executeBatch()

-

-

-

0xB627

6

Standard level

End of the processing for Statement.executeBatch()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB628

5

Standard level

Start of the processing for Statement.executeQuery(String sql)

-

-

SQL statement

0xB629

6

Standard level

End of the processing for Statement.executeQuery(String sql)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB62A

5

Standard level

Start of the processing for Statement.executeUpdate(String sql)

-

-

SQL statement

0xB62B

6

Standard level

End of the processing for Statement.executeUpdate(String sql)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB62C

5

Standard level

Start of the processing for Statement.executeUpdate(String sql, int autoGeneratedKeys)

-

-

SQL statement

0xB62D

6

Standard level

End of the processing for Statement.executeUpdate(String sql, int autoGeneratedKeys)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB62E

5

Standard level

Start of the processing for Statement.executeUpdate(String sql, int[] columnIndexes)

-

-

SQL statement

0xB62F

6

Standard level

End of the processing for Statement.executeUpdate(String sql, int[] columnIndexes)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB630

5

Standard level

Start of the processing for Statement.executeUpdate(String sql, String[] columnNames)

-

-

SQL statement

0xB631

6

Standard level

End of the processing for Statement.executeUpdate(String sql, String[] columnNames)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB632

5

Standard level

Start of the processing for PreparedStatement.execute()

-

-

-

0xB633

6

Standard level

End of the processing for PreparedStatement.execute()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB634

5

Standard level

Start of the processing for PreparedStatement.execute(String sql)

-

-

SQL statement

0xB635

6

Standard level

End of the processing for PreparedStatement.execute(String sql)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB636

5

Standard level

Start of the processing for PreparedStatement.execute(String sql, int autoGeneratedKeys)

-

-

SQL statement

0xB637

6

Standard level

End of the processing for PreparedStatement.execute(String sql, int autoGeneratedKeys)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB638

5

Standard level

Start of the processing for PreparedStatement.execute(String sql, int[] columnIndexes)

-

-

SQL statement

0xB639

6

Standard level

End of the processing for PreparedStatement.execute(String sql, int[] columnIndexes)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB63A

5

Standard level

Start of the processing for PreparedStatement.execute(String sql, String[] columnNames)

-

-

SQL statement

0xB63B

6

Standard level

End of the processing for PreparedStatement.execute(String sql, String[] columnNames)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB63C

5

Standard level

Start of the processing for PreparedStatement.executeBatch()

-

-

-

0xB63D

6

Standard level

End of the processing for PreparedStatement.executeBatch()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB63E

5

Standard level

Start of the processing for PreparedStatement.executeQuery()

-

-

-

0xB63F

6

Standard level

End of the processing for PreparedStatement.executeQuery()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB640

5

Standard level

Start of the processing for PreparedStatement.executeQuery(String sql)

-

-

SQL statement

0xB641

6

Standard level

End of the processing for PreparedStatement.executeQuery(String sql)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB642

5

Standard level

Start of the processing for PreparedStatement.executeUpdate()

-

-

-

0xB643

6

Standard level

End of the processing for PreparedStatement.executeUpdate()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB644

5

Standard level

Start of the processing for PreparedStatement.executeUpdate(String sql)

-

-

SQL statement

0xB645

6

Standard level

End of the processing for PreparedStatement.executeUpdate(String sql)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB646

5

Standard level

Start of the processing for PreparedStatement.executeUpdate(String sql, int autoGeneratedKeys)

-

-

SQL statement

0xB647

6

Standard level

End of the processing for PreparedStatement.executeUpdate(String sql, int autoGeneratedKeys)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB648

5

Standard level

Start of the processing for PreparedStatement.executeUpdate(String sql, int[] columnIndexes)

-

-

SQL statement

0xB649

6

Standard level

End of the processing for PreparedStatement.executeUpdate(String sql, int[] columnIndexes)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB64A

5

Standard level

Start of the processing for PreparedStatement.executeUpdate(String sql, String[] columnNames)

-

-

SQL statement

0xB64B

6

Standard level

End of the processing for PreparedStatement.executeUpdate(String sql, String[] columnNames)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB64C

5

Standard level

Start of the processing for CallableStatement.execute()

-

-

-

0xB64D

6

Standard level

End of the processing for CallableStatement.execute()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB64E

5

Standard level

Start of the processing for CallableStatement.execute(String sql)

-

-

SQL statement

0xB64F

6

Standard level

End of the processing for CallableStatement.execute(String sql)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB650

5

Standard level

Start of the processing for CallableStatement.execute(String sql, int autoGeneratedKeys)

-

-

SQL statement

0xB651

6

Standard level

End of the processing for CallableStatement.execute(String sql, int autoGeneratedKeys)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB652

5

Standard level

Start of the processing for CallableStatement.execute(String sql, int[] columnIndexes)

-

-

SQL statement

0xB653

6

Standard level

End of the processing for CallableStatement.execute(String sql, int[] columnIndexes)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB654

5

Standard level

Start of the processing for CallableStatement.execute(String sql, String[] columnNames)

-

-

SQL statement

0xB655

6

Standard level

End of the processing for CallableStatement.execute(String sql, String[] columnNames)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB656

5

Standard level

Start of the processing for CallableStatement.executeBatch()

-

-

-

0xB657

6

Standard level

End of the processing for CallableStatement.executeBatch()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB658

5

Standard level

Start of the processing for CallableStatement.executeQuery()

-

-

-

0xB659

6

Standard level

End of the processing for CallableStatement.executeQuery()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB65A

5

Standard level

Start of the processing for CallableStatement.executeQuery(String sql)

-

-

SQL statement

0xB65B

6

Standard level

End of the processing for CallableStatement.executeQuery(String sql)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB65C

5

Standard level

Start of the processing for CallableStatement.executeUpdate()

-

-

-

0xB65D

6

Standard level

End of the processing for CallableStatement.executeUpdate()

-

-
In a normal state

-

In an abnormal state

Exception name

0xB65E

5

Standard level

Start of the processing for CallableStatement.executeUpdate(String sql)

-

-

SQL statement

0xB65F

6

Standard level

End of the processing for CallableStatement.executeUpdate(String sql)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB660

5

Standard level

Start of the processing for CallableStatement.executeUpdate(String sql, int autoGeneratedKeys)

-

-

SQL statement

0xB661

6

Standard level

End of the processing for CallableStatement.executeUpdate(String sql, int autoGeneratedKeys)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB662

5

Standard level

Start of the processing for CallableStatement.executeUpdate(String sql, int[] columnIndexes)

-

-

SQL statement

0xB663

6

Standard level

End of the processing for CallableStatement.executeUpdate(String sql, int[] columnIndexes)

-

-
In a normal state

-

In an abnormal state

Exception name

0xB664

5

Standard level

Start of the processing for CallableStatement.executeUpdate(String sql, String[] columnNames)

-

-

SQL statement

0xB665

6

Standard level

End of the processing for CallableStatement.executeUpdate(String sql, String[] columnNames)

-

-
In a normal state

-

In an abnormal state

Exception name

To Page Top

Trademarks

Copyright (C) 2015, Hitachi, Ltd.

Copyright (C) 2013, Oracle and/or its affiliates. All rights reserved.