Kettle日志表设置

Kettle的日志记录需要自己配置数据表进行存储，需要如下3个表：
– Create table
create table LOG_ENTRY
(
id_batch INTEGER,
channel_id VARCHAR2(255),
log_date DATE,
transname VARCHAR2(255),
stepname VARCHAR2(255),
lines_read INTEGER,
lines_written INTEGER,
lines_updated INTEGER,
lines_input INTEGER,
lines_output INTEGER,
lines_rejected INTEGER,
errors INTEGER,
result CHAR(1),
nr_result_rows INTEGER,
nr_result_files INTEGER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited

);

– Create table
create table LOG_JOB
(
id_job INTEGER not null,
channel_id VARCHAR2(255),
jobname VARCHAR2(255),
status VARCHAR2(15),
lines_read INTEGER,
lines_written INTEGER,
lines_updated INTEGER,
lines_input INTEGER,
lines_output INTEGER,
lines_rejected INTEGER,
errors INTEGER,
startdate DATE,
enddate DATE,
logdate DATE,
depdate DATE,
replaydate DATE,
log_field CLOB
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
– Create/Recreate primary, unique and foreign key constraints
alter table LOG_JOB
add constraint LOG_JOB_PK primary key (ID_JOB)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);

---

– Create table
create table LOG_LOGGING_CHANNELS
(
id_batch INTEGER,
channel_id VARCHAR2(255),
log_date DATE,
logging_object_type VARCHAR2(255),
object_name VARCHAR2(255),
object_copy VARCHAR2(255),
repository_directory VARCHAR2(255),
filename VARCHAR2(255),
object_id VARCHAR2(255),
object_revision VARCHAR2(255),
parent_channel_id VARCHAR2(255),
root_channel_id VARCHAR2(255)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);