Filter
Top Products
8
- 27
8.8 Output Log Specifications
8.8.1 Access log
8
DB CONNECTION SERVICE AND SETTING TOOL
(4) SQL text reception/processing results
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) SELECT
(b) UPDATE
(c) INSERT
Table 8.17 SELECT
Item Description
Output
log format
When
succeeded
[Date] [Error code] SID [Session ID]:SQL<[SQL text]>:Success([No. of selected records])
When failed
[Date] [Error code] SID [Session ID]:SQL<[SQL text]>:Failed
Database Message [Database error number] [Database error message]
Example
When
succeeded
2007/10/01 12:00:00.000 0x00000000 SID 00000001:SQL<SELECT COL from TABLE;>:Success(1)
When failed
2007/10/01 12:00:00.000 0x20600023 SID 00000001:SQL<SELECT COLL from TABLE;>:Failed
Database Message 0x00000388 [Oracle][ODBC][Ora]ORA-00904: "COLL": invalid identifier
Table 8.18 UPDATE
Item Description
Output
log format
When
succeeded
[Date] [Error code] SID [Session ID]:SQL<[SQL text]>:Success([No. of updated records])
When failed
[Date] [Error code] SID [Session ID]:SQL<[SQL text]>:Failed
Database Message [Database error number] [Database error message]
Example
When
succeeded
2007/10/01 12:00:00.000 0x00000000 SID 00000001:SQL<UPDATE TABLE SET COL = '1';>:Success(1)
When failed
2007/10/01 12:00:00.000 0x20600023 SID 00000001:SQL<UPDATE TABLE SET COL = 'COL';>:Failed
Database Message 0x000006ba [Oracle][ODBC][Ora]ORA-01722: invalid number
Table 8.19 INSERT
Item Description
Output
log format
When
succeeded
[Date] [Error code] SID [Session ID]:SQL<[SQL text]>:Success([No. of inserted records])
When failed
[Date] [Error code] SID [Session ID]:SQL<[SQL text]>:Failed
Database Message [Database error number] [Database error message]
Example
When
succeeded
2007/10/01 12:00:00.000 0x00000000 SID 00000001:SQL<INSERT INTO TABLE ( COL ) VALUES
('1');>:Success(1)
When failed
2007/10/01 12:00:00.000 0x20600023 SID 00000001:SQL<INSERT INTO TABLE ( COL ) VALUES
('1');>:Failed
Database Message 0x000003ae [Oracle][ODBC][Ora]ORA-00942: table or view does not exist