Filter
Top Products
8
DB CONNECTION SERVICE AND SETTING TOOL
8.8 Output Log Specifications
8.8.1 Access log
8
- 26
1
OVERVIEW
2
SYSTEM
CONFIGURATION
3
SPECIFICATIONS
4
SETTINGS AND
PROCEDURE TO
OPERATION
5
INSTALLATION AND
UNINSTALLATION
6
FUNCTIONS
7
MES INTERFACE
FUNCTION
CONFIGURATION TOOL
8
DB CONNECTION
SERVICE AND
SETTING TOOL
(3) Connection/disconnection to a database
For details on [Database error number] and [Database error message] in the output
log format in the case of failure, refer to the manual for each database.
Depending on the [Error code], however, Database Message and subsequent data
cannot be output.
According to the error code, confirm the error details and take corrective actions.
Section 10.2.2 (2) Access log of DB Connection Service
(a) Connection
(b) Disconnection
Table 8.15 Connection to a database
Item Description
Output
log format
When
succeeded
[Date] [Error code] SID [Session ID]:DB Connect:[Target data source]: [Connection User Name]:Success
When failed
[Date] [Error code] SID [Session ID]:DB Connect:[Target data source]: [Connection User Name]:Failed
Database Message [Database error number] [Database error message]
Example
When
succeeded
2007/10/01 12:00:00.000 0x00000000 SID 00000001:DB Connect:DataSource:User Name:Success
When failed
2007/10/01 12:00:00.000 0x20400022 SID 00000001:DB Connect:DataSource:User Name:Failed
Database Message 0x000003f9 [Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon
denied
Table 8.16 Disconnection to a database
Item Description
Output
log format
When
succeeded
[Date] [Error code] SID [Session ID]:DB Disconnect:[Target data source]:[Connection User Name]:Success
When failed
[Date] [Error code] SID [Session ID]:DB Disconnect:[Target data source]:[Connection User Name]:Failed
Database Message [Database error number] [Database error message]
Example
When
succeeded
2007/10/01 12:00:00.000 0x00000000 SID 00000001:DB Disconnect:DataSource:User Name:Success