Background Image

FORUM

2013.01.03 00:51

autocommit 설정

조회 수 5357 추천 수 0 댓글 2
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄

CUBRIDTransaction dbTrans = dbConn.BeginTransaction();

 

LOOP

     UPDATE TBL_POWER_NOW SET ????

 

dbTrans.Commit();

 

 

 

아래는 브로커 로그 입니다. 로그를 트랜잭션 기반으로  분석한건데 set_db_parameter auto_commit 1로 되어 있는거로 봐서는 위 프로그램

에서 트랜잭션을 쓰는 의미가 없을 듯 한데요 맞나요?

auto_commit 을 어떻게 off 시키나요? 

브로커마다 따로따로 설정 가능한가요?

 

 

C:CUBRID/log/broker/sql_log/xfra_broker_1.sql.log:32
01/02 15:32:43.921 (0) set_db_parameter auto_commit 1
01/02 15:32:43.921 (0) get_db_parameter isolation_level 1
01/02 15:32:43.921 (0) set_db_parameter isolation_level 1
01/02 15:32:43.921 (2) prepare 0 SELECT * FROM TBL_POWER_NOW
01/02 15:32:43.922 (2) prepare srv_h_id 1 (PC)
01/02 15:32:43.922 (2) set query timeout to 0 (no limit)
01/02 15:32:43.922 (2) execute srv_h_id 1 SELECT * FROM TBL_POWER_NOW
01/02 15:32:43.929 (2) execute 0 tuple 828 time 0.006
01/02 15:32:43.929 (2) fetch srv_h_id 1 cursor_pos 127 fetch_count 0
01/02 15:32:43.931 (2) fetch srv_h_id 1 cursor_pos 253 fetch_count 0
01/02 15:32:43.934 (2) fetch srv_h_id 1 cursor_pos 379 fetch_count 0
01/02 15:32:43.936 (2) fetch srv_h_id 1 cursor_pos 505 fetch_count 0
01/02 15:32:43.937 (2) fetch srv_h_id 1 cursor_pos 631 fetch_count 0
01/02 15:32:43.938 (2) fetch srv_h_id 1 cursor_pos 757 fetch_count 0
01/02 15:32:43.939 (2) next_result 1
01/02 15:32:43.939 (2) close_req_handle srv_h_id 1
01/02 15:32:43.940 (3) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=930, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=31
01/02 15:32:43.941 (3) prepare srv_h_id 1 (PC)
01/02 15:32:43.941 (3) set query timeout to 0 (no limit)
01/02 15:32:43.941 (3) execute srv_h_id 1 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=930, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=31
01/02 15:32:43.944 (3) execute 0 tuple 1 time 0.003
01/02 15:32:43.945 (4) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=937, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=937, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=32
01/02 15:32:43.945 (4) prepare srv_h_id 2 (PC)
01/02 15:32:43.945 (4) set query timeout to 0 (no limit)
01/02 15:32:43.945 (4) execute srv_h_id 2 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=937, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=937, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=32
01/02 15:32:43.948 (4) execute 0 tuple 1 time 0.003
01/02 15:32:43.949 (5) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=968, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=968, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=33
01/02 15:32:43.949 (5) prepare srv_h_id 3 (PC)
01/02 15:32:43.949 (5) set query timeout to 0 (no limit)
01/02 15:32:43.949 (5) execute srv_h_id 3 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=968, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=968, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=33
01/02 15:32:43.953 (5) execute 0 tuple 1 time 0.004
01/02 15:32:43.953 (6) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=34
01/02 15:32:43.954 (6) prepare srv_h_id 4 (PC)
01/02 15:32:43.954 (6) set query timeout to 0 (no limit)
01/02 15:32:43.954 (6) execute srv_h_id 4 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=34
01/02 15:32:43.957 (6) execute 0 tuple 1 time 0.003
01/02 15:32:43.957 (7) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=929, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=929, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=35
01/02 15:32:43.958 (7) prepare srv_h_id 5 (PC)
01/02 15:32:43.958 (7) set query timeout to 0 (no limit)
01/02 15:32:43.958 (7) execute srv_h_id 5 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=929, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=929, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=35
01/02 15:32:43.961 (7) execute 0 tuple 1 time 0.003
01/02 15:32:43.962 (8) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=950, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=36
01/02 15:32:43.962 (8) prepare srv_h_id 6 (PC)
01/02 15:32:43.962 (8) set query timeout to 0 (no limit)
01/02 15:32:43.962 (8) execute srv_h_id 6 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=950, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=36
01/02 15:32:43.966 (8) execute 0 tuple 1 time 0.004
01/02 15:32:43.966 (9) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=948, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=948, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=37
01/02 15:32:43.966 (9) prepare srv_h_id 7 (PC)
01/02 15:32:43.966 (9) set query timeout to 0 (no limit)
01/02 15:32:43.966 (9) execute srv_h_id 7 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=948, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=948, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=37
01/02 15:32:43.970 (9) execute 0 tuple 1 time 0.004
01/02 15:32:43.970 (10) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=902, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=902, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=38
01/02 15:32:43.971 (10) prepare srv_h_id 8 (PC)
01/02 15:32:43.971 (10) set query timeout to 0 (no limit)
01/02 15:32:43.971 (10) execute srv_h_id 8 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=902, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=902, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=38
01/02 15:32:43.974 (10) execute 0 tuple 1 time 0.003
01/02 15:32:43.974 (11) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=947, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=947, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=39
01/02 15:32:43.975 (11) prepare srv_h_id 9 (PC)
01/02 15:32:43.975 (11) set query timeout to 0 (no limit)
01/02 15:32:43.975 (11) execute srv_h_id 9 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=947, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=947, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=39
01/02 15:32:43.978 (11) execute 0 tuple 1 time 0.003
01/02 15:32:43.979 (12) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=965, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=40
01/02 15:32:43.979 (12) prepare srv_h_id 10 (PC)
01/02 15:32:43.979 (12) set query timeout to 0 (no limit)
01/02 15:32:43.979 (12) execute srv_h_id 10 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=965, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=40
01/02 15:32:43.983 (12) execute 0 tuple 1 time 0.004
01/02 15:32:43.983 (13) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=927, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=927, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=41
01/02 15:32:43.983 (13) prepare srv_h_id 11 (PC)
01/02 15:32:43.983 (13) set query timeout to 0 (no limit)
01/02 15:32:43.983 (13) execute srv_h_id 11 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=927, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=927, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=41
01/02 15:32:43.987 (13) execute 0 tuple 1 time 0.004
01/02 15:32:43.987 (14) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=954, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=954, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=42
01/02 15:32:43.987 (14) prepare srv_h_id 12 (PC)
01/02 15:32:43.988 (14) set query timeout to 0 (no limit)
01/02 15:32:43.988 (14) execute srv_h_id 12 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=954, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=954, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=42
01/02 15:32:43.991 (14) execute 0 tuple 1 time 0.003
01/02 15:32:43.991 (15) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=979, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=979, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=43
01/02 15:32:43.992 (15) prepare srv_h_id 13 (PC)
01/02 15:32:43.992 (15) set query timeout to 0 (no limit)
01/02 15:32:43.992 (15) execute srv_h_id 13 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=979, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=979, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=43
01/02 15:32:43.995 (15) execute 0 tuple 1 time 0.003
01/02 15:32:43.995 (16) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=44
01/02 15:32:43.996 (16) prepare srv_h_id 14 (PC)
01/02 15:32:43.996 (16) set query timeout to 0 (no limit)
01/02 15:32:43.996 (16) execute srv_h_id 14 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=44
01/02 15:32:43.999 (16) execute 0 tuple 1 time 0.003
01/02 15:32:43.999 (17) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=922, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=922, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=45
01/02 15:32:44.000 (17) prepare srv_h_id 15 (PC)
01/02 15:32:44.000 (17) set query timeout to 0 (no limit)
01/02 15:32:44.000 (17) execute srv_h_id 15 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=922, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=922, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=45
01/02 15:32:44.003 (17) execute 0 tuple 1 time 0.003
01/02 15:32:44.004 (18) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=920, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=920, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=46
01/02 15:32:44.004 (18) prepare srv_h_id 16 (PC)
01/02 15:32:44.004 (18) set query timeout to 0 (no limit)
01/02 15:32:44.004 (18) execute srv_h_id 16 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=920, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=920, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=46
01/02 15:32:44.008 (18) execute 0 tuple 1 time 0.004
01/02 15:32:44.008 (19) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=993, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=993, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=47
01/02 15:32:44.008 (19) prepare srv_h_id 17 (PC)
01/02 15:32:44.008 (19) set query timeout to 0 (no limit)
01/02 15:32:44.008 (19) execute srv_h_id 17 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=993, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=993, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=47
01/02 15:32:44.012 (19) execute 0 tuple 1 time 0.003
01/02 15:32:44.012 (20) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=957, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=957, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=48
01/02 15:32:44.013 (20) prepare srv_h_id 18 (PC)
01/02 15:32:44.013 (20) set query timeout to 0 (no limit)
01/02 15:32:44.013 (20) execute srv_h_id 18 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=957, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=957, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=48
01/02 15:32:44.016 (20) execute 0 tuple 1 time 0.003
01/02 15:32:44.016 (21) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=965, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=49
01/02 15:32:44.017 (21) prepare srv_h_id 19 (PC)
01/02 15:32:44.017 (21) set query timeout to 0 (no limit)
01/02 15:32:44.017 (21) execute srv_h_id 19 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=965, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=49
01/02 15:32:44.020 (21) execute 0 tuple 1 time 0.003
01/02 15:32:44.021 (22) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=951, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=951, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=50
01/02 15:32:44.021 (22) prepare srv_h_id 20 (PC)
01/02 15:32:44.021 (22) set query timeout to 0 (no limit)
01/02 15:32:44.021 (22) execute srv_h_id 20 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=951, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=951, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=50
01/02 15:32:44.025 (22) execute 0 tuple 1 time 0.004
01/02 15:32:44.025 (23) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=773, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=773, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=70
01/02 15:32:44.025 (23) prepare srv_h_id 21 (PC)
01/02 15:32:44.025 (23) set query timeout to 0 (no limit)
01/02 15:32:44.025 (23) execute srv_h_id 21 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=773, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=773, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=70
01/02 15:32:44.029 (23) execute 0 tuple 1 time 0.004
01/02 15:32:44.029 (24) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=790, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=790, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=71
01/02 15:32:44.029 (24) prepare srv_h_id 22 (PC)
01/02 15:32:44.030 (24) set query timeout to 0 (no limit)
01/02 15:32:44.030 (24) execute srv_h_id 22 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=790, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=790, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=71
01/02 15:32:44.033 (24) execute 0 tuple 1 time 0.003
01/02 15:32:44.033 (25) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=769, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=769, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=72
01/02 15:32:44.034 (25) prepare srv_h_id 23 (PC)
01/02 15:32:44.034 (25) set query timeout to 0 (no limit)
01/02 15:32:44.034 (25) execute srv_h_id 23 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=769, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=769, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=72
01/02 15:32:44.037 (25) execute 0 tuple 1 time 0.003
01/02 15:32:44.037 (26) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=945, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=945, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=1
01/02 15:32:44.038 (26) prepare srv_h_id 24 (PC)
01/02 15:32:44.038 (26) set query timeout to 0 (no limit)
01/02 15:32:44.038 (26) execute srv_h_id 24 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=945, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=945, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=1
01/02 15:32:44.041 (26) execute 0 tuple 1 time 0.003
01/02 15:32:44.042 (27) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=886, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=886, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=2
01/02 15:32:44.042 (27) prepare srv_h_id 25 (PC)
01/02 15:32:44.042 (27) set query timeout to 0 (no limit)
01/02 15:32:44.042 (27) execute srv_h_id 25 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=886, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=886, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=2
01/02 15:32:44.046 (27) execute 0 tuple 1 time 0.004
01/02 15:32:44.046 (28) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=950, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=3
01/02 15:32:44.046 (28) prepare srv_h_id 26 (PC)
01/02 15:32:44.046 (28) set query timeout to 0 (no limit)
01/02 15:32:44.046 (28) execute srv_h_id 26 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=950, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=3
01/02 15:32:44.050 (28) execute 0 tuple 1 time 0.004
01/02 15:32:44.050 (29) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=950, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=4
01/02 15:32:44.050 (29) prepare srv_h_id 27 (PC)
01/02 15:32:44.051 (29) set query timeout to 0 (no limit)
01/02 15:32:44.051 (29) execute srv_h_id 27 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=950, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=4
01/02 15:32:44.054 (29) execute 0 tuple 1 time 0.003
01/02 15:32:44.054 (30) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=959, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=5
01/02 15:32:44.055 (30) prepare srv_h_id 28 (PC)
01/02 15:32:44.055 (30) set query timeout to 0 (no limit)
01/02 15:32:44.055 (30) execute srv_h_id 28 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=959, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=5
01/02 15:32:44.058 (30) execute 0 tuple 1 time 0.003
01/02 15:32:44.058 (31) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=984, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=984, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=6
01/02 15:32:44.059 (31) prepare srv_h_id 29 (PC)
01/02 15:32:44.059 (31) set query timeout to 0 (no limit)
01/02 15:32:44.059 (31) execute srv_h_id 29 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=984, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=984, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=6
01/02 15:32:44.062 (31) execute 0 tuple 1 time 0.003
01/02 15:32:44.062 (32) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=921, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=921, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=7
01/02 15:32:44.063 (32) prepare srv_h_id 30 (PC)
01/02 15:32:44.063 (32) set query timeout to 0 (no limit)
01/02 15:32:44.063 (32) execute srv_h_id 30 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=921, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=921, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=7
01/02 15:32:44.066 (32) execute 0 tuple 1 time 0.003
01/02 15:32:44.066 (33) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=938, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=938, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=8
01/02 15:32:44.067 (33) prepare srv_h_id 31 (PC)
01/02 15:32:44.067 (33) set query timeout to 0 (no limit)
01/02 15:32:44.067 (33) execute srv_h_id 31 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=938, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=938, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=8
01/02 15:32:44.070 (33) execute 0 tuple 1 time 0.003
01/02 15:32:44.071 (34) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=973, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=973, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=9
01/02 15:32:44.071 (34) prepare srv_h_id 32 (PC)
01/02 15:32:44.071 (34) set query timeout to 0 (no limit)
01/02 15:32:44.071 (34) execute srv_h_id 32 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=973, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=973, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=9
01/02 15:32:44.075 (34) execute 0 tuple 1 time 0.004
01/02 15:32:44.075 (35) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=930, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=10
01/02 15:32:44.076 (35) prepare srv_h_id 33 (PC)
01/02 15:32:44.076 (35) set query timeout to 0 (no limit)
01/02 15:32:44.076 (35) execute srv_h_id 33 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=930, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=10
01/02 15:32:44.079 (35) execute 0 tuple 1 time 0.003
01/02 15:32:44.079 (36) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=959, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=11
01/02 15:32:44.080 (36) prepare srv_h_id 34 (PC)
01/02 15:32:44.080 (36) set query timeout to 0 (no limit)
01/02 15:32:44.080 (36) execute srv_h_id 34 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=959, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=11
01/02 15:32:44.083 (36) execute 0 tuple 1 time 0.003
01/02 15:32:44.083 (37) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=961, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=961, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=12
01/02 15:32:44.084 (37) prepare srv_h_id 35 (PC)
01/02 15:32:44.084 (37) set query timeout to 0 (no limit)
01/02 15:32:44.084 (37) execute srv_h_id 35 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=961, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=961, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=12
01/02 15:32:44.087 (37) execute 0 tuple 1 time 0.003
01/02 15:32:44.088 (38) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=977, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=977, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=13
01/02 15:32:44.088 (38) prepare srv_h_id 36 (PC)
01/02 15:32:44.088 (38) set query timeout to 0 (no limit)
01/02 15:32:44.088 (38) execute srv_h_id 36 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=977, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=977, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=13
01/02 15:32:44.092 (38) execute 0 tuple 1 time 0.004
01/02 15:32:44.092 (39) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=982, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=982, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=14
01/02 15:32:44.092 (39) prepare srv_h_id 37 (PC)
01/02 15:32:44.092 (39) set query timeout to 0 (no limit)
01/02 15:32:44.092 (39) execute srv_h_id 37 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=982, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=982, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=14
01/02 15:32:44.096 (39) execute 0 tuple 1 time 0.004
01/02 15:32:44.096 (40) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=932, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=932, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=15
01/02 15:32:44.096 (40) prepare srv_h_id 38 (PC)
01/02 15:32:44.096 (40) set query timeout to 0 (no limit)
01/02 15:32:44.096 (40) execute srv_h_id 38 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=932, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=932, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=15
01/02 15:32:44.100 (40) execute 0 tuple 1 time 0.004
01/02 15:32:44.100 (41) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=899, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=899, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=16
01/02 15:32:44.100 (41) prepare srv_h_id 39 (PC)
01/02 15:32:44.100 (41) set query timeout to 0 (no limit)
01/02 15:32:44.100 (41) execute srv_h_id 39 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=899, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=899, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=16
01/02 15:32:44.104 (41) execute 0 tuple 1 time 0.004
01/02 15:32:44.104 (42) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=934, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=934, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=17
01/02 15:32:44.104 (42) prepare srv_h_id 40 (PC)
01/02 15:32:44.105 (42) set query timeout to 0 (no limit)
01/02 15:32:44.105 (42) execute srv_h_id 40 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=934, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=934, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=17
01/02 15:32:44.108 (42) execute 0 tuple 1 time 0.003
01/02 15:32:44.108 (43) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=962, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=962, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=18
01/02 15:32:44.109 (43) prepare srv_h_id 41 (PC)
01/02 15:32:44.109 (43) set query timeout to 0 (no limit)
01/02 15:32:44.109 (43) execute srv_h_id 41 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=962, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=962, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=18
01/02 15:32:44.112 (43) execute 0 tuple 1 time 0.003
01/02 15:32:44.112 (44) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=996, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=996, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=19
01/02 15:32:44.113 (44) prepare srv_h_id 42 (PC)
01/02 15:32:44.113 (44) set query timeout to 0 (no limit)
01/02 15:32:44.113 (44) execute srv_h_id 42 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=996, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=996, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=19
01/02 15:32:44.116 (44) execute 0 tuple 1 time 0.003
01/02 15:32:44.116 (45) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=926, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=926, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=20
01/02 15:32:44.117 (45) prepare srv_h_id 43 (PC)
01/02 15:32:44.117 (45) set query timeout to 0 (no limit)
01/02 15:32:44.117 (45) execute srv_h_id 43 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=926, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=926, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=20
01/02 15:32:44.120 (45) execute 0 tuple 1 time 0.003
01/02 15:32:44.120 (0) end_tran COMMIT
01/02 15:32:44.120 (0) end_tran 0 time 0.000

 

 

 



 

 

 

  • ?
    이용미 2013.01.03 01:26

    안녕하세요.

    CUBRID 2008 R4.1 부터 $CUBRIDconfcubrid_broker.conf의 브로커별 파라미터로 CCI_DEFAULT_AUTOCOMMIT의 기본값이 ON으로 변경되었습니다.)

    트랜잭션으로 commit/rollback을 사용하기 위해서는 OFF로 설정해 주셔야 하며, 파라미터 값 변경 후, 브로커를 재구동 해 주셔야 해당 값이 적용됩니다.

    CCI_DEFALUT_AUTOCOMMIT에 대한 자세한 설명은 아래 매뉴얼을 참고해 주세요.

    매뉴얼 : http://www.cubrid.com/online_manual/841/pm/pm_broker_one.htm

     

    참고로, CCI API로 개발된 PHP, ODBC, OLEDB등의 인터페이스를 사용하는 프로그램에만 영향을 미치며, JDBC로 개발된 응용은 해당 파라미터와 관련이 없습니다

  • ?
    바람바람 2013.01.03 01:53

    답변 감사합니다.

    c#으로 프로그램 만들고 있는데

    ADO.Net은 적용 안되나요? OLEDB를 사용해야 하나요?


List of Articles
번호 제목 글쓴이 날짜 조회 수
공지 CUBRID 사용자를 위한 DBeaver 도구 출시 안내 admin 2024.04.23 51
공지 SQLGate for CUBRID 영구 무료 라이선스 제공 file admin 2020.04.09 4458
3993 db에 저장되어 있는 CLOB 데이터의 위치가 어디로 저장되는지 확인하는 방법이 있을까요? 1 자바천재 2024.04.25 18
3992 큐브리드 서비스 시작이 안됩니다. 1 file 황남빵 2024.04.24 25
3991 큐브리드 JDBC 드라이버 XA문의 및 큐브리드 분산트랜잭션(XA) 지원 문의 1 몽키스패너 2024.04.24 24
3990 group_concat 변수 리턴 관련... 1 썬더기 2024.04.22 23
3989 기 DB에서 테이블 정보만 가져와서 다른 DB에 생성 1 바다소금 2024.04.22 18
3988 큐브리드 매니저 속도 문의 1 연동테스트용 2024.04.22 15
3987 cubrid count 속 2 kanin 2024.04.19 29
3986 cubrid 10.1 데이터 덮어쓰기 질문입니다. 4 ysk96 2024.04.18 60
3985 ACTION 명령어? 예약어? 1 투투투투기기 2024.04.17 20
3984 sql 구문 사용시 데이터 타입 decimal일 경우 1 투투투투기기 2024.04.11 30
3983 Regexp_count 4 SEO 2024.04.09 66
3982 큐브리드 메모리 오류 관련 질문 2 file 뚜벅뚜벅 2024.04.09 67
3981 큐브리드 실행이 안되는 이슈 1 file 최현욱 2024.04.09 42
3980 unloaddb & loaddb 관련 질문이 있습니다. 1 543534512 2024.04.06 46
3979 mac m1 다운로드 오류 1 file 혜주냉면 2024.04.05 42
3978 list 함수로 만든 sequence type을 varchar로 변환 문의 1 플레이어블 2024.04.04 36
3977 DECODE, CASE WHEN 사용법 문의 2 핑크팬더 2024.04.03 55
3976 schema 파일 loaddb - 스키마 정보 중복오류 문의 4 daay 2024.03.21 91
3975 object to string 4 네오랜덤 2024.03.20 69
Board Pagination Prev 1 2 3 4 5 6 7 8 9 10 ... 200 Next
/ 200

Contact Cubrid

대표전화 070-4077-2110 / 기술문의 070-4077-2113 / 영업문의 070-4077-2112 / Email. contact_at_cubrid.com
Contact Sales