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
2654 혹시 큐브리드 매니져 기본글꼴을 고정폭으로 해주실 생각은 없으신가요... 1 안지민 2012.12.20 5768
2653 c# 에서 개발 중인데 쿼리 처리속도가 느리네요(수정) 5 yak341 2012.12.20 22724
2652 (1개의 댓글은 작성자가 썼습니다.)비주얼 베이직 큐브리드 연동후 동시에 여러 테이블 보는 방법문의 2 secret 강남우 2012.12.21 58
2651 statdump 추가추가 질문입니다. 2 오니오니 2012.12.21 5628
2650 데이터 볼륨 자동 추가 로그 생성 안됨 3 종이 2012.12.27 7675
2649 & 등의 특수문자등이 변환되어 저장되는 경우 1 호랑이야옹 2012.12.28 10681
2648 호스트 연결이 안됩니다. 3 file 미드소나 2013.01.01 7752
» autocommit 설정 2 바람바람 2013.01.03 5357
2646 ㅠ.ㅠ 안되는 autocommit off 2 바람바람 2013.01.03 10865
2645 HA 구성 관련하여 문의 드립니다. 내용보충!! 1 secret 장경수 2013.01.08 8
2644 쿼리 관련 문의 드립니다. 2 오니오니 2013.01.09 6072
2643 데이터베이스 백업 관련 문의입니다. 1 하늘같은바다 2013.01.14 5719
2642 큐브리드 매니저 접속 관련 문의 5 secret 하늘같은바다 2013.01.14 33
2641 웹 매니져 설치 질문 3 file kudoz 2013.01.15 8647
2640 CLOB 데이터 타입 질문 1 하늘같은바다 2013.01.15 7229
2639 PHP 5.4.10 에서 드라이브 연동이안됩니다. 5 kudoz 2013.01.15 7411
2638 cubrid_connect_with_url() invalid url 에러 1 phrygia 2013.01.16 9547
2637 MS-SQL 2008 R2에서 연결된 서버로 등록하는 방법이 있나요? 1 file idonot 2013.01.16 13922
2636 지난번에 이어서 호스트 접속 안되는 문제.. 4 file 미드소나 2013.01.16 7566
2635 OPENROWSET 을 사용한 검색결과 문의 5 file idonot 2013.01.17 12771
Board Pagination Prev 1 ... 63 64 65 66 67 68 69 70 71 72 ... 200 Next
/ 200

Contact Cubrid

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